SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

Today in few hours I am going to present on my very favorite subject of performance tuning. You can read more about this sessions over here. This presentation is based on the famous book ‘The Art of War’ written in sixth century BC by Sun Tzu. Index is usually a…
Read More

SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

Performance Tuning has been my favorite subject always. I love this subject the most. I personally have enjoyed every aspect of performance tuning. Quite often I have seen that when it is about performance, people end up talking about Indexes. Index for sure can help performance, but it is like…
Read More

SQLAuthority News – Learn SQL Azure at Microsoft Virtual Academy

The Microsoft Virtual Academy offers no-cost, easy-access training for IT professionals who want to get ahead in cloud computing. Developed by leading experts in this field, these modules ensure that you acquire essential skills and gain credibility as the cloud computing specialist in your organization. MVA guides you through real-life deployment scenarios and the latest cloud computing technologies and tools. By selecting the training modules that match your needs, you can use valuable new skills that help take your career to the next level.

Read More

SQL SERVER – Denali – Download CTP3 Demo VHD Including Fully Configured Services and Integration with SharePoint 2010 and Office 2010

During my office hours observed, a very common question is”What is Denali?” once I answer that Denali is the next version of the SQL Server, the follow up question is where can I download it. I have explained the installation and download part over here: SQL SERVER – Denali CTP3…
Read More

Puzzle – Usage of New Index Hints – ForceSeek and ForceScan

Tomorrow is the weekend. I just thought, let us explore something new but a quick puzzle to explore about index hints.

SQL Server Denali has new Query Hint – FORCESCAN. In earlier version of SQL Server we already have Query Hint FORCESEEK but now the counter part also exists. The quick understanding is there will be cases when FORCESEEK or FORCESCAN will be helpful and improve the performance of the query.

Read More