SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Data partitioning & Data lifecycle within that DW environment.  Also buidling up ...

One of the best features you have in the SQL Server is to create database data file (additional) on fly without  having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that is used for the databases and how big disk queue length in terms of I/O ...

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Then it comes what kind of practice you should deploy in order to obtain the ...

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version.   Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and most of the times we have to depend upon the web resources or ...

Also see Idera's hilarious new video! ''Life of Simon, SQL Server DBA'' http://www.youtube.com/ideradotcom[Video]

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products.  Same way SQL ...

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client ...

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)) You might have seen the above error very ...

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that ...

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