Viewing 15 posts - 58,126 through 58,140 (of 59,048 total)
CONVERSELY... smaller fill factors also means SELECTs have to wade through more blank pages which will slow them down. If the table is a static lookup table (one that rarely,...
June 12, 2006 at 7:33 pm
Vladan! Good to "see" you... Now that was funny! Thanks for the laugh...
June 12, 2006 at 7:25 pm
Nope, sorry... I'm afraid only the boys in Redmond know the answer to that one (Group By/Distinct time changes) although it does make one question the myth that clustered indexes...
June 11, 2006 at 3:38 pm
Sorry I'm so late on this one (2 1/2 years aint too bad
)... just ran across it...
ISNUMERIC is not a good thing to...
June 11, 2006 at 3:10 pm
The problem with these types of groupings is trying to get the ranking to change where there is duplicate information, otherwise, the dupes will have the same rank. The only...
June 11, 2006 at 10:12 am
| If nothing else, it will help the developer that comes after me. |
I wish more folks programmed with that...
June 10, 2006 at 10:58 pm
I've heard that the SDK for SQL Server has some fairly powerful encryption tools that 3rd part software will not be able to crack.
June 10, 2006 at 3:25 pm
For a lot more information on the differences between Temp Tables and Table Variables, see the following URL...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
June 10, 2006 at 3:16 pm
Wow! Nice job of testing! That's some awesome feedback, Peter.
It also goes to show that the machine can make a bit of a difference, as well. My testing was done...
June 10, 2006 at 8:40 am
I'm thinking this is a bit of an orphan post...
June 9, 2006 at 8:27 pm
| I like code to be self-documenting so I know wth I was doing when I have to maintain... |
June 9, 2006 at 8:22 pm
Not really... as previously pointed out, the execution plans are identical... and so are their execution times on a quiet non-networked server... here's my test results on a million row...
June 9, 2006 at 8:11 pm
This will not find the tables affected by calls to other procs within the proc identified as @objname... but it may do what you ask... and, you get some column...
June 9, 2006 at 7:41 pm
Every so often I have to remind myself that starting from scratch may actually be faster in the... |
June 9, 2006 at 5:45 pm
Viewing 15 posts - 58,126 through 58,140 (of 59,048 total)