June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download, SQL White Papers
SQL Server Analysis Service have many features which are commonly requested and many already exists in the system. Security Data Entry is very important feature and SSAS supports writeback feature.  Analysis Services is a tool for aggregating information and providing business users with the ability to analyze and support decision…
Read More

SQLAuthority News – Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 – Microsoft Whitepaper

Pinal Dave
SQL
SQL Documentation, SQL Server, SQL White Papers

I recently presented session on Statistics and Best Practices in Virtual Tech Days on Nov 22, 2010. The sessions was very popular and I got many questions right after the sessions. The number question I had received was where everybody can get the further information. I am very much happy that my sessions created some curiosity for one of the most important feature of the SQL Server. Statistics are the heart of the SQL Server. Let us read about Statistics Used by the Query Optimizer in Microsoft SQL Server 2008.

Read More

SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
My recently article SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database has received many good comments regarding MAXDOP 1 and MAXDOP 0. I really enjoyed reading the comments as the comments are received from industry leaders and gurus. I was further researching on the subject and I end…
Read More

SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
PowerPivot, SQL Download, SQL White Papers
I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bring to us on table in real life experience. During this implementation the project design document…
Read More

SQLAuthority News – SQL Server Quickstart Downloads from Microsoft

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
Here are few recent published by Microsoft. Application Platform Optimization SQL Server Migration QuickStart The SQL Server Migration QuickStart includes a comprehensive set of technical content including presentations, whitepapers and demos that are designed to help you get details about how to approach your customers who want to improve the…
Read More