March 18, 2010 at 3:23 pm
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!!!!:-)
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
March 18, 2010 at 3:30 pm
David Burrows (3/18/2010)
BWAAAHAAA....TWANG......
Hmmmmm... the possible makings of new T-Shirt.:-P
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2010 at 3:33 pm
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
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 4:20 pm
Way to go, Unc.... 😀
__________________________________________________
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 4:29 pm
Now it's everybody else's turn 😀
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 4:45 pm
Late last night I saw a question but didn't respond to it because I was shutting down in the intent of answering it today.
I can't find it anymore.
Anybody see a question asking how to differentiate between Editions of SQL Server (i think he stated MSDE and Enterprise and provided some version numbers)?
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 4:56 pm
Nevermind - I finally found it.
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 7:14 pm
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.)
Actually, back in 1997, I was able to create two clustered indexes on a table in a Sybase database. The table didn't survive the operation, but the operation was a success.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 18, 2010 at 8:52 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. 🙂
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
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2010 at 9:05 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. 🙂
Actually, there is a way this can be done - maybe.
For each index, create an indexed view covering the columns in the index. Of course, once that is done - just try making a change to the table. See how long it takes you to drop all of the views - and indexes, update the table and rebuild all of the views.
Could be lots of fun :hehe:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 18, 2010 at 9:09 pm
Jeffrey Williams-493691 (3/18/2010)
Could be lots of fun :hehe:
In a sinisterly maniacal way.:sick:
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 9:14 pm
CirquedeSQLeil (3/18/2010)In a sinisterly maniacal way.:sick:
Yes - but that is what would be so much fun 😀
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 18, 2010 at 9:45 pm
Jeffrey Williams-493691 (3/18/2010)
CirquedeSQLeil (3/18/2010)In a sinisterly maniacal way.:sick:
Yes - but that is what would be so much fun 😀
Passing it off to the Junior and watching the Jr try to do it. That would be insanely fun.:-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 10:48 pm
David Burrows (3/18/2010)
It's that recurring nightmare of Jeff creeping up on me with a Pork Chop Launcher......BWAAAHAAA....
TWANG......
Powerful mental image there...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 18, 2010 at 10:53 pm
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.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 15 posts - 12,976 through 12,990 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply