network profile
| bio | website | sqlblog.com/blogs/… |
|---|---|---|
| location | Tampa, FL | |
| age | 32 | |
| visits | member for | 2 years, 3 months |
| seen | May 3 at 3:52 | |
| stats | profile views | 58 |
SQL Server DBA
|
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. |
|
Nov 8 |
comment |
Transaction Log 16GB on 2MB database If you know that it is bad to do this, why even post it and continue to promote bad practices on the internet? Downvoted... |
|
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 |
