February 18, 2010 at 5:24 am
CirquedeSQLeil (2/17/2010)
Which app is best suited for the crackberry and twitter?
Personally, I'm still digging UberTwitter
"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
February 18, 2010 at 5:26 am
Lynn Pettis (2/17/2010)
GilaMonster (2/17/2010)
Lynn Pettis (2/17/2010)
Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.and DBAs know everything so that they never have to look anything up no matter what happens.
(lol) Which is why the first thing I do after opening up SSMS is to open up BOL. BOL is my friend, and so is SSC!
I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must be why I'm not certified.
"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
February 18, 2010 at 5:28 am
Grant Fritchey (2/18/2010)
I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must be why I'm not certified.
+1 to everything there!
I feel bad every time I have to look up the CREATE FUNCTION syntax...:crying:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
February 18, 2010 at 5:31 am
RBarryYoung (2/17/2010)
Alvin Ramard (2/17/2010)
RBarryYoung (2/17/2010)
CirquedeSQLeil (2/17/2010)
Has anyone noticed the success/failure rate on the QOD today?74% incorrect for Paul Randal's question on Checksum. Numbers are similar to his question the other day.
The Correct% always jumps way up on the next working day after. See if you can guess why ... 😀
hmm, why? Because some people aren't smart enough to cheat on the same day? 😀
Heh. Basically, yeah. The daily newsletter always has the previous days answer. After it goes out correct hits suddenly spike. I noticed it the first time the one time I had a QOD. First day Correct% was about 30% at midnight, by the middle of the next day it was over 70%. Hmm, those second day answerers sure are smart. ... 🙂
Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the questions... I need to find a new line of work.
"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
February 18, 2010 at 6:22 am
Steve Jones - Editor (2/17/2010)
Not sure what happened, working on a timewarp restore now, as soon as I can get the pwd from IT
Funny, I never thought I'd read a statement like that outside of an SF story! 🙂
Derek
February 18, 2010 at 7:32 am
Grant Fritchey (2/18/2010)
Lynn Pettis (2/17/2010)
GilaMonster (2/17/2010)
Lynn Pettis (2/17/2010)
Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.and DBAs know everything so that they never have to look anything up no matter what happens.
(lol) Which is why the first thing I do after opening up SSMS is to open up BOL. BOL is my friend, and so is SSC!
I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must be why I'm not certified.
Certifiable? 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 18, 2010 at 7:50 am
Alvin Ramard (2/18/2010)
Grant Fritchey (2/18/2010)
Lynn Pettis (2/17/2010)
GilaMonster (2/17/2010)
Lynn Pettis (2/17/2010)
Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.and DBAs know everything so that they never have to look anything up no matter what happens.
(lol) Which is why the first thing I do after opening up SSMS is to open up BOL. BOL is my friend, and so is SSC!
I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must be why I'm not certified.
Certifiable? 😀
Well, yeah!
"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
February 18, 2010 at 7:59 am
Alvin Ramard (2/17/2010)
Steve Jones - Editor (2/17/2010)
Alvin Ramard (2/17/2010)
Well, looks like I'm gonna have fun over the next few days. I've decided to upgrade my laptop to Win7 - 64 bits. I love re-installing all my software!!!!Enjoy. Be careful if you use iTunes. I had issues on one machine w/ x64, another worked.
Thanks, I do use iTunes, but I don't need it on the laptop. I can run it on the netbook.
It's a Toshiba laptop. What could go wrong???? :w00t:
wow, bravery in action. I think mine is officially a paperweight now too, recovery CD won't even reformat the disk.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 18, 2010 at 8:09 am
Gianluca Sartori (2/18/2010)
GilaMonster (2/18/2010)
Gianluca Sartori (2/18/2010)
In that particular case, with the identity column as primary key clustered, yes, doesn't it?Logical order of the index - yes
Physical order of the data - no
Order that the rows will be returned in - no.
Ok, it's not guaranteed and I would not rely on it, but honestly I have to say I've never seen it behaving differently.
I've been spending some time trying to make it return rows in a different order, but I did not succeed. Does anybody have a script to do that? It would be interesting to see.
It's like the Yeti, just because you've never seen it doesn't mean it doesn't exist. 😛
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 18, 2010 at 8:13 am
Grant Fritchey (2/18/2010)
Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the questions... I need to find a new line of work.
Actually, I think that means you're so damn trustworthy, you're in exactly the right line of work.
As to the BOL thing, No One Knows What They're Doing. Love this post, that's my goal in life, to learn enough to not be dangerous.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 18, 2010 at 8:15 am
jcrawf02 (2/18/2010)
Alvin Ramard (2/17/2010)
Steve Jones - Editor (2/17/2010)
Alvin Ramard (2/17/2010)
Well, looks like I'm gonna have fun over the next few days. I've decided to upgrade my laptop to Win7 - 64 bits. I love re-installing all my software!!!!Enjoy. Be careful if you use iTunes. I had issues on one machine w/ x64, another worked.
Thanks, I do use iTunes, but I don't need it on the laptop. I can run it on the netbook.
It's a Toshiba laptop. What could go wrong???? :w00t:
wow, bravery in action. I think mine is officially a paperweight now too, recovery CD won't even reformat the disk.
Mine is working fine, but I'd like to improve performance a bit. With 64 bits, I'll be able to boost the memory and get some improvement that way.
I'm not 100% sure I'm going to upgrade to 64 bits. There's a voice telling me to buy a new laptop instead. Decisions, decisions, decisions.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 18, 2010 at 8:47 am
jcrawf02 (2/18/2010)
Grant Fritchey (2/18/2010)
Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the questions... I need to find a new line of work.Actually, I think that means you're so damn trustworthy, you're in exactly the right line of work.
As to the BOL thing, No One Knows What They're Doing. Love this post, that's my goal in life, to learn enough to not be dangerous.
That's an awesome link. Thanks! I love the pie graph in it about what you know.
Hi, My name is Travis. (in tha back ground "Hi Travis"), I'm a Books Online Addict. lol. Isn't there a Quote somewhere from Einstein about not bothering to remember things he could look up quickly?
The import thing IMO is to know how to use the information not just memorize a bunch of text.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
February 18, 2010 at 8:58 am
tstaker (2/18/2010)
... Isn't there a Quote somewhere from Einstein about not bothering to remember things he could look up quickly? ...
I can't remember. Should I look it up? 😛
Edit: I did look it up.
According to this wiki, Albert Einstein once said: "I never commit to memory anything that can easily be looked up in a book."
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 18, 2010 at 9:06 am
tstaker (2/18/2010)
jcrawf02 (2/18/2010)
Grant Fritchey (2/18/2010)
Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the questions... I need to find a new line of work.Actually, I think that means you're so damn trustworthy, you're in exactly the right line of work.
As to the BOL thing, No One Knows What They're Doing. Love this post, that's my goal in life, to learn enough to not be dangerous.
That's an awesome link. Thanks! I love the pie graph in it about what you know.
Hi, My name is Travis. (in tha back ground "Hi Travis"), I'm a Books Online Addict. lol. Isn't there a Quote somewhere from Einstein about not bothering to remember things he could look up quickly?
That's how I see it too. I try to make all of my interview questions "Open Book". As far as I'm concerned, being able to look it up quickly is almost as good as knowing it off the top of your head.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 18, 2010 at 9:36 am
Paul White (2/18/2010)
I got the checksum question wrong by the way - fell into the 'single bit error' bear trap 😎
I used Paul's blog on the topic. He had a post to debunk some myths about checksum. Answers weren't stated outright but could be derived from that article. I spent about ten minutes on that question - got it right woot.
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 - 11,731 through 11,745 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply