SQL Tips and Tricks Archives - Page 323 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Making Database to Read Only – Changing Database to Read/Write

April 16, 2011

SQL Backup, SQL Restore, SQL Scripts, SQL Server

I recently received the following comments on my earlier blog about Making database to read only.

“Today i was trying to attach the (MDF,NDF,LDF ) sql server 2008 database which i have received from my client. After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). How do i make to normal mode for the data updation. is there any query available to resolve this problem. Your help will be highly helpful.”

Let’s learn Making Database to Read Only and Changing Database to Read/Write.

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 – Query to Recent Query on Server with Execution Plan Function to Get SQL

April 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

This blog post is written in response to the T-SQL Tuesday hosted by Matt Velic. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…

SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities

April 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

One of the major problems in developing a data integration application is writing transformation code. Many tools try to meet this need by providing a large number of operators that minimize coding through configuration. Specialized operators are fine for basic transformations, but most ETL transformations require logic specific to the…

SQL SERVER – Add New Column With Default Value

April 9, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server is a very interesting system, but the people who work in SQL Server are even more remarkable. The amount of communication, the thought process, the brainstorming that they do are always phenomenal. Today I will share a quick conversation I have observed in one of the organizations that…

SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

April 8, 2011

Pinal Dave

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

MVP, SQLAuthority Author Visit, TechEd, TechEdIn

Read my complete experience series of TechEd 2011, Bangalore TechED 2011 – Bangalore – An Unforgettable Experience – Day 0 TechED 2011 – Bangalore – An Unforgettable Experience – Day 1 TechED 2011 – Bangalore – An Unforgettable Experience – Day 2 TechED 2011 – Bangalore – An Unforgettable Experience…