SqlServer-QA.net

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?  blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking to handle these important tasks in hand with the scripts and not to leave to the GUI or API ...

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 in terms of 24/7 usage. By default you can enable of disable this PAGE_VERIFY option by ...

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 you must consider the hardware such as RAID, as the software data block ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server ...

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in addition to the avoiding the fragmentation on indexes with optimization tasks. This may be ...

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, in this regard review the blogs by SQLQuery Processing team about offline ...

How do you define the terms ''Performance Monitoring''? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the questions above, in general getting know more about performance monitoring methods is not ...

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server ...

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature,  so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and reduce the storage requirements for your data. SQL Server 2008 provides ...

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations, handling this issue within SQL Server 2005 is not a problem as there are DMVs to extend ...