Viewing 15 posts - 4,141 through 4,155 (of 5,678 total)
drew.allen (2/1/2011)
Jeff Moden (2/1/2011)
drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate...
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
February 4, 2011 at 1:10 pm
Am I correct that all of this:
RAID 5: DRIVES F - K
- F: 34gb (tempdb ONLY)
- G: 4gb (ROFG1 - Read Only Filegroup for static tables)
- H: 55gb (FG1 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
February 4, 2011 at 12:59 pm
GilaMonster (2/4/2011)
Craig Farrell (2/4/2011)
mike 57299 (2/4/2011)
1) Checkpoint
2) Backup Log File
3) DBCC Shrinkfile ( log file),...
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
February 4, 2011 at 12:31 pm
Ever done a Transaction Log backup? From your description, I'm assuming you're not aware of the necessity. Your Transaction Log has also been growing and growing with 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
February 4, 2011 at 12:29 pm
mike 57299 (2/4/2011)
1) Checkpoint
2) Backup Log File
3) DBCC Shrinkfile ( log file), 0, Truncateonly
4)...
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
February 4, 2011 at 12:22 pm
VBScript. I shoulda guessed. 😉
Is this a legacy DTS package stored on your 2k5 server?
Also, to the original question:
StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))
EndDate = CStr(DATEADD("m", DATEDIFF("m",...
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
February 4, 2011 at 12:12 pm
jcrawf02 (2/3/2011)
Craig Farrell (2/3/2011)
Steve Jones - SSC Editor (2/3/2011)
I rarely delete stuff, but that one went so sideways, with almost no technical info, that I decided to whack it.
Probably 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
February 4, 2011 at 12:07 pm
Multiple simultaneous recursion testing with timers in UAT environments. Really the only way. You can't test for load interference on an unloaded system. You can guess, but...
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
February 4, 2011 at 11:55 am
will s (2/3/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
February 4, 2011 at 10:55 am
Jeff Moden (2/4/2011)
Craig Farrell (2/3/2011)
Hm, you appear to have hit on something here... especially depending on the indexing.Using this new benchmarking code:
Wow! Lots'o code! What conclusion do you...
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
February 4, 2011 at 10:32 am
My only comment on that article is to make sure your firewall CLOSES the SQL Server's ports. You still have to expose that server to internet access. Lock...
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
February 3, 2011 at 5:59 pm
LutzM (2/3/2011)
Craig Farrell (2/3/2011)
Is it bad that I consider the 'Don't Feed The Trolls' sign a challenge to see if I can manage to piss off a Troll enough 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
February 3, 2011 at 5:19 pm
Hm, you appear to have hit on something here... especially depending on the indexing.
Using this new benchmarking code:
SET NOCOUNT ON
IF OBJECT_ID( 'tempdb..#Tally') IS NOT NULL
...
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
February 3, 2011 at 5:15 pm
mike 57299 (2/3/2011)
I'm it. We are using full recovery mode. We do a full backup everyday at 3am and transactional backups from 6am - 8pm everyday.
That seems 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
February 3, 2011 at 4:25 pm
You won't be able to parse, unfortunately, with the parameters. Turn bypass prepare to true, make sure your parameters are named 0, 1, 2 (etc), and give her 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
February 3, 2011 at 4:22 pm
Viewing 15 posts - 4,141 through 4,155 (of 5,678 total)