516 reputation
25
bio website sqlblog.com/blogs/…
location Tampa, FL
age 34
visits member for 3 years, 8 months
seen May 21 at 15:32
SQL Server DBA

Nov
8
answered sql server NUMA binding to ports
Apr
10
awarded  Yearling
Apr
10
answered SQL Server how to detect unused views and/or get usage stats
Feb
26
answered How to solve index missing problem in one table, while other table of same property does not produce any error?
Dec
21
answered Optimising plans with XML readers
Nov
26
awarded  Nice Answer
Nov
8
awarded  Yearling
Nov
8
answered AUTO_UPDATE_STATISTICS_ASYNC ON?
Sep
26
comment What real-world problems have you solved with Extended Events?
How is it not usable? You get full UI support and all of the events from Trace in 2012 and the amount of content around it has exploded as a result. If you are on 2008/2008R2, there are limitations but you can download the SSMS Addin I wrote from Codeplex and get into Extended Events with little effort. (extendedeventmanager.codeplex.com)
Jan
10
answered sys.syshobtcolumns Help
Jan
10
comment sys.syshobtcolumns Help
Is sharepoint the only thing running on this instance or are there other databases running on it as well?
Dec
10
comment SQL Server 2008 - Log file out of control & cant shrink it
You can find the exact reason for the log not reusing space with SELECT name, log_reuse_wait_desc FROM sys.databases on 2005 or higher. This will give you a value you can lookup from msdn.microsoft.com/en-us/library/ms345414.aspx for how to resolve the problem. One note is that REPLICATION could mean Change Data Capture since it uses the Replication Log reader for data collection.
Nov
15
comment Pros and cons of having one table per entity vs. having a shared table with an extra column indicating the entity type
I don't think it is quite as clear cut as you make it here. I've worked on databases where everything was a separate entity and therefore a separate table and they are a nightmare for performance, require dozens of JOINs and additional UNION operations to get the most basic information out. Without understanding the data and how it is used you can't really make a schema design decision.
Aug
5
awarded  Critic
May
25
awarded  Teacher
May
25
answered Can a username and password be hard-coded in a system DSN
Feb
16
awarded  Autobiographer
Feb
16
awarded  Supporter