Viewing 15 posts - 5,986 through 6,000 (of 6,103 total)
I have to agree with Nigel on this one: it is a good thing for a DBA to be a control freak. It's not unusual for performance issues to...
November 14, 2001 at 7:50 am
quote:
For other professions, doctors, lawyers, accountants and engineers, the certification is statutory. That is, the government, usually states, manage the certification. With...
November 13, 2001 at 5:48 pm
Reaching here as well, but you said you tried a batch command and it failed... Can you successfully run xp_cmdshell from say Query Analyzer? Something simple such as a...
November 13, 2001 at 7:15 am
What version and service pack is your SQL Server? I'm assuming when you say you upgraded Enterprise Manager, you're speaking of a client system.
Also, under what set of client...
November 12, 2001 at 12:19 pm
I'm in the same boat as Steve. Have my MCSE, but haven't had the time to work towards the MCDBA. Good thing Microsoft decided to keep NT 4.0...
November 12, 2001 at 10:05 am
It's not the db, but the firewall/router where the access needs to be configured. Basically, an access list would be created that only a request to port 1433 from...
November 8, 2001 at 7:19 pm
We have been burned by people claiming certs, so we actually have set up a pretty rigorous interview as well. My manager is a developer (he's the resident VB...
November 6, 2001 at 9:18 am
How are you running isqlw? As a command line utility or are you essentially "shelling out" to it so that the user can type commands?
If command-line, here's something from...
November 6, 2001 at 9:05 am
How about apps that REQUIRE case-sensitive databases that are on the open market? There's a certain HR package that I've grown to loathe that requires case sensitivity. Grrr!
K....
October 29, 2001 at 6:50 am
Which version of SQL Server are you using? I'm assuming 7.0, but I want to verify. Also, are you using ASP, Cold Fusion, etc?
K. Brian Kelley
If you are just looking at finding all constraints, regardless of type, use the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view. It only returns information on objects the user has permissions to, but if...
October 24, 2001 at 10:23 am
I bought the SQL 2K book. It covers, as would be expected, some of the performance enhancements that are found in SQL 2K.
K. Brian Kelley
October 19, 2001 at 3:57 pm
This is because the 'PerformanceBased_PerCent' isn't yet available. The aliased field can't be used by your expression. You'll find that the aliased column is also unavailable in the...
October 18, 2001 at 11:50 am
Your first query:
quote:
SELECT *FROM tbl1
LEFT OUTER JOIN tbl2 ON tbl1.key = tbl2.key
WHERE tbl2.filter = 1
AND tbl2.key IS NULL
October 18, 2001 at 11:24 am
It sounds like your files are being kept on the filesystem and not as BLOBs. Is this correct? As Andy asked, what does SQL Server do in this configuration?
K....
October 12, 2001 at 7:15 am
Viewing 15 posts - 5,986 through 6,000 (of 6,103 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy