Viewing 15 posts - 2,581 through 2,595 (of 5,678 total)
Part of the issue is the explicit conversion after the function to a different datatype, messes with the optimizer.
Another is the differences between @tmp and #tmp. @tmp has statistical and...
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
September 19, 2011 at 3:34 pm
Rich Yarger (9/19/2011)
Kraig, thank you for sharing this. I'm sure my guys who are working on this are going to be thrilled!😛
My pleasure... kinda. Every time I 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
September 19, 2011 at 2:57 pm
Tom.Thomson (9/19/2011)
SQL Kiwi (9/19/2011)
Evil Kraig F (9/19/2011)
Paul, remember when I mentioned in that other thread that Partitioning seems to be a Level III item? 🙂
Indeed. Perhaps we need...
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
September 19, 2011 at 2:52 pm
The entire process is a rabbit hole. Imagine having all of your code looking like this in source safe:
If not exists (table)
Create table (15 columns)
If not exists (select...
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
September 19, 2011 at 2:43 pm
This might have to do with cross database ownership chaining and the SSRS login not having permissions, as SQLRNNR mentioned above. I'd usually expect an error in 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
September 19, 2011 at 2:37 pm
Welcome to my personal little slice of hell. What's up Rich?
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
September 19, 2011 at 2:27 pm
SQL Kiwi (9/17/2011)
vk-kirov (9/16/2011)
Good question, but the answer is totally wrong.
Exactly. I can only imagine the author did test the code before submitting this question, but made a late...
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
September 19, 2011 at 1:00 pm
Brandon Carl Goodman (9/19/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
September 19, 2011 at 12:26 pm
Ranask, we need to see the index definitions as well, the schema is only half the battle... and speaking of, I understand the desire to only give us the columns...
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
September 19, 2011 at 11:45 am
jdpowell777 (9/19/2011)
Okay, great, thanks for the response
My pleasure, good luck. 🙂
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
September 19, 2011 at 11:04 am
GilaMonster (9/17/2011)
Tom.Thomson (9/17/2011)
GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for 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
September 17, 2011 at 12:38 pm
jdpowell777 (9/16/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
September 17, 2011 at 12:31 pm
PHXHoward (9/15/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
September 15, 2011 at 5:58 pm
ALZDBA (9/15/2011)
SQLRNNR (9/15/2011)
WayneS (9/15/2011)
SQLRNNR (9/15/2011)
Just saying that we only need 98 more posts for 30,000how many?
Ummm - 96
Make up your mind. No guessing 😉
Bah! This is a SQL Server...
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
September 15, 2011 at 1:47 pm
this might be a silly question, but are you running the IIS and SSRS on the same server as the database?
If so, that's not helping.
A datawarehouse server is quite common...
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
September 14, 2011 at 12:52 pm
Viewing 15 posts - 2,581 through 2,595 (of 5,678 total)