May 9, 2013 at 3:28 pm
make this crash?
select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
May 9, 2013 at 3:29 pm
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Care to give a more in depth explainatioin? I'm lost as to the questioin.
May 9, 2013 at 3:32 pm
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
What's the exact error? Can you copy/paste it from SSMS please?
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 9, 2013 at 3:36 pm
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Because you have the table alias in the wrong place:
select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)
May 9, 2013 at 3:38 pm
Lynn Pettis (5/9/2013)
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Because you have the table alias in the wrong place:
select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)
Heh, whoops, I missed that when I looked at it. My eyes glazed right over 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 9, 2013 at 3:44 pm
Evil Kraig F (5/9/2013)
Lynn Pettis (5/9/2013)
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Because you have the table alias in the wrong place:
select t.cbclaim from [dev].[stage].[dbo].[claimsview] t with(noexpand)
Heh, whoops, I missed that when I looked at it. My eyes glazed right over that.
I checked the syntax in BOL. I don't use table hints very often at all.
May 9, 2013 at 6:50 pm
omg i feel like such a dunce...
I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.
May 9, 2013 at 6:57 pm
drew.georgopulos (5/9/2013)
omg i feel like such a dunce...I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.
Don't sweat it. Most of us have people who can check us in the cube next door when we're headbanging on a 'pre-coffee' problem. I've certainly asked a few of those myself. 🙂
Happy to have tried to help.
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 10, 2013 at 5:51 am
Funny you should say that...I used to be part of a cube culture, but due to familial circumstances, my employer allowed me to continue working out of state as a remote employee, so i really miss that collaboration and excitement in mutual discovery...its part of what makes this list so invaluable to me.
I also want you to know that i know this is not the first time you and Lynn have stepped up to help me, not to mention Jeff, Steve and Gail, who are big repeat helpers, as well as others who have offered help, and to express my appreciation for that...its an oasis that reminds me of the comradery of the Compuserve days, almost like the cube next door 🙂
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply