Viewing 15 posts - 14,806 through 14,820 (of 19,560 total)
Roy Ernest (4/15/2010)
Ok, I will try that. I have been staring at the article for some time in the morning....
That is the worst thing to do.
If you are stumped -...
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
April 15, 2010 at 3:14 pm
GabyYYZ (4/15/2010)
Lynn Pettis (4/15/2010)
Alvin Ramard (4/15/2010)
Lynn Pettis (4/15/2010)
Okay denizens of The Thread, here's a good one!Looks like someone skipped class during Basic Database Design 101.
Skipped A class? How about...
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
April 15, 2010 at 2:54 pm
Without knowing your structure, no.
With users manually entering data, you are introducing an error level that would nearly negate the need for an automated mechanism. How can you guarantee...
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
April 15, 2010 at 2:51 pm
anbillava (4/15/2010)
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
April 15, 2010 at 2:41 pm
Keep it in Oracle if it is for DR.
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
April 15, 2010 at 2:18 pm
You will need to provide DDL, and index create statements. Otherwise we are just taking a shot in the dark.
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
April 15, 2010 at 2:12 pm
Out of row storage would be just about 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
April 15, 2010 at 2:10 pm
You're welcome. Hope it works out for 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
April 15, 2010 at 1:58 pm
That is the crux of the definition of this thread.
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
April 15, 2010 at 1:42 pm
bigd45 (4/15/2010)
All Little update, I just passed the 70-448 exam. I will be working on the Oracle too.
Congrats
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
April 15, 2010 at 1:39 pm
Try this article.
http://www.mssqltips.com/tip.asp?tip=1023
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
April 15, 2010 at 1:01 pm
I would bet on it being the webpolice.
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
April 15, 2010 at 12:45 pm
Alvin Ramard (4/15/2010)
CirquedeSQLeil (4/15/2010)
GSquared (4/15/2010)
jcrawf02 (4/15/2010)
Must I repeat the pythagorean theorem joke?Yes, it's mandatory at this point.
Agreed
STEVE!!!!!!
Hurry back!!!!!
All he hears is the whoosh of skis on snow and birds in...
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
April 15, 2010 at 12:40 pm
I would rather rely on the DMVs to track proc usage. A trace for 30 minutes would be inadequate in every environment I have been in. We also...
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
April 15, 2010 at 12:40 pm
Elliott W (4/15/2010)
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
April 15, 2010 at 12:13 pm
Viewing 15 posts - 14,806 through 14,820 (of 19,560 total)