Viewing 15 posts - 2,071 through 2,085 (of 5,678 total)
Personally, I'd start investigating your wait_state on the spid running the process and looking into your locks. You sound blocked, not slow.
EDIT: If you're sure it's just slow, we...
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
December 14, 2011 at 3:01 pm
SQLRNNR (12/14/2011)
Revenant (12/14/2011)
bitbucket-25253 (12/14/2011)
SQLRNNR (12/14/2011)
Jim Murphy (12/14/2011)
Steve Jones - SSC Editor (12/14/2011)
SQLRNNR (12/14/2011)
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D
40F in Denver, no need for pants...
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
December 14, 2011 at 2:59 pm
Eddie Wuerch (12/14/2011)
CREATE ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP(LISTENER_PORT =...
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
December 14, 2011 at 1:49 pm
Stefan Krzywicki (12/14/2011)
Jim Murphy (12/14/2011)
Steve Jones - SSC Editor (12/14/2011)
SQLRNNR (12/14/2011)
Steve Jones - SSC Editor (12/13/2011)
SQLRNNR (12/13/2011)
About due for a Pantsectomy :-D:-D:-D:-D40F in Denver, no need for pants today.:-P
Just 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
December 14, 2011 at 1:46 pm
Nice question Ron.
Have we made a case for sp_Tally?
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
December 14, 2011 at 1:06 pm
Not really. Two instances are two servers, and between two servers you need to generate endpoints and routes. This is most often done via certificates.
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
December 14, 2011 at 12:54 pm
tigerlilly_783 (12/14/2011)
1) Is there a better way to do this without making tons of calls...
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
December 14, 2011 at 12:25 pm
Stefan Krzywicki (12/14/2011)
So separate physical spindles for the data and log files? And those should...
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
December 14, 2011 at 12:09 pm
NineIron (12/14/2011)
Pardon my ignorance. I should have read your post regarding forum etiquette first.
I hope I did this correctly.........here is three months of data for one provider. From here...
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
December 14, 2011 at 12:05 pm
Stefan Krzywicki (12/14/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
December 14, 2011 at 11:39 am
I must be crazy, I haven't lost track of the thread and I'm pretty sure I know the story Gus is talking about! I think I played Getzalif 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
December 14, 2011 at 10:59 am
NineIron (12/12/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
December 13, 2011 at 2:07 pm
GSquared (12/13/2011)
Kraig, RAID-1 uses mirroring. It can survive a single drive failure. Can't survive both drives failing, but neither can RAID-5.
I'm going to go grab a glass pipe...
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
December 13, 2011 at 1:54 pm
jsmith08 (12/13/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
December 13, 2011 at 1:24 pm
TravisDBA (12/13/2011)
Evil Kraig F (12/12/2011)
GSquared (12/12/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
December 13, 2011 at 12:13 pm
Viewing 15 posts - 2,071 through 2,085 (of 5,678 total)