Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader

January 28, 2009

Just a day ago I received email from reader how to get single random number for range of rows of any table. The question was not very clear to me so I had asked him to send me question in simpler words. He sent me question back in simple words.…

SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008

January 27, 2009

Pinal Dave

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

SQL Download, SQL Service Pack

For almost one year I have been using SQL Server 2008 and I keep watch on its update. Cumulative Update Package 3 has been made available now. Latest SQL Server 2008 version is 10.0.1787.0. Download Cumulative update package 3 for SQL Server 2008 Abstract courtesy : Microsoft Reference : Pinal…

SQLAuthority News – Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview

January 27, 2009

Pinal Dave

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

SQL Download

Note: Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview by Microsoft In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 2.0 download is available to all SQL Server users at no additional charge, and provides access…

SQLAuthority News – Happy 60th Republic Day to India – Database Tip

January 26, 2009

Pinal Dave

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

Database

Kaleidoscopic images of India’s rich cultural diversity and the might of its military were on full display on the magnificent Rajpath Republic Day celebrations as the nation celebrated its 60th Republic Day amid an unprecedented security cover. An impressive and colourful parade, a traditional attraction of the national event, marched…

SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation

January 25, 2009

Pinal Dave

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

SQL Data Storage, SQL Scripts, SQL Server DBCC, SQL Server Security

Just a day ago I have received following email from Siddhi and I found it interesting so I am sharing with all of you. Hello Pinal, I have seen many blogs from you on SQL server and i have always found them useful and easy to understand. Thanks for all…

SQLAuthority News – Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007

January 24, 2009

Pinal Dave

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

Database, SQL Download

Note: Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 by Microsoft Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes…

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2

January 23, 2009

Pinal Dave

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

Best Practices, SQL Scripts, SQL Server DBCC, SQL System Table

Just another day I was playing with my query which I posted earlier SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL and I found that I got error devide by zero. I have fixed this error in following query as well I have updated query…