1,757 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 11 months
seen Sep 2 at 1:11

Jun
5
comment TRANSACTION ISOLATION LEVEL SNAPSHOT vs. TRUNCATE?
Can you use DELETE FROM foo instead? That won't place the schema lock.
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