Viewing 15 posts - 3,166 through 3,180 (of 5,678 total)
All of the above is good, but there are a few things you're going to want to know from a technical lead standpoint:
- Your web programmer and database developer have...
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
May 20, 2011 at 12:08 pm
Hey Rocky,
If you can put your data into a consumable format like you'll find in the first link of my signature, there's a pretty easy solution using Tally Tables that...
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
May 20, 2011 at 11:25 am
LOL, I should have looked up what re-entrant meant before answering. Oops. 🙂 That'll learn me.
I wasn't thinking in terms of multiple connections, but the same connection re-entering...
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
May 20, 2011 at 11:19 am
Pretty much with Ninja on this one. Light up 'actual execution plans' and take a look at the difference in them.
This parameter: SaveSetIntID='SS20047560'
My guess is when you get to...
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
May 20, 2011 at 11:16 am
raymurphy (5/19/2011)
missing an obvious way to go about this, but I'm still nowhere near...
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
May 19, 2011 at 3:15 pm
Steve Jones - SSC Editor (5/19/2011)
mister.magoo (5/19/2011)
[rant]This takes the biscuit http://www.sqlservercentral.com/Forums/FindPost1112017.aspx
[/rant]
I think it's time for happy hour. That's crazy
BWAHAHAHAHAHAAHAHAHAHA... sorry, but holy newbie! That really needed to be a...
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
May 19, 2011 at 2:59 pm
Grant Fritchey (5/19/2011)
Craig Farrell (5/19/2011)
Steve Jones - SSC Editor (5/19/2011)
Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1Tried my humble best.
No,...
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
May 19, 2011 at 2:55 pm
Steve Jones - SSC Editor (5/19/2011)
Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1
Tried my humble best.
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
May 19, 2011 at 1:31 pm
abygaikwad17 (5/19/2011)
Few things I would like to know (assuming table is not partitioned):
1. Can I access extent or page information related to any particular table?
If so,...
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
May 19, 2011 at 1:31 pm
Interesting discussion.
There are really only three reasons to work. To get paid, to volunteer to those less fortunate or educated, or to try to better yourself or your surrounds....
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
May 19, 2011 at 12:20 pm
Yeah, that was my first thought Gus, and I found they have the exact same execution plans. I tried it from the other direction, a straight cross join then...
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
May 18, 2011 at 12:45 pm
BobA 66314 (5/18/2011)
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
May 18, 2011 at 12:11 pm
ningaraju.n (5/17/2011)
Hi Craig Farrell,We have done all the indexing and query optimization at the best,So thought of asynchronous processing.Could you please help on this?
Fire up a new thread on the...
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
May 18, 2011 at 12:05 pm
Brandie Tarvin (5/18/2011)
DECLARE @MaxTally int;
SELECT @MaxTally = Max(ID) FROM dbo.Combinations;
SELECT c.ID, t.N AS TallyID
FROM dbo.Combinations c
CROSS JOIN...
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
May 18, 2011 at 12:01 pm
All I've got is an equivalent method that uses joins/ons instead of leaving it all in the WHERE clause, but it's the same execution plan. Subquery had the same...
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
May 18, 2011 at 11:55 am
Viewing 15 posts - 3,166 through 3,180 (of 5,678 total)