SQL Server Archives - Page 251 of 393 - SQL Authority with Pinal Dave

SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008

January 26, 2010

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Download, SQL White Papers

Troubleshooting Performance Problems in SQL Server 2008 SQL Server Technical Article Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya Published: March 2009 It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL…

SQL SERVER – Find Statistics Update Date – Update Statistics

January 25, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Statistics

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…

SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification

January 23, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Download, SQL White Papers

Remote BLOB Store Provider Library Implementation Specification logo-sql08.gif SQL Server Technical Article Writers: Kevin Farlee, Pradeep Madhavarapu Technical Reviewer: Pradeep Madhavarapu, Michael Warmington Published: August 2008 Remote BLOB Store (RBS) is designed to move the storage of large binary data (BLOBs) from database servers to commodity storage solutions. With RBS,…

SQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement

January 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP

Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills…

SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010

January 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQLAuthority Author Visit

Microsoft has organized an Open Day for all MVP the South Asia MVP. The MVP Open Day is a three day invitation-only event that is hosted at MSIDC. The event will feature a roster of keynotes and deep dive technical sessions delivered by experts from the product group. Microsoft India Development…

SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results

January 19, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Yesterday night, I received a phone call from one of my friends with whom I used to work in USA. I was very pleased to receive this call from my old friend after 2 years, but the situation was not good on his side. He said that whatever query he…

SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action

January 18, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

I just received an email from one of the readers asking for help with error he encountered while attempting to run DMV. Msg 297, Level 16, State 1, Line 1 The user does not have permission to perform this action. Fix/Solution/Workaround: The above error is usually generated when the user…