Monthly Archives: May 2007

Reducing Database Size by Using VarDecimal datatype

Reducing Database Size by Using Vardecimal Storage Format The vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can be enabled at a table-level granularity. When enabled, … Continue reading

Posted in SQL Server 2005 improvements | 25 Comments

Archieve High Availability for SQL Server

Achieve High Availability for SQL Server High availability is a concept that every database administrator should understand. It refers to the responsiveness and accessibility of a system. Sometimes high availability means a response time of seconds while other situations require … Continue reading

Posted in High Availability for SQL Server | 25 Comments

Security Best Practices – Operational & Admin Tasks

SQL Server 2005 Security Best Practices – Operational and Administrative Tasks Writers: Bob Beauchemin, SQLskills  http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx  http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc This white paper covers some of the operational and administrative tasks associated with Microsoft® SQL Server™ 2005 security and enumerates best practices and operational and … Continue reading

Posted in Uncategorized | 3 Comments

SQL 2005 Full-Text Search: Internals and Enhancements

SQL Server 2005 Full-Text Search: Internals and Enhancements   Summary: See the benefits and new features of SQL Server 2005 full-text search for both developers and database administrators. (23 printed pages) Contents IntroductionWhat Can Full-Text Search Do for Me?Full-Text Search … Continue reading

Posted in Full-Text Search | 28 Comments

Connectivity and SQL Server 2005 Integration Services

Connectivity and SQL Server 2005 Integration Services Microsoft and Bob Beauchemin released a whitepaper that talks about connectivity issues that you may come across in SSIS. Summary: This whitepaper enumerates the connectivity options for databases with SQL Server Integration Services … Continue reading

Posted in SSIS | 11 Comments

SQL Server 2005 Edition upgrade.

There is no GUI option to upgrade SQL Server 2005 Edition upgrade. You have to run the following command from command window and make sure you change your directory to installation folder…   To upgrade Default instace: setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER … Continue reading

Posted in SQL Server 2005 Upgrade | 100 Comments

Script to find used and un-used indexes in SQL Server 2005

Script to find Used indexes in the current database… SELECT so.name AS ‘Table Name’, si.name AS ‘index Name’, si.type_desc AS ‘Index Type’, si.index_id AS ‘Index ID’, us .user_seeks, us.user_scans, us.system_seeks, us.system_scans FROM sys.dm_db_index_usage_stats us INNER JOIN sys.objects so ON us.object_id … Continue reading

Posted in SQL Server Scripts | 100 Comments