Viewing 15 posts - 4,201 through 4,215 (of 5,678 total)
Found most of what I was looking for, thanks to anyone who tried.
http://www.codeproject.com/KB/database/foreachadossis.aspx
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 31, 2011 at 5:13 pm
mikes84 (1/31/2011)
Craig,Thanks for your explanation. Your recommendations make sense, so I'll dig a little deeper with those.
Ping back here with the actual DDL and some sample data if you get...
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 31, 2011 at 4:39 pm
YSLGuru (1/31/2011)
Perry Whittle (1/31/2011)
pipe the output of this into a table
sqlcmd -Lc
Thanks for the suggestion but do you know if there is an equivelant syntax that shows all the servers...
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 31, 2011 at 4:16 pm
Celko, the last week or two of you was pleasant. Did they take you off the meds?
Anyway, no, there is no simple way of getting the before/after rows 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
January 31, 2011 at 4:08 pm
With no sample data and no ddl, it's hard to help you here other then to give you some troubleshooting steps.
Try commenting out portions of the code until you don't...
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 31, 2011 at 4:00 pm
dajonx (1/31/2011)
I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL service. The SPID was...
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 31, 2011 at 3:52 pm
I don't have the setup to test this, so sorry for using you as the guinea pig, but can you try changing this:
SET @SQLString = N'SELECT @CountOUT = COUNT(*) FROM...
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 31, 2011 at 3:46 pm
*facepalm* Picard's gonna make a comeback.
FROM
AZVIEWS.DBO.VW_SNF601 HIS WITH (NOLOCK) --18877
LEFT OUTER JOIN
azVIEWS.DBO.VW_SNF617 A WITH (NOLOCK) --18552
ON HIS.EID = A.EID
AND A.ORDERSTARTDATE >=DATEADD(HOUR,8,CAST(CONVERT(DATE,GETDATE()-1)AS DATETIME)) AND A.ORDERSTARTDATE <= GETDATE()
LEFT...
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 31, 2011 at 3:41 pm
vadon97 (1/31/2011)
I appreciate your input. However the tone of your message seems to relay that I said I was going to lie. I never said that.
It's...
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 31, 2011 at 3:35 pm
vadon97 (1/31/2011)
I just came across this blog post, I will start here. Looks like it's on-topic.
Actually, my guess is that's way off target. That's server architecture, a whole...
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 31, 2011 at 2:45 pm
vadon97 (1/31/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 31, 2011 at 2:44 pm
In general... yes. Unless you're doing different forms of mathmatics to the date.
The DATEADD you're seeing, is it wrapping a DATEDIFF? If so, they're stripping away pieces 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
January 31, 2011 at 2:38 pm
I would personally approach this in a different method, using a full outer join structure.
CREATE NONCLUSTERED INDEX idx_my_table ON #my_table (mt_state, mt_cust_id, mt_Invoice_No)
GO
SELECT
ISNULL( drvActive.mt_cust_id, drvInactive.mt_cust_id) AS mt_Cust_id,
ISNULL( drvActive.MaxActive, drvInactive.MaxInactive) AS...
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 31, 2011 at 2:25 pm
Henk Schreij (1/31/2011)
The trick is in the article Graig mentioned. I needed some time to find it.
Odd, that link should have taken you right to it. Ah well.
Next: finding...
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 31, 2011 at 2:17 pm
sdownen05 (1/31/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 31, 2011 at 2:07 pm
Viewing 15 posts - 4,201 through 4,215 (of 5,678 total)