Viewing 15 posts - 1,651 through 1,665 (of 5,678 total)
Okay, I'm confused by the bolding of my name randomly in this post:
http://www.sqlservercentral.com/Forums/FindPost1278324.aspx
Is that supposed to mean something or am I just over-sensitive due to frustration with a completely different...
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
April 4, 2012 at 1:18 pm
This, I believe, will work better for you:
DECLARE @currentDate datetime = ' 2012-03-22'
SELECT DISTINCT
DC.DoctorID, ca.StatusCode
FROM schDIA.tblDoctor AS D
INNER JOIN schDIA.tblDoctorContact AS DC ON D.DoctorID = DC.DoctorID
INNER JOIN schDIA.tblDoctorLicenseHistory...
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
April 4, 2012 at 12:37 pm
bullo (4/4/2012)
Probably something to do with SQLEXpress, but I dont...
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
April 4, 2012 at 12:24 pm
Mac1986 (4/4/2012)
But we have 17 jobs getting kicked of every 5 mins and all...
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
April 4, 2012 at 12:17 pm
Questions:
Is '" &this_claday_starttime& "' the start time of the class in question or the start time of the day for all classes? Same question for '" &this_claday_endtime& "'
What does...
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
April 4, 2012 at 11:46 am
Alright, these statements are deadlocking:
UPDATE dbo.WorkQueue
and the first select that uses WorkQueue which drops to a table variable.
Since the second statement could only lock up WorkQueue, I won't 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
April 4, 2012 at 11:23 am
GilaMonster (4/4/2012)
Mac1986 (4/4/2012)
It looks like SPID 76,85 and 91 are suspended. Not sure what process is responsible for it. Is it SPID 25?
No. It's a deadlock, processes 76, 85 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
April 4, 2012 at 11:01 am
Brandie Tarvin (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
I'm stealing these name spellings for a story. @=)
You guys wanna be villains, heroes, 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
April 4, 2012 at 10:55 am
That graph looks incomplete. It's almost all SPID 25, so unless it's deadlocking itself, that won't fly well. Is that the full graph or did you edit it heavily?...
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
April 3, 2012 at 7:48 pm
You need to google the keyword: Pivot.
After that, if you want more complete help, please see the first link on the left in my signature below to setup staging data...
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
April 3, 2012 at 7:42 pm
sqlmaverick (4/3/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
April 3, 2012 at 7:00 pm
Have you looked at sys.sysprocesses while it's running to determine if it is being blocked? That's not a code issue, that's a concurrency issue (unless you're deadlocking yourself, which...
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
April 3, 2012 at 6:19 pm
TeraByte, to answer your question and to try to ease future pain of concurrent attempts to insert, which is what Orlando was leading to, can I recommend you take steps...
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
April 3, 2012 at 6:15 pm
I agree with Elliott that you're using a best practice scenario there with what's available. For more complex decisions I'll occasionally use an asynchronous script component that will simply...
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
April 3, 2012 at 4:42 pm
misstryguy (4/3/2012)
Hi Craig,Valid transaction excludes any orders that were not fulfilled like the example above were both order O1 and O2 did not fulfill has the qty received were zero.
Ah,...
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
April 3, 2012 at 4:38 pm
Viewing 15 posts - 1,651 through 1,665 (of 5,678 total)