Posts
Sort by recent activity
SQL source control crashing SSMS
First I get a windows error
Problem signature:
Problem Event Name: APPCRASH
Application Name: RedGate.AppHost.Client.exe
Application Version: 0.0.1.130
Application Timestamp: 583f0748
Fault Module ...
Include some identical objects in deployment script
Is there an option to include identical objects in the selected objects for deployment?
I know you can include them in the "change report" html but i can't select them in object selected for deplo...
Multi database support - commit changes from a list of DBs
We have multible databases under source control.(some main-db's and some more modular/auxiliary "side"-databases). They're on the same server.
Each has their own repository. They're not part of one...
Suggested Indexes on RG_AllObjects_V4
Database Engine Tuning Advisor ( :twisted: ) keeps advising me to add indices on some tables in tempdb related to SQL Source Control.
Why is tempdb used for this table and not a dedicated redgate d...
Now we can import/export styles care to share yours?
I sometimes wish to switch styles depending on the length/complexity of the code i'm viewing.
e.g. im doing some analysing of data with a whole bunch of other queries in the same window
SELECT fiel...
Excessive waits showing up in Performance Dashboard
If i open performance dashboard (http://www.microsoft.com/en-us/download ... x?id=29063 ), SQL Monitor is allways showing up in the section "Current Waiting Requests" under category User Waits.
If ...
Smart Rename Columns and IF UPDATE(Column_name)
If you rename a column via smart rename the script does not update the column name in some triggers when it is used in the form of
IF UPDATE(column_name)
Force column order - Identity_Insert when no PK defined
When i put option Force Column Order on I frequently get errors like
Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'tmp_rg_xx_sec_dossierbeheerder_dep...
Computed column UDF - Drop Alt Recr instead of Alter
When a table has a computed column that references a UDF and the definition of the UDF changes the computed column should be dropped and re-added
so->
*select computed columns that reference the UD...
Refactor/Layout/Convert right outer joins to left
I've recently put a DDL trigger on some of my databases to forbid RIGHT OUTER JOINS on function/view/proc creation/change
Why?
Because it means some of my co-developers used a graphical tool again ...