OK, I have to share (read "vent"). My company almost daily gets data to load into SQL Server, and it comes in Excel, because Excel has that nice...
Hi all - I notice this morning that if I use DBCC SHRINKDATABASE on a database having multiple data files, only the first data file shrinks while...
It's looking like a busy summer for me: we just ordered a new HP DL380 G5 / 2 x 2.33 GHz Quad Core Xeon E5345 / 16 GB RAM With a new wrinkle (for me...
Just got my new HP ML370 G5 2 x 4 core 2.33 gHz machine. I'll post my progress testing it here.
Does anyone know if the update statistics command will use multiple processors? I am tuning some maintenance jobs and I wonder if there'd be an...
I'm looking at a new small-ish server such as: HP Proliant ML370 G5 SAS 2 x 2.33 GHz Quad Core Intel E5345 or 2 x 2.66 GHz Quad-Core Intel X5355...
We are one of the US' largest property management companies, seeking a SQL Server DBA to run/manage/tune databases for accounting, payroll, time...
All - at risk of embarassing myself publicly, I am going to post the detail about a failed upgrade of a production server from 2000 to 2005. It is my...
I had a nasty experience yesterday - I was planning to use synonyms for linked server references in some procedures, but when I exchanged the...
Experts! I have a challenge. I have an existing system to which I need to add storage capacity, for the best possible performance per dollar. I...
I recently had a need to create a utility for managing backup files, and thought I would post it both to share and to see if anyone had suggestions...
I have created a maintenance routine to update statistics during the night; I am wondering if it's optimal to allow SQL Server to set the sample...
This is one of those problems that ought not to exist, yet does, through bad planning by a vendor, which I am now forced to fix anyway <img...
Hi all - I've just hit a nasty bug in SQL Server 2005 (I was surprised, because the testing we've done did not yield any up to now) Basically I...
I have seen others complain of this, and now have experienced the joy myself:<br /><br />I have SSMS running on my workstation from which I...
create function deL33t( @youngGuyMessage nvarchar(4000) ) returns nvarchar(4000) as /* I must officially be a GRUMPY OLD MAN, because I suddenly...
Just a thought: it might be useful if the labels the system applies to people were something that really shows it's just based on post count, not...
Hey guys - <br /><br />Been testing 2005, and I like it very much. One troublesome thing -- there's a particular query we have that performs much,...
Quick question, as the specs on the web and in BOL seem ambiguous. Is it possible to run Windows Server 2003 Enterprise on a 32 bit system with SQL...
I am tuning fill factors, and my brain is slightly fried, so I wonder if someone can confirm this: If a table is clustered on an identity column,...
Separate names with a comma.
