Viewing 15 posts - 796 through 810 (of 956 total)
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 10, 2008 at 4:21 pm
bwhite (11/7/2008)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 7, 2008 at 12:20 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 7, 2008 at 12:01 pm
bwhite (11/7/2008)
I need to create a trigger where C# code is within the trigger then run a simple query to dump the rows in the database.
You don't need C#...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 7, 2008 at 9:43 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 5, 2008 at 4:41 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 5, 2008 at 4:32 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 5, 2008 at 4:22 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 5, 2008 at 4:17 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 10:10 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 7:33 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 7:13 pm
mark.hall (11/3/2008)
Thanks, JonathanHere's the data I'm getting back.
What I'm wondering is what does it mean when theres a "(0)" in the index name column.
Mark, from what I can tell in...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 6:59 pm
Double post of:
http://www.sqlservercentral.com/Forums/Topic596167-146-1.aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 5:31 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 5:30 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 3, 2008 at 5:12 pm
Viewing 15 posts - 796 through 810 (of 956 total)