BOL (aka Books On Line) which documents this, can be found here: http://msdn.microsoft.com/en-us/library/ms130214.aspx /Kenneth
I can't, and it doesn't.. Not for me anyway. Trying the example, the result is 2 logical reads.Table 't'. Scan count 1, logical reads 2, physical...
Both @@ERROR and @@ROWCOUNT are global variables, and they both always correlate to the *last statement* A statement could be a big SELECT or PRINT...
There's a quick way (well,'quick' depending on the volume of data in the table) to firstly check if there actually does exist any duplicate rows at...
It seems to be related to the dll that deals with SQL Servers performance counters. You might want to start by checking that the file actually exists...
The first ALTER: ALTER TABLE t2 WITH CHECK ADD CONSTRAINT fk_t2_t1 FOREIGN KEY(col1) REFERENCES t1(col1) ..this creates a FK constraint *and* also...
Just to add to the article: The bug Brian mentions about the wrong reults isn't there anymore. When doing the examples on 2005, the results are...
I'm sorry if I was being unclear. Didn't mean to comment to anyone in particular, just to the op's original post. I agree with him, and I still...
Well, your guess is incorrect, I'm very well aware of real world issues. That wasn't the point. The op was about the general statement made by his...
The correct formula to concatenate the example range, 'e00001' - 'e10000', from ints ranged between 1 and 99999 would be: empcode as ( 'e' +...
I still have an ancient app that runs towards a SQL Server 2005 happily based on dblib. We're not going to touch it basically since it's not...
I've mostly seen this error in conjunction with instable networks or misspelled/wrong configured connections. /Kenneth
This is exactly how it's supposed to work. If you're running a default instance on the default port, all you need to specify is the servername...
Well, I'd say 'it depends', but I don't see any logical problems with it. To the OS, it's just volumes, it doesn't care if it's local disk or a SAN....
It seems like a codepage / ascii conversion issue. Both the apostrophe and Æ are extend ascii (above ascii 127) and may me mapped wrong if the...
Degrading performance over time isn't antything inherent to T-SQL in particular, but rather a general symptom of resource starvation. We always have...
Other reasons - very simplified: -- high duration (i/o bound) select col1 from veryLargeTable -- high cpu (cpu bound) select col1, <very complex...
imo, declining use of FK's as DRI on the grounds that it 'hurts performance' is a sure sign you need to go find another job. (or get some education,...
Depending on how your team and users are organized, perhaps RESTRICTED USER could be an option then? (it allows more than just one user) /Kenneth
After you have made some datatypeconversions on a table for the purpose of saving space, you need to also 'compact' the table by rebuilding (or...
Separate names with a comma.
