January 18, 2012 at 9:16 am
L' Eomot Inversé (1/18/2012)
Jack Corbett (1/18/2012)
I assume I'm not the only one who sees no content (well really only the word "content") in the body of today's featured article Stairway to Server-side Tracing - Level 7: How to Automate SQL Traces using SQL Jobs and SSIS[/url].Actually there appear to be two words: "Con" and "tent". :hehe:
I found it. Inadvertent scheduling. We had updated content for Level 6, but 7 is still in edit.
January 18, 2012 at 11:58 am
GilaMonster (1/18/2012)
Gianluca Sartori (1/18/2012)
From time to time, the questions are really getting worse.This one made my LMAO:
OP: I have performance issues and I'm totally clueless.
Gail: Hire a consultant.
OP: I'm the consultant.
Gail: Hire a performance tuning consultant.
OP: I should be the one that knows that stuff.
Incredible!
I was going to compose another reply, but thought better of it.
Gail your restraint by not composing another reply is truly amazing, many congratulations.
January 18, 2012 at 12:02 pm
In case anyone is interested, the text of SOPA (the House bill) can be found here: http://www.gpo.gov/fdsys/pkg/BILLS-112hr3261ih/pdf/BILLS-112hr3261ih.pdf
The text of PIPA (the Senate bill) can be found here:
January 18, 2012 at 12:47 pm
Brandie Tarvin (1/18/2012)
In case anyone is interested, the text of SOPA (the House bill) can be found here: http://www.gpo.gov/fdsys/pkg/BILLS-112hr3261ih/pdf/BILLS-112hr3261ih.pdfThe text of PIPA (the Senate bill) can be found here:
And the brains and ethics of those who wrote them can be found here:
select NULL
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 18, 2012 at 1:33 pm
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?
I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
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
January 18, 2012 at 2:01 pm
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
-- Gianluca Sartori
January 18, 2012 at 2:23 pm
Gianluca Sartori (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
I found that right after posting. It is a good start and will be helpful I think. I am hoping to do a full tsql solution for it.
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
January 18, 2012 at 2:25 pm
SQLRNNR (1/18/2012)
Gianluca Sartori (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
I found that right after posting. It is a good start and will be helpful I think. I am hoping to do a full tsql solution for it.
Sounds interesting. Will you blog it?
-- Gianluca Sartori
January 18, 2012 at 2:28 pm
Gianluca Sartori (1/18/2012)
SQLRNNR (1/18/2012)
Gianluca Sartori (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
I found that right after posting. It is a good start and will be helpful I think. I am hoping to do a full tsql solution for it.
Sounds interesting. Will you blog it?
Yes, Once I get it working
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
January 18, 2012 at 5:26 pm
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
What would be foul about it? :w00t: Getting them all exported at once would be rather nice, not at all foul!
More seriously, is it really "foul" in USA instead of "fell" in Britain?
Tom
January 18, 2012 at 5:37 pm
L' Eomot Inversé (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
What would be foul about it? :w00t: Getting them all exported at once would be rather nice, not at all foul!
More seriously, is it really "foul" in USA instead of "fell" in Britain?
I have heard it both ways here.
Fell is probably better.
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
January 18, 2012 at 5:47 pm
SQLRNNR (1/18/2012)
L' Eomot Inversé (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
What would be foul about it? :w00t: Getting them all exported at once would be rather nice, not at all foul!
More seriously, is it really "foul" in USA instead of "fell" in Britain?
I have heard it both ways here.
Fell is probably better.
I've only ever heard fell. I've never heard foul swoop. That just sounds weird.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2012 at 5:52 pm
Fell's the appropriate term. Foul became slang because of the dis-use of 'fell' in that terminology and poor education. Everyone who heard the term correctly assumed they hadn't, because they didn't understand the usage. I heard 'foul' more often in the south, but even then not commonly. It usually only takes one correction then they nod and say 'oh, that makes more sense'.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 19, 2012 at 5:10 am
L' Eomot Inversé (1/18/2012)
SQLRNNR (1/18/2012)
anybody know a good resource for exporting into sqlplan format the xml from sys.dm_exec_query_plan(qs.plan_handle) for a smallish subset of ~100 plans?I have been able to copy the xml and get decent results in SQLSentry that way but want to export in one foul swoop.
What would be foul about it? :w00t: Getting them all exported at once would be rather nice, not at all foul!
More seriously, is it really "foul" in USA instead of "fell" in Britain?
Usually I hear people saying it as a spoonerism. Swell foop is quite popular in the midwest. But the original has always been "fell swoop". I haven't heard "foul swoop" until Jason's post.
January 19, 2012 at 5:19 am
If I've already announced this here, I apologize for the repost. I'm just so excited I can't remember where all I've shared the news already.
I am beyond thrilled today to announce the culmination of two years worth of brainstorming and work has finally come to fruition. I have teamed up with several authors to create a brand new world, and a brand new Young Adult fantasy series we call Latchkeys.
The first story in the Latchkeys series is "Unlatched" by Steve Saville and will be out in both Kindle and Nook forms this coming Sunday. More information can be found at the Crazy 8 Press website here: The origins of Latchkeys[/url] and The official announcement with a free excerpt[/url]. Feel free to open the sample available and see what you think.
Founding members of the Latchkeys world are: Steven Savile, Lorraine Anderson, Don Bassingthwaite, Matt Forbeck, Robert Greenberger, Kris Katzen, Jane Killick, Paul Kupperberg, James Reasoner, Ben Rome, Aaron Rosenberg, Brandie Tarvin, Deborah Viguié. You may recognize some of these names.
And if that isn't enough to wet your appetite, how about this:
There are places that exist beneath, behind and between the world we live in.
There are people who slip between the cracks.
And there are those who stand guard, ensuring that nothing worse slips through. From either direction.
Attached is a cover image of Unlatched. My story is due out September 2012. I look forward to seeing you all on the other side of the door. Enjoy the excerpt!
Viewing 15 posts - 33,811 through 33,825 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply