Oct 15 2009 11:00AM GMT
Posted by: mrdenny
T/SQL,
SQL,
Index,
Unique Index
If you work with any of the other big database platforms you’ve probably noticed that SQL Server’s implementation of a unique index is “different” than the others. Until now there hasn’t been a way to fix that without using a trigger. Until now… Continued »
Oct 7 2009 7:50AM GMT
Posted by: mrdenny
DTS,
SSIS,
SQL Server 2008,
SearchSQLServer.com
I recently published an article on SearchSQLServer.com about DTS and SSIS where I talk about some of the differences. Obvsiolly I didn’t cover all the differences between DTS and SSIS, just some of them. So don’t go railing on me that I didn’t cover something.
Denny
Oct 5 2009 11:00AM GMT
Posted by: mrdenny
SQL Server 2005,
Installation,
SQL
When installing SQL Server 2005 SP3 you may get an error about the password being to short, and it may have nothing to do with your sa password. It’s because the Install Scripts are trying to create a certificate with a password which doesn’t meet your domain’s password requirements.
If you get this error navigate to the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Upgrade folder. Find the script for upgrading the SQL Agent. Open the script and find the CREATE CERTIFICATE statement. Make the password longer. In my case I added 123456@ to the end of the password. The password is in two different places in the script.
Then open Add/Remove Programs and select SQL Server 2005 and select Change. Then run though the wizard to complete the installation of the service pack.
Denny
Sep 17 2009 11:00AM GMT
Posted by: mrdenny
T/SQL,
Index Performance,
Index Scan,
Index Seek,
Indexing
The datetime data type can be one of the hardest to work with when it comes to index optimization. Most queries that use a datetime data type for filtering (part of the where clause) only want to match the date portion of the value. Most people handle this via a convert function around the date column. This causes the index that you create to become useless as the convert function causes the index to be scanned not seeked.
Continued »
Sep 14 2009 5:24PM GMT
Posted by: mrdenny
SQL Server 2008,
iSCSI,
Starwind,
Webcast
A white paper which I wrote for Starwind Software is now available. The link to register for the webcast (October 21, 2009) has also been put up. The webcast and white paper go together, so I recommend that you grab the white paper now and I hope to see you at the webcast next month.
Denny
Sep 9 2009 1:55AM GMT
Posted by: mrdenny
SQL Server,
Index Performance,
Statistics,
Performance Problems,
SQL Server 2005,
SQL Server 2008,
SQL Server 2000,
White Paper
Today I’m publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy. Continued »
Sep 1 2009 6:31PM GMT
Posted by: mrdenny
Article,
SQL Server Magazine,
Clustering,
SQL Server 2008,
Windows 2008
For those of you who haven’t check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on Windows Server 2008. This is an updated version of the article I did last December on Clustering SQL Server 2005 on Windows Server 2003.
I hope that you find it handy. (Subscription is required.)
Denny