So after Max. Server Memory calculator, to make your life much more easier, here is the Max Degree of Parallelism or MAXDOP calculator. We are usi ng SQL DMV's to find out the number of NUMA nodes and Powershell query to find out the number of processor...

This calculator is now withdrawn since I'm not able to invest my time to improve it to make it "stay current". Apologize for the inconvenience! Hello SQL Community, I have written a simplified “Max. Server Memory” calculator...

SQL Server team has published the "SQL Server 2012 Upgrade Technical Guide" at http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf I encourage you to upgrade...

Today while working on a SQL Server performance case, I was asked this question "What happens to a database when transaction rollback fails?". I thought of sharing the answer to the community so that it can help DBA's to understand how SQL Server handles...

When you try to grant any privilege to SQL Server Service SID using Group Policy Editor in Windows 2008, you might get this error: An extended error has occurred. Failed to save Local Policy Database. This happens only when you try to add virtual...