SqlACID

1,624 reputation

bio	website
	location	New York, NY
	age	51
visits	member for	2 years, 3 months
	seen	May 16 at 2:31
stats	profile views	45

	1,624 reputation	bio	website		visits	member for	2 years, 3 months
59 badges		location	New York, NY		seen	May 16 at 2:31

summary answers questions tags badges favorites bounties reputation activity

112 Actions

suggestions reviews revisions comments badges posts accepts all

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
Jan 26	revised	Running a number of .sql files using SQLCMD added 75 characters in body
Jan 26	answered	Running a number of .sql files using SQLCMD