SQL Server Memory Shortage for all 32 Bit SQL Server 2012 Instances
Hi Friends, As you all know AWE has been deprecated and not available from SQL Server 2012 (Find details here), as a result when you upgrade from SQL Server 2008 R2 …
Read MoreTag: SQL Denali
Contained Databases in SQL Server 2012 – Denali
What is a contained databases in SQL Server 2012 – Denali? A contained database is a database which includes all the required settings, metadata and operates in isolation from the SQL …
Read MoreSQL Server Password Audit for SQL Server Logins
SQL Server Password audit is a must for all SQL Servers. Weak or Blank passwords are invitation to trouble and such type of passwords may result in security breach. Everybody knows …
Read MoreSQL Server 2012 DENALI T-SQL Enhancements: FETCH & OFFSET
T-SQL New feature for OFFSET and FETCH Please note the table is completely fictitious and all data is just for presentation purpose Consider a scenario below: English Product Name Reorder Point …
Read MoreSQL Server: 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 size than the final file size when the backup completes. To …
Read More