Browse by Tags

SQL Server configuration disk layout - best practices from field

Published 3 April 8 3:17 AM | SSQA.net

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...

Filed under: sql server, performance, data, log, disk, best practices, tempdb, monitoring, configuration, layout

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Published 4 September 7 7:45 AM | SSQA.net

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...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

Table schema comparison and sometimes data too!

Published 9 July 7 5:11 AM | SSQA.net

Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish...

Filed under: sql server, performance, data, red-gate, compare, procedure, compact, pack