Tuesday, 29 July 2008

This statement uses Dynamic Management Views to get the row count of a table. It can be considerably faster when we want to get the row count of a very large table, since the conventional way "select count(*) from table" would require a full table scan.

Friday, 25 July 2008

This command can be used to dynamically create the path for a file based on the current instance. It assumes each instance server has a directory called BulkInsert which we use to store the csv files we want to import.

Tuesday, 22 July 2008

This is a list of ignore items I find useful. It includes the Ankh and Resharper addons. Note that it also includes the .dll files, which sometimes might be needed, for example if we don't have the source code or for some other reason we don't want to build the dll. In this case if the ignore is applied recursively, we need to manually allow the dll in the directory of interest.

Thursday, 3 July 2008

--Allows only db owners to connect. This step must be run because if you leave it in single user mode then the Redgate GUI cannot connect.
--If you are copying and pasting the Redgate script into the same window as the above script then you do not need to run this step.