SqlServer-QA.net

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 ...

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By default you can see a failover cluster as a combination of one or more nodes (servers) with two or ...

To make better use of features and enhancement within Windows Server 2008 release and SQL Server 2008, where the ability to connect the Management Studio (SSMS 2008) at the server rather than running it locally. Buck Woody SQL Program Manager has given this excellent feature outcome that has been shared by fellow Principal Architects in ...

Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer the multiple servers with the configuration settings & setup! It is changed now where ...

What can I say, excellent hint from SQL Server Goddess aka 'Kalen Delaney' to achieve an execution of a batch multiple times with a simple 1 word statement. I feel I was late to share this tip within my community, so here it is RunABatchMultipleTimes

This sounds like a joke that ''How many DBAs you need to change a light bulb?''. I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by a DBA or how many DBAs you need to manage a 400+ SQL Servers within their ...

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then ensure to test them by restoring on to the standby server. This is a best practices than assuming ...

So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc.  No doubt that Server Consolidation and avoiding performance loss is a major job for a Systems ...