Viewing 15 posts - 5,551 through 5,565 (of 5,678 total)
Ah. That would depend more on the method of expansion I think, but if you're working with any of the drives that SQL server relies on, you can just...
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 16, 2010 at 6:09 pm
Drix,
More then happy to help you, but need a little more information from you, since we're going to need to actually test that code. It's too dense to spot...
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 16, 2010 at 5:43 pm
Sql Server won't care about the drive size unless you tell it to (such as expanding a filesize manually), or it needs to autogrow an existing file. Then it...
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 16, 2010 at 5:32 pm
LutzM (9/16/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 16, 2010 at 4:38 pm
Yeah, Lutz, pretty much the same result, but I see what you're driving at. I had been originally tempted not to put in any code at all and ask...
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 16, 2010 at 3:54 pm
cfradenburg (9/16/2010)
Generic optimizations are difficult to give since how long something takes will vary depending on the schema.
Yeah, I know, it's painful, but I was figuring this had...
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 16, 2010 at 3:07 pm
GilaMonster (9/16/2010)
If so, move TempDB completely (ALTER DATABASE TempDB ...), then...
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 16, 2010 at 2:55 pm
$1/strip? I'd be more then happy to subscribe, say, $10/year for a weekly strip, but $1/strip? Yeaaah, no.
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 16, 2010 at 2:53 pm
Jeff Moden (9/16/2010)
Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?He's finally learnt to spell properly. 😀
Perhaps a course on 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
September 16, 2010 at 2:50 pm
GilaMonster (9/16/2010)
- One database with corrupt log that required a restore
- One very long restart/recovery (12 hours) resulting from poor (non-existent almost) I/O...
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 16, 2010 at 2:42 pm
WayneS (9/16/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 16, 2010 at 2:26 pm
Don't throw the system databases onto the log drive, you're just begging for trouble that way. If you wanted to get really intense about it, each log should 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
September 16, 2010 at 2:22 pm
Single user case study: Raw Materials got me back into the forums when I spun by off a link from another site that had some instructions on a task 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 16, 2010 at 10:58 am
The quick and dirty is that readpast skips locked records. This causes a problem if the front page is grabbing a table lock, instead of row/page locks. SQL...
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 16, 2010 at 2:10 am
You know how all those websites out there have 'personal questions' and only send resets to pre-set emails in the account and the like? It's because of exactly what...
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 16, 2010 at 2:02 am
Viewing 15 posts - 5,551 through 5,565 (of 5,678 total)