March « 2010 « SQL Server Journey with SQL Authority

Archive for March, 2010

SQL SERVER – Checklist for Analyzing Slow-Running Queries

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 12, 2010 | 11 Comments »

I am recently working on upgrading my class Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning with additional details and more interesting examples. While working on slide deck I realized that I need to have one solid slide which talks about checklist for analyzing slow running queries. A quick search on my saved [...]

Read Full Post »

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 11, 2010 | 6 Comments »

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can [...]

Read Full Post »

SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, SQLServer, T SQL, Technology, tagged SQL Internals on March 10, 2010 | 8 Comments »

Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task. The reason for using the word “almost” is because this book [...]

Read Full Post »

SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged T-SQL Tuesday on March 9, 2010 | 24 Comments »

This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO. Let us kick off this post with disclaimers about Index. Index is a very complex subject [...]

Read Full Post »

SQLAuthority News – SQL SERVER 2008 R2 Pricing

Posted in Readers Question, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, SQLServer, T SQL, Technology, tagged Pricing, SQL Server 2008 R2 on March 8, 2010 | 6 Comments »

I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing. Official site: What’s New in SQL Server 2008 R2 Editions Editions Per Processor PricingRetail Per Server Plus CAL PricingRetail Parallel Data Warehouse $57,498 Not offered via Server CAL Datacenter $57,498 Not offered via Server CAL [...]

Read Full Post »

« Newer Posts - Older Posts »