April 5, 2012 at 9:12 am
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.
Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
"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
April 5, 2012 at 9:15 am
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.If I say gravity goes up, then gravity goes up, dammit!
Define "up"
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 5, 2012 at 9:17 am
SQLRNNR (4/5/2012)
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.If I say gravity goes up, then gravity goes up, dammit!
Define "up"
Whatever direction I say it is at any given moment.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 5, 2012 at 9:19 am
Stefan Krzywicki (4/5/2012)
SQLRNNR (4/5/2012)
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.If I say gravity goes up, then gravity goes up, dammit!
Define "up"
Whatever direction I say it is at any given moment.
Up is the direction the house floats when all the balloons are inflated.
April 5, 2012 at 9:21 am
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
I just couldn't help it. Basically, when would I use fragmentation was part of the question.
I'm beginning to wonder where some of these people are coming from that are working with SQL Server. I'm sorry, but it is scary to think that some companies actually have people with no clue protecting the company crown jewels.
April 5, 2012 at 9:24 am
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
I just couldn't help it. Basically, when would I use fragmentation was part of the question.
I'm beginning to wonder where some of these people are coming from that are working with SQL Server. I'm sorry, but it is scary to think that some companies actually have people with no clue protecting the company crown jewels.
And, let's never forget, they're paying for the privilege!
"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
April 5, 2012 at 9:29 am
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
I just couldn't help it. Basically, when would I use fragmentation was part of the question.
I'm beginning to wonder where some of these people are coming from that are working with SQL Server. I'm sorry, but it is scary to think that some companies actually have people with no clue protecting the company crown jewels.
And, let's never forget, they're paying for the privilege!
Some how, the old adage "You get what you pay for" comes to mind.
April 5, 2012 at 9:49 am
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
I just couldn't help it. Basically, when would I use fragmentation was part of the question.
I'm beginning to wonder where some of these people are coming from that are working with SQL Server. I'm sorry, but it is scary to think that some companies actually have people with no clue protecting the company crown jewels.
True, but I think that last sentence should read
"I'm sorry, but it is scary to think that most companies actually have people with no clue protecting the company crown jewels."
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 5, 2012 at 9:50 am
You know, I'm not so much concerned about people that can't read, they can learn. My problem is with people that can read but can't seem to comprehend what they read then ask questions that were already answered by what they had read.
I
April 5, 2012 at 9:52 am
Lynn Pettis (4/5/2012)
You know, I'm not so much concerned about people that can't read, they can learn. My problem is with people that can read but can't seem to comprehend what they read then ask questions that were already answered by what they had read.I
Oh wow, shocker! Someone actually realized I answered their question in a previous post!
April 5, 2012 at 10:01 am
Stefan Krzywicki (4/5/2012)
Lynn Pettis (4/5/2012)
Grant Fritchey (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.Look at it as a complement. To many people, we're the SQL Server documentation. That's pretty cool.
If I look at it any other way I start to get annoyed.
I just couldn't help it. Basically, when would I use fragmentation was part of the question.
I'm beginning to wonder where some of these people are coming from that are working with SQL Server. I'm sorry, but it is scary to think that some companies actually have people with no clue protecting the company crown jewels.
True, but I think that last sentence should read
"I'm sorry, but it is scary to think that most companies actually have people with no clue protecting the company crown jewels."
hair hair hear hear here here
I am finding that statement to be more accurate with every day.
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 5, 2012 at 10:06 am
Has anyone written up what happens to a table when a clustered index is dropped making the table a heap? What I am wondering is if the order of the data changes or does it retain the logical order of the data at the time the clustered index was dropped?
I know that nonclustered indexes, if defined, get rebuilt as the clustered index key has to be replaced with the RID of the heap.
If not, what native tools could be used to investigate what happens? Seems to be an interesting topic.
April 5, 2012 at 10:18 am
Lynn Pettis (4/5/2012)
Has anyone written up what happens to a table when a clustered index is dropped making the table a heap? What I am wondering is if the order of the data changes or does it retain the logical order of the data at the time the clustered index was dropped?
I would imaging the order be retained. There's no logical reason to re-order the table when dropping a cluster, seeing as a heap has no concept of order.
If not, what native tools could be used to investigate what happens? Seems to be an interesting topic.
DBCC IND, DBCC PAGE.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2012 at 10:22 am
Lynn Pettis (4/5/2012)
... Basically, when would I use fragmentation was part of the question.
I don't know, but I'd give the OP the benefit of the doubt. English is clearly not his/her first language.
Viewing 15 posts - 35,206 through 35,220 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply