Viewing 15 posts - 76 through 90 (of 507 total)
Ninja's_RGR'us (11/15/2011)
tfifield (11/15/2011)
November 15, 2011 at 5:46 pm
Just to add another 2 cents. Objects with prefixes to explain what they are also don't sort in a friendly manner so as to be able to find them....
November 15, 2011 at 2:07 pm
Just to further clarify what Gale posted, SCOPE_IDENTITY returns the last identity inserted in the current scope, which is not necessarily the same as the current session. This script...
November 15, 2011 at 1:47 pm
paul.jones (11/14/2011)
Have you got an ascending ID (e.g. an identity field or date column) and you are adding records in ascending...
November 15, 2011 at 12:46 pm
SQL Kiwi (11/13/2011)
I agree that sequence tables should be dedicated and not co-opted for anything else, but another way to reduce deadlocking would be to run a row-versioning isolation level...
November 14, 2011 at 1:48 pm
SQL Kiwi (11/6/2011)
TheSQLGuru (11/3/2011)
It is QUITE difficult (without the OUTPUT clause anyway, which is thankfully available now) to do sequencing like this.
We've always been able to do it safely and...
November 13, 2011 at 1:45 pm
Ganesh,
This depends on how you would rather handle it in the stored procedure vs the front end. If there's a very good reason for the front end to handle...
November 11, 2011 at 11:26 am
Eric M Russell (11/1/2011)
November 1, 2011 at 12:00 pm
Kiara (10/31/2011)
October 31, 2011 at 12:34 pm
Alexander,
Point taken. I just didn't want the OP to get the idea that heaps give better performance than clusters.
Todd Fifield
October 27, 2011 at 1:58 pm
alexander.suprun (10/25/2011)
drew.allen (10/25/2011)
dva2007 (10/25/2011)
October 27, 2011 at 12:28 pm
Ninja's_RGR'us (10/19/2011)
tfifield (10/19/2011)
Indexes fragmented more than 30% really should be rebuilt rather than reorganized.Todd Fifield
Unless you need to keep the table online and don't mind having it run longer ;-).
But...
October 19, 2011 at 12:55 pm
Since 2005 I don't use correlated sub-queries in the SELECT part of a query for more than a very simple single value. I do still use them in the...
October 19, 2011 at 12:48 pm
Indexes fragmented more than 30% really should be rebuilt rather than reorganized.
Todd Fifield
October 19, 2011 at 11:33 am
Do you have any linked servers? Normally when I see SPID -2, that's DTC. I've never seen it as a blocking SPID, but I've seen it as a...
October 13, 2011 at 2:05 pm
Viewing 15 posts - 76 through 90 (of 507 total)