Category Archives: SQL Server 2005

Example for dynamic pivot table (crosstab) in SQL Server 2005

— traffic distribution by devip and protocoldeclare @list varchar(max) — select distinct protocol from #1 order by 1 SELECT @list = COALESCE(@list + ‘,[‘, ‘[‘) + CAST(protocol AS varchar(4)) + ‘]’ FROM (select distinct top 100 protocol from #1 order … Continue reading

Posted in SQL Server 2005 | Leave a comment

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (Microsoft TechNet SQL Server)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (Microsoft TechNet SQL Server TechCenter) Microsoft SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server … Continue reading

Posted in SQL Server 2005 | Leave a comment

Queries to get filegroup of table/indexes

  Quote Queries to get filegroup of table/indexes Yesterday, when I was looking at disk space utilization for a server, I had a need to see what objects were placed on what filegroups, and these queries were the outcome.  The … Continue reading

Posted in SQL Server 2005 | Leave a comment

Paging in SQL Server 2005

 Paging in SQL Server 2005 Paging has always been bit of a problem in SQL Server-world. For example, some other databases support LIMIT in ORDER BY, making the often needed paging easier to implement. Now that the next SQL Server … Continue reading

Posted in SQL Server 2005 | Leave a comment

SQL Server – Memory Configuration, Performance Profiling, Setting Your Fill Factor | Technet

 SQL Q&A – Memory Configuration, Performance Profiling, Setting Your Fill Factor (Technet)

Posted in SQL Server 2005 | Leave a comment

Using SQL Bulk Load to import XML | A Programmers Journal

A Programmers Journal – Using SQL Bulk Load to import XML Importing very large XML files into SQL server can be taxing for standard methods. Thats where SQL Bulk load comes in very handy, Bulk load can load a 100 … Continue reading

Posted in SQL Server 2005 | Leave a comment

Partitioned Tables in SQL Server 2005

Partitioned Tables in SQL Server 2005 Partitioned Tables in SQL Server 2005 Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. The feature is only available for … Continue reading

Posted in SQL Server 2005 | Leave a comment