Viewing 15 posts - 1,396 through 1,410 (of 5,678 total)
Les Cardwell (6/30/2012)
USE AdventureWorks2008R2;
GO
EXEC sp_getapplock @DbPrincipal = 'dbo', @Resource...
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
June 30, 2012 at 6:10 pm
Can you provide us a copy/paste of the raw with the missing data that's causing the error? If we can see the error specifically and have the raw 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
June 29, 2012 at 6:59 pm
rjbirkett (6/29/2012)
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
June 29, 2012 at 6:38 pm
Wrap this DML in an applock.
Basically:
CREATE PROC blah AS
sp_getapplock
Begin Tran
...
End Tran
sp_releaseapplock (or whatever it's called, that's close)
END
What that'll do is force a waitstate at the sp_getapplock until it can...
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
June 29, 2012 at 6:32 pm
I assume multiple calls against the same proc are what's causing the deadlocking, or is it deadlocking itself?
If it's multiple calls, you might try using an sp_applock wrapper in 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
June 29, 2012 at 6:00 pm
Lynn Pettis (6/29/2012)
I should know,...
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
June 29, 2012 at 5:58 pm
Lynn Pettis (6/29/2012)
Evil Kraig F (6/29/2012)
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
June 29, 2012 at 4:51 pm
End to end code. I just got SLAMMED at work before the weekend starts up so I need to clear a few things, luckily I comment as I go....
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
June 29, 2012 at 4:46 pm
Running through an iteration on the methodology and I've run into a bit of a confusion.
I'd thought SntDt and RcvDt would simply be directly associated to if it was 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
June 29, 2012 at 4:25 pm
GilaMonster (6/29/2012)
Evil Kraig F (6/29/2012)
GilaMonster (6/29/2012)
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
June 29, 2012 at 3:36 pm
I may have just realized the problem. Thanks for the reminder Michael, I went off escaping and didn't really think through the allowable characters for the pattern replacements.
Please remember...
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
June 29, 2012 at 3:33 pm
DataAnalyst110 (6/29/2012)
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
June 29, 2012 at 3:31 pm
The expression looks fine. Either it's not mapped to a second stream or something else went funky.
Drop a dataviewer onto the stream it's NOT supposed to be in 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
June 29, 2012 at 3:17 pm
Use CHARINDEX() > 0. Don't use PATINDEX though, same problems as LIKE.
Basically:
SELECT * from syscomments where CHARINDEX( [text], '*') > 0.
Easiest workaround I'm aware of.
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
June 29, 2012 at 3:14 pm
Lynn Pettis (6/29/2012)
Evil Kraig F (6/29/2012)
Craig, feel free to jump in like you did with that wonderful explaination. Code wise, you may be right, we all code slightly differently,...
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
June 29, 2012 at 3:08 pm
Viewing 15 posts - 1,396 through 1,410 (of 5,678 total)