August 5, 2011 at 12:30 pm
Ninja's_RGR'us (8/5/2011)
That's got to be a new record!
Not one I'm interested in breaking, though.
- 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
August 5, 2011 at 12:31 pm
Stefan Krzywicki (8/5/2011)
GilaMonster (8/5/2011)
Stefan Krzywicki (8/5/2011)
That's where the "as we know it" comes in. We're getting there, but it is a slow process.Maybe in your neck of the woods. Down here I think people are trying very hard to bring back the dark ages.
Oh, there are plenty of people here <I>trying</I> very hard to bring back the dark ages. Progress is made in spite of them. I find it remarkable, but it does keep happening.
Ghandi: What do I think of Western Civilization? I think it would be a very good idea.
- 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
August 5, 2011 at 12:40 pm
GSquared (8/5/2011)
Ninja's_RGR'us (8/5/2011)
That's got to be a new record!Not one I'm interested in breaking, though.
Is it even possible?
@steve-2, what is the oldest post that didn't get answered? I can't see it being very far off!
August 5, 2011 at 12:50 pm
Ninja's_RGR'us (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
What the heck is this supposed to to? :w00t:
155 million row update on a very wide table (which has been heavily thinned from the original) in an incredibly weak Dev SAN environment that they won't invest in.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 5, 2011 at 2:28 pm
Ninja's_RGR'us (8/5/2011)
GSquared (8/5/2011)
Ninja's_RGR'us (8/5/2011)
That's got to be a new record!Not one I'm interested in breaking, though.
Is it even possible?
@steve-2, what is the oldest post that didn't get answered? I can't see it being very far off!
You were reading my mind.:-P
Send Steve into a Data Mining frenzy.
August 5, 2011 at 2:45 pm
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2011 at 2:46 pm
Greg Edwards-268690 (8/5/2011)
Ninja's_RGR'us (8/5/2011)
GSquared (8/5/2011)
Ninja's_RGR'us (8/5/2011)
That's got to be a new record!Not one I'm interested in breaking, though.
Is it even possible?
@steve-2, what is the oldest post that didn't get answered? I can't see it being very far off!
You were reading my mind.:-P
Send Steve into a Data Mining frenzy.
Ah gosh the weekend is coming up in a matter of minutes, give Steve a break after all he has the horses to look after, and I assume clean the manure out of the barn ....
August 5, 2011 at 2:48 pm
Gianluca Sartori (8/5/2011)
I'm officially out.I'll never, ever be an employee again.
I'll punch my timecard for the last time in 1 minute.
Good luck! (I have to admit that I'm somewhat jealous.)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2011 at 2:49 pm
WayneS (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
I was thinking the same thing.
On the flip side, I was wondering if may be billing by the hour to watch that query run 😉
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
August 5, 2011 at 3:01 pm
WayneS (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
LOL, don't think I didn't review this? I know what it's doing and why and can have it run on another machine that's not purposely OS memory starved with crappy san LUN setup in an hour or two.
To save you the headache, it's got a reporting centric clustered index and is thus running a key lookup, no room for serious log growth, the tempdb space is quite limited, and it's running a 100k record loop for sanity.
And yes, I have billed some hours while watching to make sure it doesn't fail...:Whistling:
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 5, 2011 at 3:13 pm
Craig Farrell (8/5/2011)
WayneS (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
LOL, don't think I didn't review this? I know what it's doing and why and can have it run on another machine that's not purposely OS memory starved with crappy san LUN setup in an hour or two.
To save you the headache, it's got a reporting centric clustered index and is thus running a key lookup, no room for serious log growth, the tempdb space is quite limited, and it's running a 100k record loop for sanity.
And yes, I have billed some hours while watching to make sure it doesn't fail...:Whistling:
Sweet!!
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
August 5, 2011 at 3:25 pm
SQLRNNR (8/5/2011)
Craig Farrell (8/5/2011)
WayneS (8/5/2011)
Craig Farrell (8/5/2011)
A moment of Friday Humor...Time to optimize, perhaps?
You know, for a not-so-small amount, I can do things like optimize queries. 😉
LOL, don't think I didn't review this? I know what it's doing and why and can have it run on another machine that's not purposely OS memory starved with crappy san LUN setup in an hour or two.
To save you the headache, it's got a reporting centric clustered index and is thus running a key lookup, no room for serious log growth, the tempdb space is quite limited, and it's running a 100k record loop for sanity.
And yes, I have billed some hours while watching to make sure it doesn't fail...:Whistling:
Sweet!!
Not the words I've been using of late, but I can't leave a picture of a triple facepalm on my emails everytime I send a report to the bosses about this... 😎
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 5, 2011 at 3:42 pm
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspx
p.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
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
August 5, 2011 at 4:24 pm
GilaMonster (8/5/2011)
Anyone want to 'help' out here? http://www.sqlservercentral.com/Forums/Topic1155386-391-1.aspxp.s. if you go to his blog, several posts have pieces copy-paste from a Microsoft webpage, no attribution
Yeah - I actually recently wrote about that[/url].
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
August 5, 2011 at 4:27 pm
It was hit "I see that on expert's blogs. Why shouldn't I have it?" that got me.
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
Viewing 15 posts - 28,771 through 28,785 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply