Subscribe to this blog
Everyday SQL
Patrick Keisler is a MCTS and MCP. For over 12 years, he has been been a database administrator for a major investment bank, Wells Fargo Securities. During that time, he has gained considerable knowledge in Microsoft SQL Server by supporting hundreds of applications ranging from high-volume trading applications to massive data warehouses.
Archives: February 2013
The Performance Impact to Prefix Stored Procedures with sp_
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should not use SELECT * in queries. In the post, Axel used the SQLQueryStress tool by Adam Machanic (B|T) to stress-test a simple…
0 comments, 235 reads
Posted in Everyday SQL on 19 February 2013
T-SQL Tuesday - Use Powershell to Restore a Database on a Different Server
1 comments, 565 reads
Posted in Everyday SQL on 12 February 2013
What is DBCC SHOW_STATISTICS Telling Me About My Data?
Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. Basically it shows you the statistics, or a summary of the data, that SQL Server will use to help generate an execution plan.
In the example below, we'll be looking at the statistics for…
1 comments, 1,877 reads
Posted in Everyday SQL on 5 February 2013