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

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


17h
reviewed Reject suggested edit on Improve performance on concurrent UPDATEs for a timestamp column in Postgres
17h
reviewed Reject suggested edit on Errors writing MySQL Queries
19h
reviewed Reject suggested edit on Postgres vs Mongodb, Suggestions to improve mongodb performance
19h
reviewed Approve suggested edit on Is this a good case for multiple SQL instances on a VM?
21h
reviewed Reject suggested edit on View with left joins are very slow
1d
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.
1d
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?
1d
comment Estimate projected database growth
I also like combining it with @BrentOzar [backup scripts from here])brentozar.com/archive/2012/03/…).
1d
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.
1d
answered Performance impact of Extended Events filter [like_i_sql_unicode_string]
2d
comment SQL Server slows down on one expensive query
Execution plan? View waiting tasks while the query is running?
2d
reviewed Approve suggested edit on Incorporating Partition Views into a Data Warehouse
2d
answered SQL Server: deadlocked on lock communication buffer resources
2d
comment SQL Server AlwaysOn log_send_rate
Did you mean sys.dm_hadr_database_replica_stats, because the DMV you noted does not contain a log_send_rate column. As well the DMV that reports this shows KBs/sec. It is noted in this TechNet troubleshooting article to compare that value with Performance counter Log Bytes Flushed/sec, is this the one you are referring to?
2d
comment How to figure out Disk I/O by table
As pointed out this is not directly accessible information but the "Top I/O Consumers" query from Michael Swart Resource Hog Queries can help pinpoint those objects in the plan cache: michaeljswart.com/2013/09/my-queries-for-top-20-resource-hogs
2d
comment SPARSE Column in SQL Server
stackoverflow.com/questions/1398453/…
Jul
21
comment I am not sure why I am getting the “Invalid column name”, same code works on my other calculators…
"Calculators"??
Jul
21
reviewed Reject suggested edit on I am not sure why I am getting the “Invalid column name”, same code works on my other calculators…
Jul
21
answered Collecting Wait Stats
Jul
21
comment Collecting Wait Stats
I don't think this is completely accurate "Preemptive wait types occur when SQL server is executing a task and is interrupted by OS". SQL Server is making the call to the operating system which causes it to switch from non to preemptive mode.