Viewing 15 posts - 2,476 through 2,490 (of 2,763 total)
Everyone: Thank you for the ideas / suggestions
dan-572483 - Right now I'm not worrying about shrinking the files, that will come later. We're OK on disk space on...
April 3, 2013 at 11:06 am
Lynn Pettis (4/3/2013)
GilaMonster (4/3/2013)
jasona.work (4/3/2013)
1. After-hours, switch all DBs from Full Recovery...
April 3, 2013 at 10:32 am
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?
Depending on the time of day, either straight or filtered through ground-up and roasted Coffea...
April 3, 2013 at 7:51 am
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...
I've got two logins, one for "normal" use which has no...
April 2, 2013 at 5:58 am
GilaMonster (4/1/2013)
jack-311987 (4/1/2013)
what if you enable trace flag 708, and use the (noaprilfool) hintThe universe implodes. Please don't try it.
Oh shoot, I hope I can go stop my run of...
April 1, 2013 at 12:12 pm
SQLRNNR (3/29/2013)
jasona.work (3/29/2013)
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
I'm debating between waiting until tomorrow, or going to see...
March 29, 2013 at 8:36 am
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
I'm debating between waiting until tomorrow, or going to see it tonight...
March 29, 2013 at 5:36 am
Steve Jones - SSC Editor (3/28/2013)
I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something...
March 29, 2013 at 5:34 am
Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?
I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow with...
March 28, 2013 at 10:23 am
BrainDonor (3/28/2013)
Lynn Pettis (3/27/2013)
What to make of this?May not be what I was thinking. Good.
"I'm a DBA, it turns out"
How do you suddenly discover that you're a DBA?
Maybe just...
March 28, 2013 at 5:17 am
Thanks, I figured that was going to be the best option, now to get the Dev to eat the pain of taking care of this...
With help...
🙂
Jason
March 27, 2013 at 8:38 am
Cool, thanks to both of you!
Jason
March 27, 2013 at 8:37 am
Never mind, I'm an id10t...
Forgot I don't need to wrap T-SQL in quotes in a T-SQL job step...
:Whistling:
March 19, 2013 at 7:43 am
842 bottles of beer on the wall!
842 bottles of beer!
😀
March 15, 2013 at 12:05 pm
And this particular query in your article:
select
X.eventid,
E.Name as EventName,
X.columnid,
V.name as ColumnName
from ::fn_trace_geteventinfo(1) AS X
INNER JOIN sys.trace_events E ON X.eventid = E.trace_event_id
INNER JOIN sys.trace_columns V ON X.columnid = V.trace_column_id
gave me enough...
March 13, 2013 at 7:53 am
Viewing 15 posts - 2,476 through 2,490 (of 2,763 total)