Comments
Sort by recent activity
I think this could be made more explicit in the UI.
I just had the same issue, in that I checked 'Ignore constraint and index names' but was still seeing differences which turned out to be system-named constraints. Until I found this thread.
So 'Ignore constraint and index names' should include system-ones by default, maybe even move the 'Ignore System Named Constraint and Index Names' underneath (tabbed in, even) so that it's obviously clear that there are options here. / comments
I think this could be made more explicit in the UI.
I just had the same issue, in that I checked 'Ignore constraint and index names' but was still seeing differences which turned out to be system-n...
Done!
Link here for anyone else reading this post who wants to vote: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/19043938-include-any-referenced-object-in-summarize-script / comments
Done!
Link here for anyone else reading this post who wants to vote: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/19043938-include-any-referenced-object-in-summarize-script
Adam,
I think it was just confusingly named, as these aren't what we would consider to be long-running queries, just those that cumulatively have taken a long time.
On an aggregated level, I often don't care if a query that takes 1s has been run 10,000 times, racking up nearly 3 hours of duration, especially if it only takes 1ms of CPU.
I guess if you showed individual long running queries for the selected period you could end up with the same top 5. Maybe determine the top 5 different queries that have been individually long-running, then show the cumulative, min and max durations? Did I explain that correctly???
/ comments
Adam,
I think it was just confusingly named, as these aren't what we would consider to be long-running queries, just those that cumulatively have taken a long time.
On an aggregated level, I ofte...
Adam,
I'm confused now. I have an alert that is configured to not send emails, but it did raise a Slack alert.
I think being able to control the alerting methods on each alert is going to clear this up.
Thanks,
Kev / comments
Adam,
I'm confused now. I have an alert that is configured to not send emails, but it did raise a Slack alert.
I think being able to control the alerting methods on each alert is going to clear th...
I've noticed that SQL Compare does now detect disabled indexes, however nothing highlighted is shown in the comparison window - the disabled index is still scripted as 'create index'. Only when you go through to deploy, and you see the deployment script that it shows a disabled index.
I'm running SQL Compare 12.3.3.4490 / comments
I've noticed that SQL Compare does now detect disabled indexes, however nothing highlighted is shown in the comparison window - the disabled index is still scripted as 'create index'. Only when yo...
Yes. I am sysadmin on the server. And can view the objects in SSMS no problem / comments
Yes. I am sysadmin on the server. And can view the objects in SSMS no problem
Aaron - thanks for that.
Will do, and have done : https://redgate.uservoice.com/forums/94 ... ms-version / comments
Aaron - thanks for that.
Will do, and have done : https://redgate.uservoice.com/forums/94 ... ms-version
Are you using the right case? http://documentation.red-gate.com/displ ... Roperators
To treat the words AND and OR as boolean operators, they must be uppercase / comments
Are you using the right case?http://documentation.red-gate.com/displ ... Roperators
To treat the words AND and OR as boolean operators, they must be uppercase
Here's an example using AdventureWorks2008 or AdventureWorks2008R2 or AdventureWorks2012.
Search for the text 'proc'. Click on the result 'uspGetBillOfMaterials'
Display pane scrolls down the proc, away from the highlighted obvious 'proc' in the first line. / comments
Here's an example using AdventureWorks2008 or AdventureWorks2008R2 or AdventureWorks2012.
Search for the text 'proc'. Click on the result 'uspGetBillOfMaterials'
Display pane scrolls down the proc...
I've noticed it on fairly long stored procedures. Let me see if I can get an example. / comments
I've noticed it on fairly long stored procedures. Let me see if I can get an example.