Viewing 15 posts - 4,231 through 4,245 (of 5,678 total)
In this specific case, there is a unique time to use a nonclustered index that repeats the left side of the clustered index... but you're not at that point.
That case...
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
January 30, 2011 at 12:53 am
prassu.ibm (1/29/2011)
My question is how to create a table in a single file
Two questions:
1) Why do you think it isn't?
2) We are discussing Microsoft SQL Server as your RDBMS here,...
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
January 30, 2011 at 12:48 am
Take this on one concept at a time here...
adam spencer (1/29/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
January 30, 2011 at 12:46 am
Lynchie (1/28/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
January 29, 2011 at 9:10 pm
jared-709193 (1/28/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
January 29, 2011 at 9:03 pm
mohammed moinudheen (1/27/2011)
Craig,I checked with one ex Microsoft employee. He says the product license is permanent but the product support would be renewed on yearly basis.
Ah, hm, okay. 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
January 28, 2011 at 12:20 am
I agree with Lutz. Nice work on the data collection as well. The next step is to examine the query execution plans for @sUpdateLastYear between the windows and non-windows...
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
January 26, 2011 at 6:25 pm
MB, as Lutz pointed out, none of these queries allow us to compare the difference in the queries in your system when you do, or don't, add in the:
AND tblX.Div...
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
January 26, 2011 at 9:45 am
spmaguire (1/25/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
January 25, 2011 at 4:20 pm
duncfair (1/25/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
January 25, 2011 at 3:45 pm
GSquared (1/25/2011)
And that's almost certainly more than anyone here wants to know about this subject. :w00t:
... listens enraptured. "Not really, that's damnably interesting, actually."
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
January 25, 2011 at 1:32 pm
LutzM (1/25/2011)
GilaMonster (1/25/2011)
...Bing maps are off then. It's just under 7500km from Johannesburg to Algier (http://www.wolframalpha.com/input/?i=what+is+the+distance+from+Johannesburg+to+Algier)
When using the same tool: London sounds much more reasonable 😉
Side note: interesting web site...
Nah...
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
January 25, 2011 at 1:09 pm
Follow the link in my sig that reads:
For index/tuning help, follow these directions.
It'll show you how to extract your .sqlplans
You can post the code here in the code="sql" tags, or...
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
January 25, 2011 at 1:06 pm
A quick test will show you how this works. Run this code in your analyzer:
;WITH cte (cola, colb, colc) AS
( SELECT 1,2,3),
cte2 (cola, colb, colc) AS
(SELECT 1,2,3)
SELECT
cola,colb,colc
FROM
cte
UNION...
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
January 25, 2011 at 12:46 pm
I'm thinkin' Greece. Gail wants gyros!
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
January 25, 2011 at 12:44 pm
Viewing 15 posts - 4,231 through 4,245 (of 5,678 total)