Viewing 15 posts - 421 through 435 (of 956 total)
CORRECTION:
In trying to simplify the code down, I left out some stuff, but you should have been able to work it out, but for completeness sake, here is the correct...
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]
May 5, 2009 at 1:58 pm
mrlucmorin (5/5/2009)
I must say I'm a bit surprised to see someone posting on a CLR Intergration forum and trying to discourage people from using it :w00t:
You obviously haven't met Jeff...
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]
May 5, 2009 at 12:01 pm
What is your trigger doing that makes it require CLR over standard TSQL? Triggers in TSQL can be problemattic enough for performance and troubleshooting problems, and often are not...
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]
May 5, 2009 at 9:09 am
The best reference for answering your question is the BOL topics for each of them:
OPENROWSET
http://msdn.microsoft.com/en-us/library/ms190312.aspx
OPENDATASOURCE
http://msdn.microsoft.com/en-us/library/ms179856.aspx
From personal experience OPENROWSET can do what OPENDATASOURCE can, but it can also read text files...
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]
May 1, 2009 at 7:39 am
Here is a VbScript I have used a number of times with great success:
How to Get the Scripts for SQL Server Objects - SQLServerCentral
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]
May 1, 2009 at 7:31 am
Your first step would be to query the DMV mentioned above, and see what is in the cache. Another thing would be to look at what activity might 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]
May 1, 2009 at 6:41 am
Generally speaking you would have a VPN connection that allows you to securely connect to the remote network which would then allow you to access the server using a remote...
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]
May 1, 2009 at 6:36 am
This is letting you know that the C drive which is where your Windows Page file is located is running high utilization that is not associated with the Page file...
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]
April 30, 2009 at 9:45 pm
That can be one sign of memory pressure, but it could also be a sign of a ad-hoc workload where parametrization is not being used in the queries submitted 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]
April 30, 2009 at 8:36 pm
jmuldoon (4/15/2009)
Admittedly, the encryption in Sql2000 was very easy to break for most programmer types, but I believe that I've read that MS made this encryption much better in 2005...
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]
April 18, 2009 at 10:27 pm
Your biggest problem is that you have misused SQLCLR here. This is a standard TSQL stored procedure operation since you are doing a simple update using TSQL anyway. ...
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]
April 14, 2009 at 5:05 pm
latina.washington (3/3/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]
March 13, 2009 at 8:34 pm
Steve Jones - Editor (3/6/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]
March 13, 2009 at 8:29 pm
UMG Developer (3/3/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]
March 13, 2009 at 8:20 pm
jmanly (3/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]
March 13, 2009 at 8:18 pm
Viewing 15 posts - 421 through 435 (of 956 total)