Executing a TSQL batch multiple times using GO

Learn how to execute the same batch of SQL Server commands X number of times using the GO command.

In Azure SQL DB, what does “The connection is broken and recovery is not possible” mean?

All it really means is, “Click Execute again, and you will be fine.”

EXEC and EXECUTE

EXECUTE

Demonstration on how to pivot data using temp tables

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for 🙂

RE: Service Pack 4

I think the problem occurs with only with AWE enabled, because /3GB switch is for Widows User mode address space enlargement and AWE is specific to SQL Server. But there are other problems associated with SP4 - I still recommend that you should wait for atleast 6 months after the release of a service pack.

RE: Question of the Day for 22 Oct 2004

I'm all for trick questions, it's just slightly annoying that the question specifically asked you NOT to try it first.  The only reason I can think of as to why someone would say that is to get most of us to get it wrong.  I can't imagine very many of us would stumble across this one too […]

RE: Return date only from getdate()

FYI - when I need to counts by date on a DateTime field where the time value is populated, I just zero out the time value withSELECT CAST(Convert(VarChar(8), GetDate(), 112) AS DateTime) ... 

RE: SQLServer 7.0 Query against smalldatetime

Or, don't bother with any of the conversion stuff and just: CREATE PROC dbo.GetProjects @StartDate SMALLDATETIME , @EndDate SMALLDATETIME AS BEGIN SELECT Fields -- Don't use * !!! FROM tblProjects WHERE insertedDate BETWEEN DATEDIFF(day, 0, @StartDate) AND DATEDIFF(day, 0, @EndDate) END The DATEDIFF strips the time portion of the smalldatetime/datetime field. Since DATETIME fields are […]

RE: Importing data from txt file and updating Table

A couple of extra points. 1. Do the updates before the inserts otherwise you end up updating the rows you have just inserted. 2. If you have 500K rows to process and a table of 1.7M, then you will probably have locking issues. One way round this would be to add an identity column to […]