Viewing 15 posts - 3,451 through 3,465 (of 19,560 total)
I read a blog post on this topic recently.
I like the approach depicted in the article - try to resolve and then rollback after having run there enough troubleshooting 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
March 4, 2014 at 7:32 am
microbot
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
March 4, 2014 at 7:09 am
Nothing wrong with the CTE that you were using from what I can tell. That said, I didn't do an intrusive code review either.
All that was needed was the...
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
March 4, 2014 at 7:04 am
I know Bob (Dixie) has done a masterful job with this script.
Here is a slightly different route I have taken in the past that was also quite efficient and performed...
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
March 4, 2014 at 6:55 am
Koen Verbeeck (3/4/2014)
Nice question, but the explanation doesn't mention why the order of casting vs order by changes. (because of adding the T alias in the second statement)
That explanation is...
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
March 4, 2014 at 6:47 am
dwain.c (3/3/2014)
SQLRNNR (3/3/2014)
Jason is a man of few words and a code-talker to boot! 😛
LOL
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
March 3, 2014 at 5:59 pm
SELECT person.personID
, cs562.personID
, cs562.attributeID
, cs562.value
, cs562.[date]
, cs563.personID
, cs563.attributeID
, cs563.value
, cs563.[date]
, cs564.personID
, cs564.attributeID
, cs564.value
, cs564.[date]
, cs565.personID
, cs565.attributeID
, cs565.value
, cs565.[date]
FROM Person cs562
INNER JOIN sProgram sp
ON cs562.PersonID = sp.PersonID
join...
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
March 3, 2014 at 4:37 pm
You need to find what query is running that is causing the massive growth.
Here is an article with a technique that could be applied...
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
March 3, 2014 at 4:34 pm
I like the idea of the chaos monkey. Outages need to be tested and processes practiced. Without the practice, people forget what to do or they act slowly...
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
March 3, 2014 at 4:30 pm
phonetictalk (3/2/2014)
"I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"This made me laugh out loud. Thankfully I haven't encountered such DBAs.
Yeah that is funny...
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
March 3, 2014 at 3:25 pm
Ed Wagner (3/3/2014)
BWFC (3/3/2014)
EricEyster (3/3/2014)
Ed Wagner (3/3/2014)
crookj (2/28/2014)
Ed Wagner (2/28/2014)
Ray K (2/28/2014)
SQLRNNR (2/28/2014)
crookj (2/28/2014)
EricEyster (2/28/2014)
Revenant (2/28/2014)
Ed Wagner (2/28/2014)
Kurt W. Zimmerman (2/28/2014)
SQLRNNR (2/28/2014)
cheeseparingtightfistedness
Punch
Bowl
spoon
dollop
daisy
Duke
Muscle Car (GTO)
Ronnie and the Daytonas
Dodge
Ram
Derby
Demolition
MAN
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
March 3, 2014 at 7:19 am
rjoseph (3/3/2014)
When I parse this script, I got no errors but when tried to execute it to get the backup history on SQL 2000 or 2008 databases from MSSMS...
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
March 3, 2014 at 6:51 am
Steve Jones - SSC Editor (2/28/2014)
SQLRNNR (2/27/2014)
I would like to see Daniel Suarez's book Daemon turned into a movie.
That would be quite a thriller. I need to pick up his...
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 28, 2014 at 12:48 pm
David.Poole (2/28/2014)
Hollywood seems to be doing more reboots than...
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 28, 2014 at 12:47 pm
crookj (2/28/2014)
EricEyster (2/28/2014)
Revenant (2/28/2014)
Ed Wagner (2/28/2014)
Kurt W. Zimmerman (2/28/2014)
SQLRNNR (2/28/2014)
cheeseparingtightfistedness
Punch
Bowl
spoon
dollop
daisy
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 28, 2014 at 10:04 am
Viewing 15 posts - 3,451 through 3,465 (of 19,560 total)