Viewing 15 posts - 16,231 through 16,245 (of 19,560 total)
I would also recommend checking out http://www.sqlservercentral.com/articles/Log+growth/69476/ to help you track down the culprit.
You can setup a job to track your growths and capture the query that is at 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 18, 2010 at 4:52 pm
You're welcome.
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 18, 2010 at 4:51 pm
Late last night I saw a question but didn't respond to it because I was shutting down in the intent of answering it today.
I can't find it anymore.
Anybody see a...
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 18, 2010 at 4:45 pm
Steve Jones - Editor (3/18/2010)
I completely agree with you. The Cert test ought to be HARD, I mean very hard, like how do I fix xxx when it's broken, or...
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 18, 2010 at 4:43 pm
Jeffrey Williams-493691 (3/14/2010)
iamthemanx (3/14/2010)
I know for sure is a security stuff, the way SSMS2008 is reading that from the SQL2005 instance....
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 18, 2010 at 4:39 pm
Now it's everybody else's turn 😀
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 18, 2010 at 4:29 pm
JC-3113 (3/18/2010)
on Paul's i get an errorthe linked one works
how do i save it to a file ?
Thanks
Jim
I copy and paste the results. I have not played with other...
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 18, 2010 at 3:57 pm
Jack Corbett (3/18/2010)
It was definitely harder than 70-432, but common sense gets you through it. There...
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 18, 2010 at 3:33 pm
crookj (3/18/2010)
CirquedeSQLeil (3/17/2010)
tosscrosby-60625 (3/17/2010)
crookj (3/17/2010)
Fantastic! (65% and Sunny in Colorado in March :w00t:)Joe
65%???? It's 60 degrees and sunny in Chicago too! Spring fever!
Only 71 today here.
Tomorrow - High of 31...
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 18, 2010 at 3:06 pm
JC-3113 (3/18/2010)
question:is there a way to spool the output to a file so i do not have to copy and paste it into a file ?
Thanks
Jim
Is this for the script...
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 18, 2010 at 3:02 pm
itsmeman (1/19/2010)
Very good advice. I love this site and the books offered for free have helped my knowledge tremendously. Dissecting SQL Execution Plans.... Perfect for tuning SQL.
Can we get those...
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 18, 2010 at 2:54 pm
tstaker (3/18/2010)
GSquared (3/18/2010)
john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?
Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered,...
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 18, 2010 at 2:51 pm
Stefan_G (3/18/2010)
Changing datatype changes the semantics and needs to be very carefully tested.
It is not something you want to do unless it is really necessary.
This is a point that I...
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 18, 2010 at 2:38 pm
J-F Bergeron (3/18/2010)
CirquedeSQLeil (3/18/2010)
You will see several examples at http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-questionThanks, I'll do some reading, looks interesting.
You're welcome.
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 18, 2010 at 2:12 pm
NP
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 18, 2010 at 2:11 pm
Viewing 15 posts - 16,231 through 16,245 (of 19,560 total)