Posts
Sort by recent activity
Azure SQL Monitoring - suppress DTU/IO warnings during index/stats maintenance?
We have a couple of Azure Runbooks that fire a couple of times during the day. These are to update the stats and maintain indexes. We run the stats updates during the day and index maintenance at n...
Possible to install web piece in Azure WebApp?
Seems like this should be possible, but can't find any details about this in the docs or forums. Ideally, we'd like to spin up a web app to host the Web View for SQL Monitor. That would allow us to...
Possible to monitor excessive timeouts?
We have a couple of apps that irregularly, but often enough to be problematic, start suffering from timeouts. Is there an easy way to get alerted for those cases when queries start timing out?
INSERT - SELECT formatting issues w/ SQL Prompt 6.x
I'm trying to format my INSERT / SELECT code and when I use CTRL+K+Y, my SELECT statement gets indented under the INSERT like so:INSERT dbo.MyTable
( MyTableName
, Description
)
SEL...
Issue with declaring @pv for BLOB data in 10.4.8.62
I generated scripts for our databases that disable triggers and constraints before modifying data in the database. I noticed that for several of these scripts, there is a DECLARE @pv command at the...
BUG: EAP 3 w/ MERGE statements
I can't edit a stored proc that uses MERGE when using EAP3 against a SQL 2008 database using the SQL 2008R2 SSMS. I have to disconnect my query window in order to use SSMS without throwing a SQL P...
Feature Request: Use actual column order
I often put a lot of columns towards the "end" of my tables because they're infrequently used or contain audit-type data. However, a lot of times, these are alphabetically first.
I know that at one...
Bug: Cross-database queries change "current" DB
Looks like when we do cross-database queries, SQL Prompt 5 loses some of the information or switches its DB context. When trying something like:
select *
from dbo.TableA as a
JOIN NotCurrentDB.dbo...
[Bug?] Select * from Store as s <return>
Not sure how to categorize this. I don't think this is an option that I've missed, but this didn't happen in 3.x. When I type something like:
SELECT * FROM St -- and then autocomplete so it beco...
INSERT MyTable (Col1, {Exception}
This seems to happen pretty regularly. I start manually populating columns for an INSERT Statement because I don't want to insert data for all columns. I start getting a drop-down of available colu...