June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, MVP, PowerPivot, SQLAuthority Author Visit
It has been a great pleasure to visit Infosys Mysore for an MSDN session. I had previously visited Infosys Bangalore for Technical session. Please read the details of earlier visit SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore. This event was held on Dec 10, 2009. I have…
Read More

SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts
While working on query optimization project, I encountered following error. Msg 1807, Level 16, State 3, Line 1 Could not obtain exclusive lock on database ‘model’. Retry the operation later. Msg 1802, Level 16, State 4, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check…
Read More

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Transactions
Few days ago I wrote an article on the myth of table variable stored in the memory—it was very well received by the community. Read complete article here: SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth. Today, I am going to write an article…
Read More

SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MySQL, SQL Download, SQL Server Express
Here is the quick link from where SQL Server 2008 Express Edition can be downloaded. Download SQL Server 2008 Express Edition You can download it with many additional details as described in following image. Click on above link to go to page and select desired version. Additionally, please install SQL…
Read More

SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Scripts, SQL White Papers
SQL Server 2008 Full-Text Search: Internals and Enhancements SQL Server Technical Article Writer: Fernando Azpeitia Lopez, Microsoft Corp. Published: July 2008 Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics,…
Read More