Viewing 15 posts - 2,356 through 2,370 (of 2,763 total)
The general suggestion for autogrowth seems to be, don't. Ideally, either you set your DBs size large enough to encompass all reasonable possible data growth, or you monitor your...
July 19, 2013 at 8:53 am
OK, thanks!
I've been watching the Extended Events, but knowing they may not catch everything, I was hoping for a second method (without the trace flag)
Knowing XEs don't stay forever (seeing...
July 19, 2013 at 7:45 am
opc.three (7/12/2013)
July 17, 2013 at 6:04 am
After reading the "I hate software" posts just now, I have an urge to start a new topic...
Post the most twisted, warped, bizzarre, yet functional SQL code you can...
Whether it's...
July 17, 2013 at 5:21 am
Sean Lange (7/12/2013)
wolfkillj (7/12/2013)
Greg Edwards-268690 (7/12/2013)
Sean Lange (7/12/2013)
Steve Jones - SSC Editor (7/11/2013)
July 12, 2013 at 10:46 am
Well, having found these two posts, and seeing as several of the events being traced are login events which are apparently not implemented in XEs, I guess I won't be...
July 12, 2013 at 7:20 am
Brandie Tarvin (7/12/2013)
Well if Canada would quit trying to invade the U.S., maybe it would be easier!Because we all know they're jealous of our hockey teams. @=)
Detroit Red Wings!
Toronto Maple...
July 12, 2013 at 5:45 am
Working with CommVault backups here, names like that seem to be "virtual devices" created just for the backup to go to. It's not a "file" or "folder" as such,...
July 11, 2013 at 10:29 am
OK, quick tested this on a QA copy of the DB in question, and if the role membership is NULL, you can connect to SQL (expected) but you can't query...
July 9, 2013 at 12:42 pm
WHAT HAPPENED TO THE FORUMS?
I go away for a couple hours and everything gets moved around! I *LIKED* the furniture where it was, my chair was in just the...
July 9, 2013 at 12:02 pm
A bigger issue to making a SQL Server a DC is the permissions that get set. I once (accidently) started to promote a SQL Server to be a DC...
July 9, 2013 at 9:35 am
That's what I thought. I figured setting it to offline for the restore would prevent connections, having seen several postings here from people trying to do maintenance in single-user...
July 8, 2013 at 8:56 am
Koen Verbeeck (7/6/2013)
Last holiday we went with the kids to a cabin park. Close by was an amazing dolfinarium. It was closed the week we were there for maintenance...
You wouldn't...
July 8, 2013 at 8:08 am
If this day were going any slower, it'd still be 7:30am...
I could probably take databases offline then back online them in 5 minutes and nobody would notice...
July 5, 2013 at 11:18 am
opc.three (7/5/2013)
jasona.work (7/5/2013)
might work.
It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code,...
July 5, 2013 at 9:45 am
Viewing 15 posts - 2,356 through 2,370 (of 2,763 total)