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

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

April 18, 2011

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 – 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…