Viewing 15 posts - 17,386 through 17,400 (of 19,560 total)
VP (unexpected)
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 12, 2010 at 9:26 am
crookj (2/12/2010)
Jolly Green GiantJoe
Just made me think of that brand and the commercials
Ho ho ho, Green Giant.
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 12, 2010 at 9:25 am
David Burrows (2/12/2010)
GSquared (2/12/2010)
WayneS (2/12/2010)
[physic]Hmmm.... with Barry, Gail and Lynn involved, I sense an article in the future[/physic]
I'm not sure that's the tag you wanted, Wayne.
Dictionary definition: physic noun: ...
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 12, 2010 at 9:23 am
Thanks for taking the time to create a QOD.
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 12, 2010 at 9:21 am
You have to build it dynamically. Can't remember the cause or the reference but that first use statement will get executed every time.
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 11, 2010 at 8:55 pm
According to MSDN:
http://msdn.microsoft.com/en-us/library/ms187956.aspx
This is the 2008 article on creating views. It states that the select statement cannot contain the into keyword nor can it contain the option clause.
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 11, 2010 at 8:40 pm
Please provide table structure. This will help isolate the cause of your fragmentation.
Also, knowing your process for performing the inserts would be helpful. The cause is likely 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
February 11, 2010 at 8:16 pm
mstjean (2/11/2010)
Ray
(...you talkin' to ) Me?
Fah (yeah)
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 11, 2010 at 3:36 pm
mstjean (2/11/2010)
Doh was yesterday's.
Today is "so-close-to-the-weekend-I-can-taste-it"
Whoops. Sorry, forgot to include the code I used to derive my d'oh. When I re-ran it, it still comes up d'oh.
CASE
...
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 11, 2010 at 2:39 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
February 11, 2010 at 2:37 pm
I would not update maintenance plans, that belong to a 2005 instance, from SSMS 2008. An upgrade to the maintenance plan may be attempted. Otherwise, I use SSMS...
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 11, 2010 at 12:39 pm
Surrogate
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 11, 2010 at 9:00 am
Thanks Josef. Nice concise explanation. The data space requirements is also good information.
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 11, 2010 at 12:13 am
Agreed. Good back to basics question.
Thanks
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 10, 2010 at 11:18 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
February 10, 2010 at 10:43 pm
Viewing 15 posts - 17,386 through 17,400 (of 19,560 total)