Viewing 15 posts - 2,596 through 2,610 (of 2,747 total)
While you can install both (I've got SQL2012 Enterprise and SQL2008R2 Express on my work PC,) one of them will have to be a named instance.
IE if you install SQL2008R2...
October 22, 2012 at 2:55 pm
Lowell,
I actually just stole your code, pretty much word for word. Below is the Agent Job step 1 I'm using:
use msdb
go
declare @DeleteToDate datetime()
set @DeleteToDate = DATEADD(d, -30, getdate())
DELETE FROM...
October 22, 2012 at 10:06 am
Steve Jones - SSC Editor (10/22/2012)
October 22, 2012 at 9:46 am
My thanks to Lowell!
Using your Delete commands, plus adding one to delete from dbo.sysmail_mailitems, the DB is down to about 23GB from 133GB!
Set up an Agent job to run once...
October 22, 2012 at 9:39 am
Brandie Tarvin (10/22/2012)
You know what I hate about pie charts?
You can never tell what filling they're using. And it's awfully hard to...
October 22, 2012 at 8:16 am
Good article, and I've forwarded it on to one of the Supervisors here as suggested reading for staff...
But, in the last section, in the sentence:
When I was in college, one...
October 18, 2012 at 7:58 am
While it was a bit of snarky reply, it's also true. If you want to automate something like this, it's going to have to be scheduled somehow. Either...
October 18, 2012 at 7:48 am
Lowell I'll give those a try once my re-restore of the DB on my test box completes...
It only takes about an hour-and-a-half or so to restore...
😉
Thanks!
Jason
October 17, 2012 at 11:13 am
Brandie Tarvin (10/17/2012)
dwain.c (10/16/2012)
Jeff Moden (10/16/2012)
... and he couldn't name the function to get the current date and time
Perhaps he was so focused on the future he's never interested in...
October 17, 2012 at 5:59 am
Aw yeah!
Just one more win to go for the Tigers!!
I think I'm seeing brooms tomorrow!
😀
October 16, 2012 at 10:14 pm
Actually, even if they back it up with compression, you can restore it. I tested this recently here at my work, as we have clients who (tightwads) use SQL...
October 15, 2012 at 2:05 pm
Your best bet to get the best answer, is going to be to contact a Microsoft Licensing specialist. I'm presuming your using Volume Licensing, in which case here's the...
October 15, 2012 at 8:02 am
Not looking good for the As' at this point.
Top of the 7th, Tigers have knocked in 3 runs with the bases loaded (and they're still loaded) with 2 outs...
October 11, 2012 at 9:53 pm
SQLRNNR (10/10/2012)
October 11, 2012 at 10:06 am
Brandie Tarvin (10/10/2012)
jasona.work (10/10/2012)
WayneS (10/10/2012)
Steve Jones - SSC Editor (10/9/2012)
jasona.work (10/5/2012)
So *YOU'RE* the reason the wifi packed it up after the first 15 minutes!
All joking aside, I did enjoy the...
October 10, 2012 at 8:43 am
Viewing 15 posts - 2,596 through 2,610 (of 2,747 total)