Minimum Memory Grant Query Hint

This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...

Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation

Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...

Power BI Takeover–Webinar Recording and Q&A

Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm.  Instead of our traditional 1...

Data Compression in SQL Server – Pros and Cons

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...

Getting your Cloud on

One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...

Wait Types and Latch Classes Library

Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...

A Day In The Life of a SQLBits Volunteer

So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...

SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0

I have recently experienced an issue with a third-party  backup application (Commvault) that was trying to backup the databases from...

SQL Server Command Timeout – Application Timeout – Attention

When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...

Common uses of stored Procedure sp_MSforeachtable

We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.

sp_MSforeachtable can be used to loop through all...