SQL Server Education (by the geeks, for the geeks)
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 …
SQL Server Memory Shortage for all 32 Bit SQL Server 2012 Instances Read MoreWhat 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 …
Contained Databases in SQL Server 2012 – Denali Read MoreSQL 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 …
SQL Server Password Audit for SQL Server Logins Read MoreT-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 …
SQL Server 2012 DENALI T-SQL Enhancements: FETCH & OFFSET Read MoreHi 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 …
SQL Server: Why the size of the backup file changes? Read More