Viewing 15 posts - 361 through 375 (of 5,678 total)
Using a configuration?
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
March 10, 2014 at 5:28 pm
paul.knibbs (3/7/2014)
Evil Kraig F (3/5/2014)
Raid 0 is a multidisk stripe that if any fail you lose the stripe. Single disk = same risk, just less throughput.
Actually, a single disk...
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
March 7, 2014 at 8:29 pm
sqlbuddy123 (3/6/2014)
Query tuning is good but it takes time. Just the intention was if we can identify the bottleneck, fixing it would be simpler.
The quick and dirty way to find...
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
March 6, 2014 at 5:59 pm
I'd take this as a two phase approach.
First, you need to get your current data into the format you want. No matter what you do, you're going to do...
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
March 6, 2014 at 5:44 pm
Cafescott,
I think you have multiple issues here that while you need to address them simultaneously, need to be approached independently.
The first is the physical security and access, which has already...
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
March 6, 2014 at 1:21 pm
free_mascot (3/5/2014)
Bulk and Simple use similar logging techniques for minimally logged transactions, so either would work for that purpose. In my experience, while this will help, it requires a...
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
March 6, 2014 at 1:04 am
GilaMonster (3/5/2014)
Evil Kraig F (3/5/2014)
GilaMonster (3/5/2014)
create index IX_A_Col1 on A ( Col1, IndexID )
Having it as a second key column is more...
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
March 5, 2014 at 1:37 pm
GilaMonster (3/5/2014)
create index IX_A_Col1 on A ( Col1, IndexID )
Having it as a second key column is more useful than having 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
March 5, 2014 at 1:24 pm
No, the clustered index is already included in all nonclustered indexes. The include would be superfluous unless you're trying to protect against someone changing the clustered index in 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
March 5, 2014 at 1:23 pm
N_Muller (3/5/2014)
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
March 5, 2014 at 1:03 pm
george sibbald (3/5/2014)
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
March 5, 2014 at 11:31 am
Koen Verbeeck (3/5/2014)
I'm not serious, hence the smiley 🙂It was a great QotD, but I answered without thinking it through (on a 3 point question!!!).
Not enough caffeine...
Just double checking. :)...
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
March 5, 2014 at 11:10 am
Koen Verbeeck (3/5/2014)
Evil Kraig F (3/5/2014)
Other than I apparently created a 3! point question for the QotD... 😎(I didn't think it was THAT difficult...)
It was very misleading though 😉
Hrm, if...
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
March 5, 2014 at 10:56 am
Hey Barry, welcome back.
In general, not much... Other than I apparently created a 3! point question for the QotD... 😎
(I didn't think it was THAT difficult...)
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
March 5, 2014 at 10:31 am
Nope, but understand, when you say Raid 0, that's not a single disk.
Raid 0 is a multidisk stripe that if any fail you lose the stripe. Single disk =...
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
March 5, 2014 at 9:31 am
Viewing 15 posts - 361 through 375 (of 5,678 total)