Last month, I purchased the D-Link DNS-323 2-Bay Network Storage Enclosure (http://www.dlink.com/products/?pid=509), along with two Samsung 750GB hard drives (mdel number HD753LJ). I installed the two drives into the enclosure, and upgraded the firmware to v1.05. However, when I tried to format the drives using RAID1, it just went up to 94% and stayed them everytime […]
Month: September 2008
When creating non-clustered indexes, you should never include the clustered index key fields (commonly used for the primary key) as part of the non-clustered index. This is because the fields will always be used within queries. There is no need to specify them again. The only exception to this, would be if the clustered index […]
While going through “Question of the day” from http://www.sqlservercentral.com/, I discovered an issue with the ISNULL function.
If you were to run the query in this script you will be surprised to hear, that the result returned is “A”. I am sure you would expect the result to be “ABC”.
This query can be used to identify those indexes that should be rebuilt (using ALTER INDEX REBUILD WITH (ONLINE = ON), or those that should be reorganized (USING ALTER INDEX REORGANIZE)
If yes, then following the instructions below[ref]Please ensure you test any script taken from my website on a test/development machine, before running on a production server.[/ref], from MSDN (http://msdn.microsoft.com/en-us/library/ms179254.aspx): Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them. See my note below Export […]
Script to return a list of database tables (the schema and table name) along with a count of the records within each table. This can come in useful if you are trying to compare databases.
If you are trying to install SQL Server 2005, and receive an error regarding the SQL Server Native Client package being missing, go to your “servers” install CD/folder, and right-click on the sqlncli.msi file, and click on Uninstall. Once uninstalled, just re-run the setup again, and it should install successfully.