I don't see any reason to use CLR for this. There is no complex logic occuring in your code, so a standard TSQL FOR INSERT trigger will work best...

bwhite (11/7/2008)

---

I think because he wants to see how it would work. Wheather or not it actually would be used is a different case as I agree there are better...

Get your manager to explain why CLR has to be used for this. TSQL like the following is the fastest method of doing triggers like you describe:

CREATE TABLE dbo.Employee...

You don't need C#...

You also can look at Idera's Admin Toolset

http://www.idera.com/Products/SQLadmintoolset/

or better yet, for free download SQL Server Express 2008 with Tools, and install Management Studio Express.

http://www.microsoft.com/express/sql/download/

Then download the PBM templates...

A free tool from Microsoft that is really easy to get up and going in under an hour is SQLH2. It has reports for SSRS, and builds a repository...

There is a script on this article:

http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/

I use a Operating System (CmdExec) step to call the script. If you save the script as DeleteOldBackups.vbs, then the Command for the...

I would make sure I had it in writing that they understand that the if the database runs out of space with a fixed size, and auto-grow disabled, faster than...

I am sure that there are other various utility ways to do things in CLR beyond what I have provided above. I haven't had much need for it beyond...

I am with Matt on this one. I have databases that range from 50MB up to over 300GB, and all of them have auto grow turned on, though the...

For the most part, leaving the optimizer to control when to use parallelism is the best thing. There are instances where you get waits that are parallelism introduced, and...

Mark, from what I can tell in...

Double post of:

http://www.sqlservercentral.com/Forums/Topic596167-146-1.aspx

One other thing to note is that you need to preseed your table with an amount of data for index tuning against a new table set or database to be...

They are estimations, but generally they are fairly accurate. Under certain scenarios, the actual plan can differ from the estimate. What is better for what you are describing...