Viewing 15 posts - 5,581 through 5,595 (of 5,678 total)
WayneS (9/15/2010)
I believe so, but I've never tried it. How about running a test and letting us know?
Why was I afraid you'd say that? New thread created 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
September 15, 2010 at 3:53 pm
Usually when this happens on an active database you force truncate the log immediately, and then proceed to an immediate full or differential backup, because you broke the log-chain.
If you're...
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
September 15, 2010 at 3:36 pm
Hey Wayne, does substring still work if the data for the VARCHAR(MAX) is no longer stored in row, and goes out to a separate LOB page?
I thought I...
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
September 15, 2010 at 3:14 pm
jcrawf02 (9/15/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
September 15, 2010 at 3:09 pm
jcrawf02 (9/15/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
September 15, 2010 at 2:58 pm
WayneS (9/15/2010)
Craig Farrell (9/15/2010)
sql.abhishek (9/15/2010)
I am desperately looking for some piece of code to get this type of out put .... kindly help me out of this.
For the code, you'll...
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
September 15, 2010 at 2:47 pm
It won't directly impact it, but it will let your logs get transferred faster because their smaller. You can find out more details about the specifics between full 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
September 15, 2010 at 2:46 pm
jcrawf02 (9/15/2010)
Be a good gig for a BASE jumper.
:w00t: I never thought I'd get such delicious ideas for my... extracurricular activities... from a SQL forum. I like yer thinkin'.
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
September 15, 2010 at 2:40 pm
Post repeat, please see question/responses here: http://www.sqlservercentral.com/Forums/Topic986689-145-1.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
September 15, 2010 at 2:38 pm
The more urgently you need something, the more time you'll need to take writing out the sample code you'd like us to mess with. A couple of things though:
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
September 15, 2010 at 2:36 pm
sql.abhishek (9/15/2010)
I am desperately looking for some piece of code to get this type of out put .... kindly help me out of this.
For the code, you'll really need 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
September 15, 2010 at 2:33 pm
Steve Jones - Editor (9/15/2010)
bitbucket-25253 (9/15/2010)
...By the way for some reason going down is always slower and harder than going up.
By the way, if going down is much faster 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
September 15, 2010 at 2:30 pm
Swap to bulk-logged. The target system(s) will have to recreate the work but your logs will be smaller.
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
September 15, 2010 at 2:14 pm
WayneS (9/15/2010)
Craig Farrell (9/15/2010)
[EDIT:] Heheh, Wayne, fastest code gun in the west. 🙂 [/EDIT]Maybe, but sometimes it's draw,shoot,aim instead of aim,shoot,draw... heh, wait-a-minute... :crazy:
And thus, we find out why...
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
September 15, 2010 at 1:13 pm
Derrick Smith (9/15/2010)
Ah crap, I did. Didn't even notice that. Hard to follow the logic of this query..working on it.
If it makes you feel better, I just did a facepalm...
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
September 15, 2010 at 1:03 pm
Viewing 15 posts - 5,581 through 5,595 (of 5,678 total)