How can we help you today? How can we help you today?
gbritton

Activity overview

Latest activity by gbritton

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 ...
2 followers 2 comments 0 votes
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...
1 follower 1 comment 0 votes
Yeah, so refreshing suggestions didn't help.  I notice these lines in the log after the attempt to qualify object names 13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go 13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll 13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll 13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 / comments
Yeah, so refreshing suggestions didn't help.  I notice these lines in the log after the attempt to qualify object names13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution....
0 votes
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...
0 followers 0 comments 0 votes
@kalo have you used this to synonym system views?  does that work? Even so, it doesn't solve my problem, which is to exclude search results where the only difference is some text that I don't care about. / comments
@kalo have you used this to synonym system views?  does that work? Even so, it doesn't solve my problem, which is to exclude search results where the only difference is some text that I don't care ...
0 votes
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...
3 followers 9 comments 0 votes
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...
0 followers 0 comments 0 votes