Posts
Sort by recent activity
Deselecting single alerts after selecting all across pages
I'm trying to clear all but the latest alerts, and I'm not sure if the behaviour is as I would expect.
For example if I have 367 Deadlock alerts, I can change the Alert filtering to show just these...
Alias names for both Windows host and SQL Server
When aliasing a server on the Global Dashboard, the alias seems to be used everywhere the SQL Server is referred to, but not the Windows host.
Can you only alias SQL servers?
Reports - summary tiles
Can you give more detail as to how the data is captured for the pre-canned summary tiles.
For example Longest running queries, for past 12 hours, is showing me a query that it says has a duration ...
Alert notifications
Does the Email Notifications section of an alert configuration control all the notifications for an alert?
For example if Don't send email notifications for this alert is set, does that also preve...
UI annoyance - button colour
Not really a bug, more a UI annoyance. Or maybe it's a bizarre setting I have......
SQL Search 2.3.0.308 on SSMS 12.0.2000.8
When you mouse over the Index and Help buttons, the background colour ch...
SQL Source Control 4 affecting VS TFS
This might sound a little vague, but I've noticed a difference between 2 systems, and one of the key factors is that SQL Source Control is installed on one and not the other.
Are there any known is...
No results for system databases
Trying to use SQL Search against system databases is not giving me the right results. Now I'm wondering is this by design?
Search term : backup
All object types
database : msdb
Only returns jobs an...
Exact match confusion with object names and square brackets
Against a copy of AdventureWorks2008R2, search for
[EMP_cte].OrganizationNode
with 'Exact match' unticked : this returns 2 results uspGetEmployeeManagers and uspGetManagerEmployees, and highlights ...
Restoring tabs based on SSMS version
I had 2 instances of SSMS open, one was 2008R2 the other 2012.
Each had 4 different tabs open.
I closed both of the SSMS down, and then restarted, 2008R2 first then 2012.
All 8 tabs reopened in the...
Refresh suggestions is limited to current connection
SQL prompt does support cross database queries, but if you refresh suggestions, it doesn't refresh the suggestions of the remote database, just the one you are currently connected to.
So for exampl...