SQL Archives - Page 362 of 519 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

April 5, 2010

SQL Backup and Restore, SQL Data Storage

Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source…

SQL SERVER – Difference Between GRANT and WITH GRANT

April 3, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

What is the difference between GRANT and WITH GRANT when giving permissions to the user? This is a very interesting question recently asked me to during my session at TechMela Nepal. Let us first see the syntax and analyze. GRANT: USE master; GRANT VIEW ANY DATABASE TO username; GO WITH GRANT: USE…

SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy

April 2, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I twitted recently about: ‘Installing #sql Server 2008 R2 – Master Data Services. Painless.’ After doing so, I got quite a few emails from other users as to why I thought it was painless. The reason was very simple- I was able to install it rather quickly on my laptop…

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

April 1, 2010

Pinal Dave

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

Software Development, SQL Humor

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 – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup

March 27, 2010

Pinal Dave

SQL

SQL Backup, SQL Error Messages, SQL Log, SQL Restore, SQL Scripts, SQL Server

I recently got following email from one of the readers. It is about Backup Log file.

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…