SQLRNNR

Forum Replies Created

Viewing 15 posts - 10,996 through 11,010 (of 19,560 total)

RE: Visual Studio Tools

Thanks for the question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 10:14 am

#1288367
RE: Redundant Indexes

I think I will be posting those solutions to my blog instead.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 10:05 am

#1288360
RE: Tables in memory

Agreed - handy information indeed. If you google for dbcc memusage, I was able to find a few more scripts similar to what you created.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:28 am

#1288324
RE: Today's Random Word!

Brandie Tarvin (2/17/2011)
CirquedeSQLeil (2/17/2011)
Artificially unintelligent
Military intelligence
shhh. that was top secret (only wiki leaks knew was supposed to know that).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:21 am

#1288318
RE: why the avatar picture you use

mister.magoo (2/17/2011)
Ray K (2/17/2011)
Don't have one, only because I'm lazy. Haven't gotten around to it yet!
How about this one
LOL - better with the alternate meaning of that word.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:16 am

#1288313
RE: The Stairway Series

Awesome Initiative
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:15 am

#1288312
RE: Tables in memory

Nice script. I hadn't thought of that option when I first saw this post. I was venturing down the path of a hexeditor to examine memory and wanted...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:12 am

#1288307
RE: Today's Random Word!

Ray K (2/17/2011)
Brandie Tarvin (2/17/2011)
Tom.Thomson (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
Never been in this thread before but here it is:
Antidisestablishmentarianism
Yes, it is a real word 🙂
Pseudoantidisestablishmentarianism
quasi-pseudo-antidisestablishmentarianism
semi-quasi-pseudo-antidisestablishmentarianism
hemi-demi-semi-quasi-pseudo-antidisestablishmentarianism
genuine simulated hemi-demi-semi-quasi-pseudo-antidisestablishmentarianism
@=)
artificially genuine...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:09 am

#1288304
RE: After rebuild job, Log shipping goes out of sync

Unless you do one or both of those things I mentioned, your log file will continue to be 70+ GB for that first tran log that needs to be shipped.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:07 am

#1288303
RE: Redundant Indexes

TheSQLGuru (2/17/2011)
1) That's an interesting script for dupe index checking Jason. Haven't seen one like that before. I need to give it a try.
2) Duplicate indexes can indeed...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 17, 2011 at 9:05 am

#1288300
RE: Today's Random Word!

Tom.Thomson (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
Never been in this thread before but here it is:
Antidisestablishmentarianism
Yes, it is a real word 🙂
Pseudoantidisestablishmentarianism
quasi-pseudo-antidisestablishmentarianism
semi-quasi-pseudo-antidisestablishmentarianism
hemi-demi-semi-quasi-pseudo-antidisestablishmentarianism
Do you have a hemi in that thing?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 16, 2011 at 4:30 pm

#1287994
RE: Are the posted questions getting worse?

For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 16, 2011 at 2:50 pm

#1287955
RE: Are the posted questions getting worse?

GilaMonster (2/16/2011)
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?
Everybody's. We get to have multiple executions for this infraction.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 16, 2011 at 2:44 pm

#1287950
RE: Are the posted questions getting worse?

WayneS (2/13/2011)
Are any Threadizens going to SQL Saturday #69 (Philadelphia) on March 5? I just read the email where my presentation has been selected to be presented! :w00t::w00t::w00t:
I'd love to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 16, 2011 at 2:34 pm

#1287942
RE: Today's Random Word!

Peter Trast (2/16/2011)
CirquedeSQLeil (2/16/2011)
Peter Trast (2/16/2011)
Never been in this thread before but here it is:
Antidisestablishmentarianism
Yes, it is a real word 🙂
Pseudoantidisestablishmentarianism
quasi-pseudo-antidisestablishmentarianism
semi-quasi-pseudo-antidisestablishmentarianism
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 16, 2011 at 2:32 pm

#1287940

Viewing 15 posts - 10,996 through 11,010 (of 19,560 total)