Reputation
1,855
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 11
Newest
 Yearling
Impact
~207k people reached

Apr
22
comment Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
If it really is used only for read-only reference, I wouldn't convert it; virtualize the hardware if you haven't already; there's always the chance the conversion will introduce errors in an app that's been trusted for many years.
Feb
4
comment SSIS OLEDB Command not firing triggers
run profiler when the ssis package is running; check for errors; might be triggers are failing with permissions or some other error.
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.
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.