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

SQLAuthority News – Memories at Anniversary of SQL Wait Stats Book

September 1, 2012

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats About a year ago, I experienced a very proud moment. I published my second book, SQL Server Wait Stats, also acting as its primary author. It has been a long journey since then. The book received a generally great response and it has been widely accepted in the Community…

SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’

August 31, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Just a day before I got a very interesting email. Here is the email (modified a bit to make it relevant to this blog post). “Pinal, We are facing a very strange issue. One of our query related to backup files and backup set has stopped working suddenly in SSMS. It…

SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video

August 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

One of the biggest ask I have always received from developers is that if there is any way to insert multiple rows into a single table in a single statement. Currently when developers have to insert any value into the table they have to write multiple insert statements. First of…

SQL SERVER – A Brief Note on SET TEXTSIZE

August 28, 2012

Pinal Dave

SQL Tips and Tricks

SQL Options, SQL Scripts, SQL Server

Here is a small conversation I received. I thought, though an old topic, indeed a thought provoking for the moment. Question: Is there any difference between LEFT function and SET TEXTSIZE?

SQL SERVER – Answer – Value of Identity Column after TRUNCATE command

August 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I had one conversation with reader where I almost got a headache. I suggest all of you to read it before continuing this blog post SQL SERVER – Reseting Identity Values for All Tables. I believed that he faced this situation because he did not understand the difference between SQL SERVER –…

SQL SERVER – Download PSSDIAG Data Collection Utility

August 26, 2012

Pinal Dave

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

SQL Download

During an early career of mine as a database consultant – when I was dealing with SQL Server 2000, I often needed to collect various data related to SQL Server. My favorite tool to collect the data is PSSDIAG tool. It is a general purpose diagnostic collection utility that Microsoft Product…

SQLAuthority News – Featuring in Call Me Maybe The Developer Way – Pluralsight Video

August 25, 2012

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Is SQL boring? Not at all. SQL is fun – one has to know how to maximize the fun while working with SQL Server. Earlier I was invited to participate in the video Pluralsight. I am sure all of you know that I have authored 3 SQL Server Learning courses…