Monthly Archives: August 2010

Microsoft Second Shot Offer is back again with discount

Microsoft has recently introduced a discount on certification exams with second shot offer,  which means if you fail a exam for first time, you can retake the test a second time for free. Now Microsoft has come up with a concept of bulk exam strategy where you nee to buy a specific Certification pack, which [...]

DBCC FLUSHPROCINDB

DBCC FLUSHPROCINDB command is used to clears all plans for a single database. For example, the following code, will clear all the plans for pubs database and force to recompile all stored procedures on first execution.     ----Determine the id of the pubs database DECLARE @intDBID INTEGER SET @intDBID = (SELECT dbid                 FROM [...]

How to use Sparse Columns ? (Video Tutorial)

Question : What is a SPARSE Column, How to use sparse columns in SQL Server 2008 ? How to create table which has sparse column, How to use SQL Server Sparse Columns ? What is a Column Set, How to create table which has sparse column set ? How to Insert and update data in [...]

New SQL Server DMV and DMF, which are added in SQL Server 2008

There are lot of new Dynamic Management Views and Dynamic Management Functions are added in SQL Server 2008. Approximately 47 new are got added. Here is the complete list of DMV’s and DMF’s which are added in SQL Server 2008.

How much space can be saved using SQL Server 2008 Data Compression feature ?

If you have the questions like How much space can be saved using SQL Server 2008 Data Compression feature ? How much space can be saved using Page Level compression ? How much space can be saved using Row Level compression ? How much space can be saved using Row Level compression as well Page [...]

How table design can impact your SQL Server performance?

Question : Does Row Size matters in SQL Server performance? Can a single byte can impact your sql server performance ? How to create optimized table at design time? Should we consider the row size during table design ? Answer Yes, a single byte (1 byte) can badly impact your SQL Server Performance, it might [...]

UML to DB – An online service to generate SQL DDL scripts from UML models

UML to DB – An online service to generate SQL DDL scripts from UML models

UMLtoDB ( modeling-languages.com ) is a code-generation service to easily create your databases from simple UML class diagrams. All major database management systems supported…