Viewing 15 posts - 14,956 through 14,970 (of 19,560 total)
I also have to wonder, why is this "Masters" exam using SQL 2000 as the material for examination? If we provided answers relevant to SQL 2005, they won't work...
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 12, 2010 at 2:11 pm
Jeff Moden (4/12/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 12, 2010 at 2:08 pm
I have a couple of queries that I use for that kind of information. Please forgive the usage of deprecated objects in these scripts. I need to update...
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 12, 2010 at 2:03 pm
GSquared (4/12/2010)
Just had a guy today who posted a whole exam, which he says "a friend needs for his masters program".
Where is that one? I think it might...
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 12, 2010 at 1:56 pm
It comes from how the cursor is deallocated. Are you explicitly deallocating a cursor or just allowing the server to deallocate it without a specific command to deallocate.
There 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
April 12, 2010 at 1:50 pm
Steve Jones - Editor (4/12/2010)
We aren't typically annoyed by beginner questions. Even silly ones, but what does get to be "worse" in our minds is the people that don't make...
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 12, 2010 at 1:44 pm
TAMMYAUDETTE (4/12/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 12, 2010 at 1:39 pm
GSquared (4/12/2010)
Yeah, the "high performance children" thing isn't a mature technology anyway....
Can't disagree about the mature technology - but my children always have their engines revved from pre-dawn to post...
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 12, 2010 at 1:08 pm
Either of those articles would be a good place to start.
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 12, 2010 at 1:04 pm
Ah yes the circle of life. Raise children from diapers to successful adults. Then they turn around and raise you from successful adult to diapers.
Not a day 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
April 12, 2010 at 1:02 pm
GSquared (4/12/2010)
CirquedeSQLeil (4/12/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 12, 2010 at 12:55 pm
jcrawf02 (4/12/2010)
CirquedeSQLeil (4/12/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 12, 2010 at 12:54 pm
JJ B (4/12/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 12, 2010 at 12:03 pm
hennie7863 (4/12/2010)
Upgrading to SQL2K8 is currently not an option for the vendor. I'm still thinking about deleting statistics...
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 12, 2010 at 12:01 pm
sing4you (4/12/2010)
Doing formulas in Excel :sick:
:sick: is right.
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 12, 2010 at 11:00 am
Viewing 15 posts - 14,956 through 14,970 (of 19,560 total)