1,727 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 7 months
seen Aug 13 at 12:17

Jun
8
awarded  Caucus
May
31
comment Defragmenting SQL Server data and log files live with MoveFile API
I'd be asking how SQL server disks got so fragmented; proper planning and space management makes fragmentation a non-issue.
May
11
comment Optimization around static cursor use
Get some SSD's for tempdb if you're stuck with this mess.
Apr
27
answered Backup database and clean old backup question
Apr
27
comment Backup database and clean old backup question
What is the usual cause of the crash? A standard maintenance plan should handle this easily as long as you're not running out of disk space during backups.
Apr
20
comment Microsoft SQL Server 2008 R2 Subscriptions
Are you running Enterprise Edition? It's required for data-driven subs IIRC.
Apr
17
comment How to determine the size of a SQL Server database for a specific date in the past?
If you don't have a purge job set up, you can find all your backup sizes in msdb.dbo.backupset; I've used it to backtrack database sizes many times.
Apr
2
answered SQL 2008 Developer Edition, not using all CPU´s
Mar
28
comment Requirement of SQL Server 2008
Is it possible they don't support named instances? Or require a specific instance name?
Mar
23
revised SQL Server asks for 100GB for a dump with 1GB
added 67 characters in body
Mar
23
answered SQL Server asks for 100GB for a dump with 1GB
Mar
22
answered SQL Server 2008 R2 Express high insert slowdown possibly due to PAGEIOLATCH_SH
Mar
7
comment What does a DBA have to know about SSAS?
Excellent info..especially the "you can set options that will break the server on start up" advice.
Mar
5
answered How to see the value of a variable being used in an sql statement during a server trace?
Mar
5
answered How to detach corrupt database in SQL Server
Mar
5
answered SQL Server 2005 uses 1GB of RAM
Feb
10
answered Looking for a way of moving millions of record without impacting the transaction log
Feb
8
answered Is SQL Server 2008 Change Data Capture (CDC) possible NOT to keep record when inserting?
Jan
31
answered How to add linked server SQL Server 2008 R2
Jan
26
revised Running a number of .sql files using SQLCMD
added 11 characters in body