Viewing 15 posts - 7,006 through 7,020 (of 19,560 total)
I would probably go with option 2. If one fails, exchange the drive - reboot.
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 23, 2012 at 12:59 pm
I see this practice more often than I would like. Code that is untested and released to prod. Or different code released to prod than what was released...
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 23, 2012 at 12:38 pm
LutzM (1/23/2012)
Brandie Tarvin (1/23/2012)
jcrawf02 (1/23/2012)
Blargh. User just requested a pie chart for their analysis....:sick:Does this help?
Or how about this?
Referring to your first link: He asked for...
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 23, 2012 at 12:31 pm
jcrawf02 (1/23/2012)
Blargh. User just requested a pie chart for their analysis....:sick:
Make sure you do that entirely in TSQL
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 23, 2012 at 11:25 am
facet
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 23, 2012 at 9:17 am
Good question Steve.
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 23, 2012 at 8:20 am
GilaMonster (1/22/2012)
Fraggle-805517 (1/22/2012)
I am guess this is probably due to the sever restart
You didn't mention you'd restarted the server...
Any evidence of what caused the growth would have been erased by...
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 22, 2012 at 1:10 pm
Here is an article outlining a method to help find what causes the growth.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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 22, 2012 at 11:30 am
Yay - SOPA has been shelved.
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 22, 2012 at 11:28 am
Try this article for some assistance
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
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 20, 2012 at 2:21 pm
WayneS (1/20/2012)
Speaking of L&L's... have you'll ever tried them with folks locally and remotely? (talking India here...)That's what I'm trying to figure out... leaning towards separating them.
Do them separate. ...
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 20, 2012 at 1:10 pm
Hugo Kornelis (1/20/2012)
Hugo Kornelis (1/20/2012)
Richard Warr (1/20/2012)
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 20, 2012 at 11:16 am
Revenant (1/20/2012)
SQLRNNR (1/20/2012)
graphiteBucky ball
Best toy ever - until your child swallows them.
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 20, 2012 at 11:05 am
ulteriorm (1/20/2012)
Sorry about the confusion. I wish I had the rights to take down a POST ( of course posted by Me)!
NP - I am looking at your query but...
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 20, 2012 at 9:20 am
@padhis - Thank you.
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 20, 2012 at 9:16 am
Viewing 15 posts - 7,006 through 7,020 (of 19,560 total)