Sarabpreet Singh Anand, Author at SQLChamp

Why the size of the backup file changes?

Hi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different

Hi Friends, A few days back, I got a backup failure alert regarding one of our most critical SQL Instance.

Hi Friends, There are a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware

Hi Friends, Yesterday I was working on a specific requirement of a client to create DDL trigger for a Database

Hi Friends, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And

Hi Friends, As you all know AWE has been deprecated and not available from SQL Server 2012 (Find details here),

Hi Friends, Last week I presented at the local UG group & it was my favorite topic, Hybrid Scenarios of

Like we already know, Windows-based applications can use Windows AWE (Address Windowing Extensions) APIs to allocate and to map physical

Hi Friends, Sometime back I was answering questions on TechNet Forum when I saw an interesting and genuine problem. The

Hi Friends, As you already know, the auto update statistics feature of SQL Server relies on number of rows changed