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 » i/o » indexes   (RSS)
How SQL Server manages when a database is created in terms of I/O and disk usage?
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that Read More...
Posted: Tuesday, January 29, 2008 4:46 AM by SQL Master | 3 Comments
Filed under: , , , , , , , , , , , ,
Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft
May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation Read More...
Posted: Friday, January 04, 2008 4:35 PM by SQL Master | 3 Comments
Filed under: , , , , , , , ,
DBCC EXTENTINFO - unused pages in these extents (undocumented)
When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when Read More...
Posted: Tuesday, September 04, 2007 5:45 AM by SQL Master | 4 Comments
Filed under: , , , , , , , , , ,