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

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

April 1, 2010

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

First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once…

SQL SERVER – Generate Report for Index Physical Statistics – SSMS

March 26, 2010

Pinal Dave

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

SQL Index, SQL Server Management Studio, SQL Utility

Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are…

SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase

March 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Replication, SQL Scripts

During configuring replication on one of the server, I received following error. This is very common error and the solution of the same is even simpler. MSDTC on server is unavailable. Changed database context to publisherdatabase. (Microsoft SQL Server, Error: 8501) Solution: Enable “Distributed Transaction Coordinator” in SQL Server. Method…

SQLAuthority News – We’re sorry… … but your computer or network may be sending automated queries. To protect our users, we can’t process your request right now.

March 23, 2010

Pinal Dave

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

Google

I use multiple browser many times when I am working with multiple projects simultaneously. Often I use Google Reader to read few feeds. Recently, I faced the following error and this error will not go. I even restarted my computer and rebooted my network. I am confident that my computer…

SQL SERVER – Enumerations in Relational Database – Best Practice

March 22, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, Software Development, SQL Documentation

Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…

SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward

March 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages, SQL Scripts

I received the following email from one of my readers. Dear Pinal, I am new to SQL Server and our regular DBA is on vacation. Our production database had some problem and I have just restored full database backup to production server. When I try to apply log back I…

SQLAuthority News – Microsoft SQL Server Protocol Documentation Download

March 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Download Microsoft SQL Server Protocol Documentation Authored by Microsoft The Microsoft SQL Server protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in Microsoft SQL Server to interoperate or communicate with Microsoft products. The documentation includes…