Viewing 15 posts - 17,986 through 18,000 (of 19,560 total)
http://en.wikipedia.org/wiki/Kobe_beef
A Japanese beef dish. The beef coming from a very specific breed and upbringing and region.
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 21, 2010 at 1:21 pm
I think it is less about the company having a set plan, than the Sr DBA having a set plan.
There will be critical information that must be learned, that behooves...
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 21, 2010 at 1:14 pm
And here is info on the Profiler that Jeff spoke of:
http://www.eraofdata.com/blog/tag/sql-profiler/
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 21, 2010 at 12:23 pm
This may help...
If you know a time window during which this event is most likely to occur then a scheduled job could be created. The scheduled job would run...
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 21, 2010 at 12:11 pm
david.wright-948385 (1/21/2010)
mtassin (1/21/2010)
david.wright-948385 (1/21/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
January 21, 2010 at 11:51 am
What I like about this question is that it was worth 1 measly point. Due to the shortness of the question, and the large number who missed it initially...
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 21, 2010 at 11:44 am
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
January 21, 2010 at 10:51 am
talltop-969015 (1/21/2010)
rick-507511 (1/21/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
January 21, 2010 at 10:47 am
Lynn Pettis (1/21/2010)
david.wright-948385 (1/21/2010)
Lynn Pettis (1/21/2010)
I selected the correct answer without hesitating.
How'd you do that without knowing which version of SQL Server it was asking about, or whether the model...
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 21, 2010 at 10:34 am
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
January 21, 2010 at 9:04 am
timfle (1/21/2010)
The answer is the same size as the model database. And 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
January 21, 2010 at 8:57 am
stewartc-708166 (1/20/2010)
each version and edition is differentthe question should have been a bit more precise, i.e. specifying for which version / edition it was being asked
That is true. Specifying...
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 21, 2010 at 12:02 am
I decided to go back and test this on SQL 2008 after my last post.
I verified both Model database settings, and created a new database. I have not altered...
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, 2010 at 11:53 pm
b0b555 (1/20/2010)
"The default size for an mdf is 2MB and 1MB for an ldf, based on the model database".
It can't default to 2mb/1mb AND...
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, 2010 at 11:49 pm
I couldn't have said it better myself. This very notion is evident in SSC with some of the heavy hitters constantly giving of their time to help others.
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, 2010 at 11:42 pm
Viewing 15 posts - 17,986 through 18,000 (of 19,560 total)