July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (January 2009)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…
Read More

SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Index, SQL Scripts, SQL Stored Procedure
Yesterday I came across following error while enabling fill factor for my database server, when I was trying to write article SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor. I ran following T-SQL script and it gave me…
Read More

SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Cursor, SQL Index, SQL Scripts
I just wrote down following script very quickly for one of the project which I am working on. The requirement of the project was that every index existed in database should be rebuilt with fillfactor of  80. One common question I receive why fillfactor 80, answer is I just think…
Read More

SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Microsoft Certifications, MVP
Please note down this important code or share with your colleagues who are keen to take Microsoft Certification Exam. This unique code is only available through Microsoft MVP’s and only published here to help community and no other intention. In this challenging economic climate, upgrading your IT skills becomes crucial…
Read More

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

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…
Read More

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

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…
Read More

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

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…
Read More