SQL Server Storage Engine & Tools (SSQA.net)

SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?

SQL Master — Thu, 04 Sep 2008 08:00:00 GMT

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...(read more)

Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line

SQL Master — Fri, 29 Aug 2008 20:58:00 GMT

In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing...(read more)

How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?

SQL Master — Thu, 28 Aug 2008 08:01:00 GMT

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...(read more)

Working with DateTime data types in SQL Server, guidelines and explanations!

SQL Master — Tue, 26 Aug 2008 07:41:00 GMT

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...(read more)

SQL Server Auditing and Logging - SSIS Audit Transformation comes handy for you in database platform

SQL Master — Thu, 21 Aug 2008 08:40:00 GMT

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial...(read more)

SQL Server 2008 Books OnLine (BOL), latest and updated

SQL Master — Tue, 19 Aug 2008 07:32:00 GMT

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...(read more)

SQL Server 2005 supportability on virtual environment

SQL Master — Wed, 30 Jul 2008 08:39:00 GMT

Virtualization and Consolidation is still a hot topic and revising SQL Server consolidation and virtualization - hot topic in the industry related post here that you can easily manage the resources by using virtual machine technology that enables multiple...(read more)

SQL Server data and log files initialization, think multiple files, backup & restore performance!

SQL Master — Fri, 25 Jul 2008 11:01:00 GMT

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...(read more)

Cumulative Update 8 package for SQL Server 2005 Service Pack2

SQL Master — Wed, 16 Jul 2008 09:50:00 GMT

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...(read more)

SQL Server 2005 - How to compare content of tables without using third party tools?

SQL Master — Fri, 04 Jul 2008 08:36:00 GMT

You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare...(read more)

SQL Server Express - get sample kits in express way

SQL Master — Mon, 30 Jun 2008 08:30:00 GMT

For every new user in SQL Server world and experienced users to get used to newer version of SQL Server, having sample kit will definetly help out. In this scenario I often get emails asking about any samples or documentation (procedures) to get more...(read more)

Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?

SQL Master — Tue, 24 Jun 2008 08:02:00 GMT

The following error is a frequent-faced issue by any SQL Server user : SQL Server is unavailable or does not exist or SQL Server does not exist or access denied In this regard we have already relevant post PotentialCauses_Resolution here, but still I...(read more)

SQL Server 2005 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

SQL Master — Thu, 19 Jun 2008 08:01:00 GMT

Usage of SQL Mail is quite common within SQL Server environment, recently I have involved at one of the client's site with the error: Msg 17930, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client cannot...(read more)

SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?

SQL Master — Thu, 05 Jun 2008 07:50:00 GMT

Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server...(read more)

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

SQL Master — Tue, 03 Jun 2008 08:07:00 GMT

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...(read more)