Viewing 15 posts - 4,861 through 4,875 (of 5,678 total)
Two questions in one, EJ, just an FYI. 🙂
First, you need to compare one row to the previous row. This is usually done via a CTE with a ROW_NUMBER()...
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
November 22, 2010 at 1:59 pm
Rog Saber (11/22/2010)
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
November 22, 2010 at 1:52 pm
TAMMYAUDETTE (11/22/2010)
Your thoughts?
My first instinct is that you're looking to do administrative level tasks. Are all servers in house to your company, or is the target SQL Server an...
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
November 22, 2010 at 1:48 pm
Grant, what about the option of using PAGELOCK as a table hint during the delete? If it's clustered on the ID, that'll keep it out of the way 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
November 22, 2010 at 1:37 pm
Dominic,
I'm sorry that this is an untested recommendation, but I believe DBCC CHECKIDENT can be used to change the seed on a replicated table if the identity is set for...
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
November 22, 2010 at 1:34 pm
In addition to GSquared's recommendation, which I'd check first...
Are the result sets large-ish (say 10k rows each or more?) independently? Are you doing more with the UNION ALL than...
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
November 22, 2010 at 1:23 pm
I configured Transactional Replication without database snapshot
This is most likely the problem. There was most likely changes to the source db between the time you made the copy...
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
November 22, 2010 at 1:19 pm
pavan_srirangam (11/22/2010)
one last question
If I add more .ndf files to the database will reduce pagelatch_up waits and resource is 5:1:3 no.
Because I found there are...
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
November 22, 2010 at 12:55 pm
da-zero (11/22/2010)
Craig Farrell (11/22/2010)
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
November 22, 2010 at 12:30 pm
pavan_srirangam (11/18/2010)
have you ever come across this problemIf so let me now what you did ?
I came across a tragedy like this only once. I forced a redesign...
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
November 22, 2010 at 12:22 pm
The other option is using the expressions in the OLEDB source object, and setting servername via the variable, then using that as the source for a dataflow pair.
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
November 22, 2010 at 12:13 pm
Removed, inaccurate.
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
November 22, 2010 at 11:02 am
WayneS (11/22/2010)
Stefan Krzywicki (11/22/2010)
Brandie Tarvin (11/22/2010)
Chris Morris-439714 (11/22/2010)
CirquedeSQLeil (11/22/2010)
Chris Morris-439714 (11/22/2010)
Wishing Jack C a speedy recovery and some quality time for recuperation.Get well soon, mate.
Did I miss something more than...
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
November 22, 2010 at 10:32 am
Not declaring the name ends up with a system defined one. It's usually used for Temp tables and the like to avoid conflicting names when the proc is run...
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
November 20, 2010 at 12:44 pm
CirquedeSQLeil (11/20/2010)
Craig Farrell (11/19/2010)
WayneS (11/19/2010)
LutzM (11/19/2010)
WayneS (11/19/2010)
Craig Farrell (11/19/2010)
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
November 20, 2010 at 11:16 am
Viewing 15 posts - 4,861 through 4,875 (of 5,678 total)