The most recent content from our members.
I can use SQL Profiler and view SQL Text with parameters. When we have an issue a lot of times it is not the query but rather the data inside the query is corrupt or too large. Without seeing the stored procedure parameters we cannot track down which record to look at. When you have no privacy concerns like medical,…
I wanted to know if it would be possible for DPA to have SQL text comparisons similar to how NCM has configuration comparisons when a configuration is changed within the network. NCM highlights the changes that were made, it would be nice and a cool feature to have if DBs could see the changes that were made within their…
When displaying the SQL text for a hash, it displays the statement, followed by the entire stored procedure text (if the statement is part of a procedure. However I'm having a problem with the display of SQL text that is not part of a procedure. We have written custom code for Entity Framework that injects a comment…
I love the deadlock enhancements added in 10.2. However, there are two specific areas of improvement that I'd like to see addressed. 1) If the SQL involved in a deadlock is truncated, display the VARBINARY form of the sql_handle (which can be parsed from the sqlhandle element of the deadlock XML) in a comment in the SQL…
Anywhere that SQL statements are displayed, if the statement is truncated for any reason, display the VARBINARY form of the sql_handle in a comment so that I can then attempt to get the full SQL Statement by pasting it into a query like: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @Handle VARBINARY(64) =…
It looks like you're new here. Sign in or register to get started.