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

SQLAuthority News – Last 5 Days to WIN Windows Phone 7 – 140 Words to Win

April 20, 2011

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

You can win Windows 7 Phone by writing only 140 Characters. You need to leave a comment over here: SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL over here. There are so far around 150 comments and I believe that chances of…

SQLAuthority News – Sudden Death of SSD on my Laptop – A Warning for SSD Users

April 19, 2011

Pinal Dave

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

The solid state drive on my personal laptop just died. Here’s the story. I have a DELL XPS laptop which is now 2.5 years old. The laptop had demonstrated no issues. About 6 months ago, I decided to upgrade the hard drive to solid state drive. There was a lot…

SQL SERVER – Speaking on T-SQL Worst Practices at Great Indian Developer Summit 2011 – Bangalore

April 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Presenting in front of techies is always fun. I will be speaking at Great Indian Developer Summit 2011 – Bangalore on April 19, 2011. Here is the details of my session: Session Title:“What did I do?” – T-SQL Worst Practices “Oh My God! What did I do?” Chances are you…

SQL SERVER – Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction

April 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Just received very interesting question in email: “How do I apply NOLOCK hint to my whole query. I know that I can use NOLOCK at every table level but I have many tables in my query and I want to apply the same to all the tables. I want to…

SQL SERVER – Finding Location of Log File when Primary Datafile is Crashed

April 15, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

My friend and SQL Expert Vinod Kumar asked a very interesting question in his latest blog post. Quick Quiz:Do you need the primary data file available to backup your transaction log after a crash? This question can have multiple answers. While he asked the question on blog, I was sitting…

SQL SERVER – Transaction Log Impact Detection Using DMV – dm_tran_database_transactions

April 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Just a few days ago before I received the email from blog reader asking if there is any DMV which can provide details about the effect of a transaction on the transaction log file. Absolutely! Here is a quick script which can provide the necessary details: SELECT transaction_id, DB_NAME(database_id) DatabaseName, database_transaction_begin_time…

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

April 13, 2011

Pinal Dave

SQL

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Server

Recently I formatted my computer and installed fresh SQL Server in it. I installed the AdventureWorks database in my database. Once done, I wanted to run few test scripts on my database. Just like every DBA, I decided to take backup of my database – this way I can restore it back to attain an original database state. As soon as I ran the backup command I ended up with the following error. This error is due to a permissions issue on the local disk and user account which is running SQL Server. In this blog post we will talk about the operating system error.