Viewing 15 posts - 601 through 615 (of 814 total)
For anyone looking at this now:
A) This does also work on SQL Server 2005, 2008 and 2008 R2, both 32 and 64 bit.
B) This is, of course, subject to the...
February 22, 2011 at 10:13 am
Bah; many defragmentation products, both OS/filesystem level and SAN level, will defrag database files which are in use, while they're still being used.
NOTE: the very act of defragging uses up...
February 16, 2011 at 12:36 pm
Brandie Tarvin (2/15/2011)
February 15, 2011 at 12:13 pm
Note: When we're saying "separate" we mean "entirely different spindles" at a real, physical level. Drive letters on local disk or SAN often share spindles with each other or...
February 15, 2011 at 9:40 am
Jeff Moden (2/12/2011)
To go along with what Gail said above...
When used properly do "Divide'n'Conquer" a large "problem", you can get absolutely mind boggling blinding speed out of some queries. ...
February 15, 2011 at 9:29 am
Anamika (2/14/2011)
Thanks,It is working fine. I wonder on what scenario I've gone for Global Temporary tables. 🙁
Thanks,
Ami
+1 on sending a normal #temp table into dynamic SQL!
I've used global temp...
February 14, 2011 at 5:25 pm
Rayven (2/7/2011)
Agencies can be sods. I interviewed a guy for one position and when I asked him about his experiences with one technology...
February 10, 2011 at 10:33 am
For any old platforms that one deliberately tries to keep in service... stockpile parts and keep bare metal restore capable drive images available, or virtualize it while you still can....
February 10, 2011 at 10:23 am
If you've been shrinking and growing weekly for awhile, you should check for filesystem (OS) level fragmentation with the OS defrag, Defraggler, or another tool, as well as index level...
February 8, 2011 at 9:05 am
Ask your SAN expert about whether or not your LUN is assigned up front in a contiguous block, or as you write to it.
February 8, 2011 at 8:28 am
Adam Sottosanti (2/3/2011)
Agreed. I try to avoid the cartesian joins during matching as much as I can, and generally require certain demographics to match (inner join on DOB +...
February 3, 2011 at 5:10 pm
Adam Sottosanti (2/3/2011)
Sweet, thanks Mike! If I ever get some free time, maybe I'll run some side by side compares. I run new records through multiple "rounds" of matching against...
February 3, 2011 at 12:22 pm
For addresses, I'd recommend first using nested REPLACE()'s (SQL Server 2000, at least, will easily go 100 or 120 deep) to standardize abbreviations. You'll have to look at your...
February 3, 2011 at 11:45 am
Taggs, please do continue to present your point of view; I find that the most valuable part of almost all really useful articles here are the discussions!
In this case, as...
January 27, 2011 at 7:30 am
A good basic article about of two of the four major backup problems I commonly see:
1) Not having backups at all
2) Not having transaction log backups at all (unlimited log...
January 26, 2011 at 11:18 am
Viewing 15 posts - 601 through 615 (of 814 total)