5,962 reputation
1136
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 6 months
seen 23 mins ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


23h
comment SQL Blocking, SPID of -2
NO ENLISTED SESSIONS, or a transaction that is no longer tied to a session (orphaned)...just terminology to me. It is just as easy to explain it as being orphaned.
23h
comment SQL Blocking, SPID of -2
I am not sure why the individual just deleted the answer but according to Paul Randal's post: SPID -2 is an orphaned DTC transaction
1d
reviewed Approve suggested edit on Relationships between subtypes of an entity
1d
reviewed Reject suggested edit on importing MySQL dump to SQL Server 2012
1d
reviewed Reject suggested edit on What is the cost to create Materialized View log
Jul
27
reviewed Approve suggested edit on RaiseError on SQL Server stored procedures
Jul
27
comment Get complete value of varchar(max) field - SQL Server 2005
That is a tidbit of information that would have helped solve your problem much sooner...
Jul
25
reviewed Reject suggested edit on Improve performance on concurrent UPDATEs for a timestamp column in Postgres
Jul
25
reviewed Reject suggested edit on Errors writing MySQL Queries
Jul
25
reviewed Reject suggested edit on Postgres vs Mongodb, Suggestions to improve mongodb performance
Jul
25
reviewed Approve suggested edit on Is this a good case for multiple SQL instances on a VM?
Jul
25
reviewed Reject suggested edit on View with left joins are very slow
Jul
25
comment Get complete value of varchar(max) field - SQL Server 2005
Then if that does not return any values there aren't any there. Unless you do not have permission to that column, possibly.
Jul
25
comment Get complete value of varchar(max) field - SQL Server 2005
How are you trying to view the value now to know it is not displaying any value now?
Jul
24
comment Estimate projected database growth
I also like combining it with @BrentOzar [backup scripts from here])brentozar.com/archive/2012/03/…).
Jul
24
comment Estimate projected database growth
I use this one constantly, then modify it to go by year if happen to have that much history on a client server. Love looking at this kind of data for a server.
Jul
24
answered Performance impact of Extended Events filter [like_i_sql_unicode_string]
Jul
23
comment SQL Server slows down on one expensive query
Execution plan? View waiting tasks while the query is running?
Jul
23
reviewed Approve suggested edit on Incorporating Partition Views into a Data Warehouse
Jul
23
answered SQL Server: deadlocked on lock communication buffer resources