Forum Replies Created
Viewing 15 posts - 15,166 through 15,180 (of 19,560 total)
-
RE: system tables only
In sql 2005 those objects are still existent but they are views. The rest of the pertinent system objects that are the upgrade versions of those objects are 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 -
RE: Exponent Engima
I too liked the discussion as I reread it today.
Involve math, SQL, and a good discussion and you have a good QOD!!:cool:
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 -
RE: more than 250 indexes on a table
I would focus your time on the indexes and not so much the statistics. Tune your indexes and combine them where appropriate.
In 2000 there is also no script that...
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 -
RE: how database gets updated on the secondary instance if I have Active/PAssive clustering setup.
GregoryF (4/7/2010)
Because you create an alias called SQLPROD.Normally SQLPROD points to ABCPR. If you have to go to DR, the alias is pointed to ABCDR1.
Just flush the DNS on...
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 -
RE: ANSI_NULLS
RBarryYoung (4/7/2010)
Paul:Now I'm curious to know how you did on mine...? (here: http://www.sqlservercentral.com/questions/T-SQL/63632/) Its still got one of the lowest correct percentages that I know of.
Out of curiosity,...
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 -
RE: Exponent Engima
Nice question. I think the math behind the question is revealing for the answer.
Good Job on this Barry (p.s. got it correct).
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 -
RE: Today's Random Word!
crookj (4/7/2010)
The Weather has been funny down here in the Springs. Snow for 30 mins the sunshine for 30 - Been back an forth all morning thus far.Joe
Clear Blue...
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 -
RE: Today's Random Word!
Steve Jones - Editor (4/7/2010)
snow, snow, snow, snow, snow, snow, snowWoke up to a kid asking if school was delayed. It's not, but it looks like this:
That is odd....
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 -
RE: MCJ - The Missing Link
Lynn Pettis (4/7/2010)
WayneS (4/7/2010)
CirquedeSQLeil (4/7/2010)
That is two areas where we could use the local PASS chapters to assist with this certification. They could help serve as the review board...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 -
RE: Raw Materials - Redundancy and Frugality
I read this late last night and am still chuckling at it.
Time to post it in the cube.
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 -
RE: Are the posted questions getting worse?
I just heard Dave, Simon and Theodore yell... Aaaaalvin!!!
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 -
RE: How to Play the SSC Game - SSC Points
I personally like going down the road of "James Bond" movies as SSC type ranks
GoldenEye
GoldFinger
Thunderball
Dr.No
Moonraker
etc
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 -
RE: Are the posted questions getting worse?
Grant Fritchey (4/7/2010)
Steve Jones - Editor (4/7/2010)
SL-1 was brave, some big, shiny (now) glowing, brass ones on those guys.I went in the reactor containment once and was nervous the entire...
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 -
RE: ANSI_NULLS
Paul,
I hope you don't mind. I took your great script and made a modification to it. I am posting it here. This mod version makes reading 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 -
RE: ANSI_NULLS
Paul White NZ (4/7/2010)
Toreador (4/7/2010)
Is there any situation where setting ansi_nulls off is a good idea?I have never come across one. Apart from the bizarre rules illustrated by 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
Viewing 15 posts - 15,166 through 15,180 (of 19,560 total)