Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » data type   (RSS)
SQL Server 2005 - How to compare content of tables without using third party tools?
You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare Read More...
Posted: Friday, July 04, 2008 1:36 AM by SQL Master | 2 Comments
Filed under: , , , ,
Failed to claim unused space with SP_SPACEUSED?
Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name Read More...
Posted: Friday, August 31, 2007 2:09 AM by SQL Master | 2 Comments
Filed under: , , , , , , , ,
Reducing Database Size by Using Vardecimal Storage Format
Useful information on data storage format using available data-types in SQL Server 2005 SP2: The Vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can Read More...
Posted: Wednesday, June 20, 2007 1:55 PM by SQL Master | 0 Comments
Filed under: , , , ,