Viewing 15 posts - 301 through 315 (of 956 total)
I would recommend that if you can use SSIS for this, that you go that route. SQLCLR can do it, that is for sure, but you may not have...
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]
June 22, 2009 at 7:55 am
Florian Reischl (6/20/2009)
haroonrashed786 (6/20/2009)
but..i have to use CLR triggers only..,Why?
Exactly my thinking... This requirement makes absolutely no sense. It's like saying you have to use a hammer to...
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]
June 20, 2009 at 12:35 pm
noeld (6/18/2009)
Ermm... Isn't this just a description of LogShipping ?
Yep, its basically manual log shipping. I've never used log shipping to accomplish this task because databases in my environment...
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]
June 18, 2009 at 9:17 pm
daeguboog (6/18/2009)
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]
June 18, 2009 at 9:04 pm
Look for missing indexes causing lots of table scans or clustered index scans in the execution plans. That is one of the most common drivers for high CPU. ...
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]
June 15, 2009 at 12:36 pm
You don't need CLR to do this. TSQL is the best way to accomplish this task just using standard DML triggers.
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/a3c372a4-d8f0-47b5-a45b-a7529e6eaa81/
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]
June 15, 2009 at 12:33 pm
No problem.
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]
June 9, 2009 at 8:09 am
Charles Hottle (6/5/2009)
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]
June 5, 2009 at 10:45 am
Here is a documented hack that uses SQL Express 32 bit in a double hopped link:
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html
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]
June 5, 2009 at 8:48 am
You can't do it with x64 and this is a known problem. There is no support for JET in 64 bit by Microsoft. See the following connect items:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125117
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=90562
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=123311
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]
June 5, 2009 at 8:44 am
It isn't uncommon to have sleeping spids sitting on your servers. If you use something like MOSS 2007, it has hundreds of sleeping spids at any given point 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]
June 5, 2009 at 8:40 am
To start with, stop looking at sysprocesses and start using the DMV's to look at your problems.
The first one to look at is sys.dm_os_waiting_tasks which will hold all the waiting...
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]
June 5, 2009 at 8:36 am
BTW, the same type of setup can be used with SQL 2005 for learning.
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]
June 5, 2009 at 8:23 am
I am personally working on learning Clustering with SQL 2008 by building my own cluster using ESXi and 4 virtual machines. I am slowly blogging about it on my...
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]
June 5, 2009 at 8:21 am
A stored procedure only executes when called by your code. What do you mean by registers a socket server and why are you doing this from a SQLCLR stored...
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]
June 5, 2009 at 8:17 am
Viewing 15 posts - 301 through 315 (of 956 total)