Posts
Sort by recent activity
Performance problems
I have three formatters in my ADS: mssql (default), poor man's sql formatter and redgate sql prompt. The first two format a simple query sub-second -- too fast to time. OTOH SQL Prompt ...
how to show "not shown" dependencies?
I started dependency tracker by right-clicking on a stored proc. The tracker opened but only showed the proc I selected. Hovering over the display, though I see the message "Dependencies not show...
SQL Doc repeats itself with partitioned tables and indexes
I'd like to see:PAGE ON ALL PARTITIONSInstead of:PAGE ON PARTITIONS (1), PAGE ON PARTITIONS (2), PAGE ON PARTITIONS (3), PAGE ON PARTITIONS (4), PAGE ON PARTITIONS (5), PAGE ON PARTITIONS (6), PAGE...
SQL Compare: How to filter out changes to views/functions/procs based on content
One environment I support has separate databases for staging and etl'd data. e.g. data is loaded into MyStaging from various sources, cleaned up then finally loaded in to MyGoodData for downstream...
SQL Search -- please add Last modified Date/time column
When looking at the search results on many dev databases on the same instance, I find I want to know the date/time each object was last modified (and be able to sort on that). So my request: Pleas...
Source control tSQLt procs and tables but keep them from being deployed to higher environments
We're starting to use tSQLt for unit testing. Next, we want to source control those tests. The big question is, when we want to deploy changes to higher-than-dev environments, how can we simply k...
Inline EXEC cannot find just-created stored procedure
I create a new proc:CREATE proc dbo.func
(
@a bit,
@nota bit out
)
AS
BEGIN
SET @nota = @a ^ 1
RETURN
END
GO
Then call it:DECLARE @a BIT, @nota bit
EXEC dbo.func @a, @nota OUT
SELECT @nota
...
Add new servers
When I launch SQL Data Compare, I cannot see all the servers I want to compare. How do I add a new server to the list presented?