SqlACID

1,624 reputation

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

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

summary answers questions tags badges favorites bounties reputation activity

39 Comments

suggestions reviews revisions comments badges posts accepts all

Mar 29	comment	SQL Server 2005 Unexpected Disk Usage during Backups Sounds like a snapshot file or a temp file from 3rd party backup; is it a normal sql backup? Filemon should definitely have something jump out.
Nov 30	comment	How do I determine what MDF files are in use I think one danger with this technique is if auto-close is enabled on any databases, you could probably delete an mdf that is still attached. Haven't tried it though.
Jul 25	comment	SQL Server 2012 Data Warehousing Overall Flow Read The Microsoft Data Warehouse Toolkit by Joy Mundy, and also the Kimball books, they give very good guidance.
Jul 23	comment	Always being logged in as SA and not Windows account Is it because you are in the sysadmin group on your machine but not on the server? You could remove your account from sysadmin locally, but you have to be care to make sure you have another account to administer the server with.
Jul 21	comment	Always being logged in as SA and not Windows account sounds like the default schema is not set for the account; run "select default_schema_name , type_desc , name , create_date from sys.database_principals " on both and check your account.
Jul 20	comment	Always being logged in as SA and not Windows account Are you using Management Studio to connect? If so, check the properties on the connection. Or create a new connection in Registered Servers and specifiy Windows Authentication.
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	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.
Mar 28	comment	Requirement of SQL Server 2008 Is it possible they don't support named instances? Or require a specific instance name?
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.
Jan 8	comment	Was I right with locking? NOLOCK on DELETE's is deprecated; why would you want to delete uncommitted data anyway?
Jan 5	comment	Four db servers all identical, one is much slower than the others Double check the network settings, if they're set to auto they may have negotiated down to 100mb.
Dec 14	comment	Keep transaction log size under control during batch processing I would disable that and run a manual stats job, I wouldn't think it would cause a log run up like you saw though.
Dec 13	comment	Keep transaction log size under control during batch processing @QuickJoeSmith, Are you using auto-update on statistics?
Nov 22	comment	How can I have SQL Server listening on more than one IP address? Stop and start SQL service if you haven't. Check the SQL Logs in management studio from the last startup, it will list the IP addresses it is listening on. Also check netstat -an
Nov 19	comment	Is there any way to turn off the “loading” message when a page refreshes in Reporting Services? In 2008, open the properties window (F4), and click in the whitespace of the design panel, AutoRefresh is under Other
Nov 18	comment	Is there any way to turn off the “loading” message when a page refreshes in Reporting Services? In BIDS, it should be under the top menu Report / Properties / General; at least for 2005, I think they moved it for 2008 but it's in the same general area IIRC. I don't get the "loading" with my instance, even when refreshes take forever.