I thought this looked a good candidate for CROSS APPLY:

insert into dbo.def 
(
    SeqNo,
    Date_Field,
    Payment
)
SELECT A.Seqno,
 ...

tom-580235 (6/17/2013)

---

Problem with the script in that if any of your variables are null you don't get the create string produced. i.e., in my experimentation @FileGroupName was null on one...

Nice article and some good links to useful videos

http://technet.microsoft.com/en-us/sqlserver/ff977043

It doesn't work in your algorithm. I've pulled it apart to see what it does if there...

It does seem a bit too close for comfort to this article:

http://www.dbta.com/Articles/Editorial/Think-About-It/How-Secondary-Files-Put-Your-Database-at-Risk-86580.aspx

But then again at the...

The code in the article doesn't check that the EventCloseDate older than 6 days when it does the delete. Is it that the EventCloseDate is always present and monotonically increasing...

I think the creation of a separate view is unnecessary when you can have the view inline:

DECLARE @Rowcount int

SET @Rowcount = -1 -- Initialise

WHILE @Rowcount <> 0

BEGIN

...

This made me laugh

Jeff Moden (2/8/2013)

---

Sorry for the late feedback. Yes, I agree. I just can't imagine why anyone would do such a thing in a script titled "Script [font="Arial Black"]ALL...

Thank you, it's an excellent script and combined with the spreadsheet is a great way to check your scheduled jobs as a gantt chart rotated by 90 degrees.

Just tried running it on SQL Server 2005 and got this error:

Msg 1001, Level 15, State 1, Line 77

Line 77: Length or precision specification 0 is invalid.

With this line highlighted:

,CAST(STUFF(STUFF(REPLACE(STR(run_duration,...

Jeff,

The following lines in the SP exclude the primary key and any indexes that are created via adding a unique constraint rather than adding a unique index.

AND SI.is_primary_key = 0

AND...

To me "big data" just means data that's too big to do normal data transforms and analyse in the way you would with smaller data. So you need different...

I put the query for detecting overlapping dates into a function and then added this as a table constraint and this does the same job:

Function

CREATE FUNCTION CheckLocationsOverlappingDates()

RETURNS int

AS

BEGIN

...

dcdanoland (8/20/2012)

---

Jonathan AC Roberts,

Bad news - I've been unable to create an indexed view for your query. First I had a few problems creating a view with schema binding -...