Viewing 15 posts - 8,041 through 8,055 (of 14,953 total)
Prefixing procs with "sp_" causes a small but definite performance reduction. It also means that, if there's a proc in master with the same name, you can end up...
October 21, 2009 at 9:03 am
Steve Jones - Editor (10/21/2009)
October 21, 2009 at 9:00 am
Silverfox (10/21/2009)
GSquared (10/21/2009)
Grant Fritchey (10/20/2009)
October 21, 2009 at 8:07 am
jcrawf02 (10/21/2009)
GSquared (10/20/2009)
(I have over a Terabyte of storage on my home computer. I don't view 1 Gig as a significant amount of disk space these days.)
Isn't that just...
October 21, 2009 at 7:55 am
Well, that certainly gives a good interview question to ask. We've evolved it to, "You have a database with a corrupted or lost page, and the backup chain is broken...
October 21, 2009 at 7:48 am
In the case of data that doesn't change, that's better off in a read-only database or read-only file. SQL Server won't even attempt to take locks on read-only data,...
October 21, 2009 at 7:38 am
irozenberg (10/18/2009)
Thank you for your article. I would like to add my 2 cents:
- xml data-type should be and must be strongly-typed (i.e. client has to pass not just...
October 21, 2009 at 7:34 am
Grant Fritchey (10/20/2009)
October 21, 2009 at 7:26 am
The main reason that the Not In version is slow is almost certainly that it's concatenating columns in the Where clause. That kind of thing almost always results in...
October 21, 2009 at 6:46 am
October 21, 2009 at 6:39 am
And you might be shocked by how many people who call themselves DBAs or who even have jobs as DBAs can't answer that question. I've met dozens.
October 20, 2009 at 2:32 pm
Reboot when you have to, never otherwise.
Rebooting forces SQL Server to rebuild all execution plans. It can take a smoothly running server and slow it down for a day...
October 20, 2009 at 2:00 pm
You're welcome.
You can get pretty fancy with it pretty easily. It's easy to add column headers (just add them as the top row of the grid when you add...
October 20, 2009 at 1:59 pm
Since rows in a relational database don't have a definite order, you'll need to do this in preprocessing.
I've seen systems that use .NET code to step through the text file...
October 20, 2009 at 1:55 pm
No way I know of to do that in 2005. Might be able to use the resource governor in 2008 for that, not sure.
October 20, 2009 at 1:50 pm
Viewing 15 posts - 8,041 through 8,055 (of 14,953 total)