Viewing 15 posts - 4,141 through 4,155 (of 5,685 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...
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...
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),...
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...
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)...
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",...
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...
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...
February 4, 2011 at 11:55 am
will s (2/3/2011)
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...
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...
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...
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
...
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...
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...
February 3, 2011 at 4:22 pm
Viewing 15 posts - 4,141 through 4,155 (of 5,685 total)