Viewing 15 posts - 1 through 15 (of 59 total)
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...
January 20, 2015 at 6:04 am
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...
January 20, 2015 at 4:51 am
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...
January 8, 2015 at 4:07 am
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...
January 8, 2015 at 3:01 am
ALZDBA (1/8/2015)
...That's the reason I don't use "set single user", but put it offline, right before the restore.
+1 - I always SET OFFLINE, never SINGLE_USER, as you can't be certain...
January 8, 2015 at 2:55 am
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...
January 5, 2015 at 7:54 am
Thanks Grant
Been kicking this one around for a while. Might just chalk it up to 'Architect Fantasy'....;-)
January 5, 2015 at 6:33 am
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...
December 19, 2014 at 7:59 am
Have you tried splitting the proc in two, and offline then restore ?
December 17, 2014 at 9:03 am
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...
December 17, 2014 at 8:41 am
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.
November 24, 2014 at 3:57 am
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...
June 30, 2014 at 4:29 am
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...
June 24, 2014 at 6:00 am
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...
June 24, 2014 at 5:50 am
Dalkeith (5/23/2014)
This has told me one I'm generally going along the right lines and express is not the thing to do it...
May 23, 2014 at 7:52 am
Viewing 15 posts - 1 through 15 (of 59 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy