I guess the point is that there's a misconception about using BIGINT as an identity column and the IDENTITY specification itself.

Many use INT or BIGINT as identity cols, but in...

If it's just Mondays you want (and *only* Mondays, no matter what day you were running the query on), you could use DATEPART(weekday,<yourEventDateCol>) = 1 in a WHERE clause...

Should be fine. You can attach/detach, or backup/restore. Don't forget to rebuild stats and set the db compat level to the latest (or whichever level you need to preserve old...

I hope all went well ? The 'day of' is probably not the best time to e asking if there might be any issues 🙂

Generally, in-place upgrades are to be...

+1 - I always SET OFFLINE, never SINGLE_USER, as you can't be certain...

I've seen some DBs that don't compress as much as I might have hoped due to GUIDs and encrypted columns, and even some that store data as text that's been...

Thanks Grant 🙂

Been kicking this one around for a while. Might just chalk it up to 'Architect Fantasy'....;-)

Could you add a new column to the table with the new precision, and copy the existing data into it using UPDATE table SET newCol = oldCol.

You could chunk up...

Have you tried splitting the proc in two, and offline then restore ?

I've always had problems with SINGLE_USER and geting the right session 🙂 If you SET OFFLINE WITH ROLLBACK IMMEDIATE, you should still be able to do the restore (but the...

How is your 'recipient' e-mail address supplied ? DB Mail requires a full address like 'My.Name@Company.com', not 'My Name'. It doesn't do address book lookups, just simple SMTP.

Yes, if you store your SSIS packages in SSISDB, they will be clustered if the instance that DB sits on is clustered. 🙂

The original question was about clustering the SSIS...

Can you track down the service that started the spids ?

If you stop the app or service that made the connection in the first place, that should kill the...

You can get round this if you use SQLAgent to run your SSIS packages.

I've clustered a normal instance of SQL Server + SQL Agent, placed all dtsx and config files...

Dalkeith (5/23/2014)

---

Brilliant guys and thanks for the suggestion of Streaminsight.

This has told me one I'm generally going along the right lines and express is not the thing to do it...