April « 2011 « SQL Server Journey with SQL Authority

Archive for April, 2011

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

Posted in Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 15, 2011 | 7 Comments »

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 very next to him and [...]

Read Full Post »

SQL SERVER – Transaction Log Impract Detection Using DMV – dm_tran_database_transactions

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 14, 2011 | 5 Comments »

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 TransactionBegin, CASE database_transaction_type WHEN 1 [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on April 13, 2011 | 11 Comments »

Recently I formatted my computer and installed fresh SQL Server in it. I installed 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 original database [...]

Read Full Post »

SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged APPLY on April 12, 2011 | 4 Comments »

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 interesting choice by Matt. I [...]

Read Full Post »

SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on April 11, 2011 | 4 Comments »

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 particular application. For that, tools [...]

Read Full Post »

« Newer Posts - Older Posts »