March 18, 2010 at 10:57 pm
GSquared (3/18/2010)
john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could you make all our indexes clustered, please?". (I only think about it.)
Sure. That one's easy. Just means every table can only have one index, but it can be done. 🙂
[pedant] Two clustered indexes: one regular one, and one primary xml[/pedant]
I suppose you could go further and create indexed views over the whole table too, to provide an unlimited number of clustered indexes, at the expense of a certain amount of data duplication...;-)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 18, 2010 at 10:58 pm
Jeff Moden (3/18/2010)
David Burrows (3/18/2010)
BWAAAHAAA....TWANG......
Hmmmmm... the possible makings of new T-Shirt.:-P
Should give Steve an idea for your 20,000 posts award.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 18, 2010 at 11:01 pm
Speaking of time zones, it's midnight here.
Goodnight, Paul
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 11:19 pm
The Dixie Flatline (3/18/2010)
Speaking of time zones, it's midnight here. Goodnight, Paul
Night Bob. That puts you somewhere like Chicago...CDT. Just after 6pm Friday here.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 18, 2010 at 11:44 pm
Paul White NZ (3/18/2010)
CirquedeSQLeil (3/18/2010)
I am curious why you changed your alias to include NZ.Several reasons, mostly consistency. I am registered with that name on other forum-type sites, and it matches my email address. It also gives people a clue that I may not share their time zone.
Makes sense.
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
March 18, 2010 at 11:47 pm
Paul White NZ (3/18/2010)
The Dixie Flatline (3/18/2010)
Speaking of time zones, it's midnight here. Goodnight, PaulNight Bob. That puts you somewhere like Chicago...CDT. Just after 6pm Friday here.
Close via timezone.
He's in Tennessee.
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
March 18, 2010 at 11:48 pm
Well look at that, 3 more posts to 13,000.
That last 1000 flew by quickly.
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
March 18, 2010 at 11:52 pm
2
sorry accidental click on the reply button:-D
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
March 18, 2010 at 11:53 pm
1
Oh mercy mercy, I couldn't resist:-P
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
March 19, 2010 at 1:26 am
Zero :exclamation:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 19, 2010 at 6:04 am
Congratulations Paul, on winning the coveted 13K award!!
I'm thinking we should all agree on November 18th being recognized as Thread Day.
I'm in Oxford, Mississippi, actually, about an hour south of Memphis.
Memphis sits on the Mississippi River at the extreme western edge of Tennessee.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 19, 2010 at 6:09 am
Jack Corbett (3/18/2010)
For those not on twitter. I took and passed 70-450 today.It was definitely harder than 70-432, but common sense gets you through it. There isn't a training kit for it, so I basically read up on my worst topics in BOL.
Congrats. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 19, 2010 at 6:10 am
Jeff Moden (3/18/2010)
GSquared (3/18/2010)
john.arnott (3/18/2010)
Lynn Pettis (3/17/2010)
Like clustered indexes are better than nonclustered indexes?Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, could you make all our indexes clustered, please?". (I only think about it.)
Sure. That one's easy. Just means every table can only have one index, but it can be done. 🙂
BWAA-HAAA!!!! If you put everything into a single EAV, you CAN have a clustered index on all the data in the database. :hehe::-D
Yep.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 19, 2010 at 6:14 am
The Dixie Flatline (3/19/2010)
I'm in Oxford, Mississippi, actually, about an hour south of Memphis. Memphis sits on the Mississippi River at the extreme western edge of Tennessee.
The words 'Mississippi' and 'Tennessee' scare me slightly. Way too many repeated vowels, and a very low score for consonant-diversity!
edit: Morning, Bob!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 19, 2010 at 6:16 am
Jeff Moden (3/18/2010)
BWAA-HAAA!!!! If you put everything into a single EAV, you CAN have a clustered index on all the data in the database. :hehe::-D
Database design is easy these days. I just store absolutely everything in a single VARBINARY(MAX) column in one table. One row too - and it doesn't get any more efficient than that.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 12,991 through 13,005 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply