Viewing 15 posts - 661 through 675 (of 1,524 total)
Deleting data will cause the backup size to decrease but the file sizes of the .mdf files will not. However, you will fragment the data within the tables you...
January 17, 2013 at 8:37 am
Michael Valentine Jones (1/15/2013)
Markus (1/15/2013)
Has anyone done any comparision to the SQL2008R2 backups with compression as far as time taken to run and size of backup and compared...
January 15, 2013 at 9:17 am
Interesting thoughts, thanks.
Has anyone done any comparision to the SQL2008R2 backups with compression as far as time taken to run and size of backup and compared it to, say LiteSpeed?...
January 15, 2013 at 8:33 am
I have a job that runs monthly that runs this:
DECLARE @DeleteBeforeDate DateTime = (Select DATEADD(d,-30, GETDATE()))
EXEC sysmail_delete_mailitems_sp @sent_before = @DeleteBeforeDate
EXEC sysmail_delete_log_sp @logged_before = @DeleteBeforeDate
January 15, 2013 at 5:25 am
I pulled up Frank Thomas's numbers and he only had 2,400 career hits... his best years were from '91 to 2000. He had some lost seasons with injuries. ...
January 10, 2013 at 12:49 pm
Steve Jones - SSC Editor (1/9/2013)
January 10, 2013 at 4:47 am
That is good to know Steve. We are about to purchase all new back end storage but I don't think any will be SSD's for any of our SQL...
January 4, 2013 at 1:37 pm
I have heard some horror stories a year or so ago about SSDs.... the one guy I know who works for MSFT as a SQL Server guru said, at...
January 4, 2013 at 11:05 am
bipan (1/3/2013)
We have a activity coming up in our project where sql server 2005 three node cluster will be lifted and shifted to new Data center.In new DC...
January 4, 2013 at 6:19 am
Cubs Sign Edwin Jackson
By Ben Nicholson-Smith [January 2 at 11:55am CST]
The Cubs have officially signed Edwin Jackson, the team announced. It's a four-year contract worth $52MM, and it does not...
January 2, 2013 at 11:44 am
stillconfused (12/20/2012)
I have to apply patches on SQL server in cluster ACTIVE/ACTIVE.
On 2008R2 (RTM) need to apply SP2
On 2008 SP2 need to apply SP3
On 2008 SP1 need to...
December 27, 2012 at 9:26 am
The issue of I/Os taking longer than 15 seconds to complete is a very difficult thing to trace down. I had a case open with Microsoft on this issue...
December 20, 2012 at 8:29 am
Ray K (12/19/2012)
Nice little writeup on Don Mattingly, who was my favorite player when I was in high school, regarding his Cooperstown chances . . .
If you didn't see him...
December 20, 2012 at 5:36 am
Ray K (12/17/2012)
Damn -- looks like the Toronto Blue Jays are serious about making some noise in the AL East this upcoming season!!!
That is if RA Dickey can come close...
December 17, 2012 at 8:44 am
Jan Van der Eecken (12/17/2012)
December 17, 2012 at 5:58 am
Viewing 15 posts - 661 through 675 (of 1,524 total)