Viewing 15 posts - 2,371 through 2,385 (of 2,777 total)
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
steve.spenceST (7/5/2013)
We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain...
July 5, 2013 at 9:31 am
Viewing 15 posts - 2,371 through 2,385 (of 2,777 total)