Viewing 15 posts - 436 through 450 (of 965 total)
darren.ramsay (3/3/2009)
One thing I am very interested in is being able to produce a vs.net report in a pdf file and sending an email from sql...
March 13, 2009 at 8:11 pm
noeld (3/4/2009)
-- Cranfield (3/3/2009)
How does the performance compare to native BCP OUT? should it be the same.cheers
BCP should OUTPERFORM this by far.
The problem is that it is NOT...
March 13, 2009 at 8:09 pm
noeld (3/4/2009)
tomas.skopec (3/4/2009)
Thanks for great article.I would like to ask why are you putting source files into SQL assembly? I tought that compliled dll would be enought.
Thanks in advance,
Tomas
For Debugging!!
It...
March 13, 2009 at 8:06 pm
Is this a SQLCLR stored procedure, or an external application to SQL Server?
February 27, 2009 at 10:44 am
What are you doing in CLR and why aren't you using the context connection? Looking at your connectionstring, your password is missing. We need to know more about...
February 26, 2009 at 6:40 pm
I emailed Adam with your questions and the link to this post. If he reply's to me directly, I will post his response here for you.
February 26, 2009 at 11:16 am
You aren't going to get the exact amounts shown by TaskManager because memory allocations inside of SQL Server fluid, but the working set size shouldn't fluctuate. SQL will free...
February 24, 2009 at 7:05 am
To check which version of VS you have installed click Help-->About. You can then click Copy Info and post your version information here. If you have:
Microsoft Visual Studio...
February 24, 2009 at 6:49 am
You are going to have to be a good bit more detailed in your requirements/expectations, but essentially, you don't get any special abilities by using SQLCLR when it comes to...
February 24, 2009 at 6:46 am
rama.mathanmohan (2/23/2009)
you can use SQL Agent with WMI alert to capture and log deadlocks it works beautifully in SQL2005 and hope should work in SQL2008 see http://msdn.microsoft.com/en-us/library/ms186385.aspx for more details.
Rama...
February 23, 2009 at 4:27 pm
Jonathan Kehayias (2/23/2009)
You can however, alter the system_health session and add a asyncronous_file_target to it which will log the information to a file on disk which will survive service restarts.
As...
February 23, 2009 at 10:07 am
Great question. Unfortunately, the answer is no. Since the ring_buffer target is memory resident, it does not persist the information after restart. You can however, alter the...
February 23, 2009 at 5:18 am
Read my response again. Profiler isn't going to give you a graph from SQL Server 2000. That is only applicable to SQL Server 2005/2008.
February 20, 2009 at 11:23 am
You must be connecting to a SQL 2000 server which doesn't have that event. In SQL Server 2000, you have to enable Trace Flag 1204 to get the deadlock...
February 20, 2009 at 11:11 am
Test your SSIS data loads before doing this because there is no Jet support for x64 SQL Server, so if you have to do any Jet loading, you are going...
February 20, 2009 at 9:36 am
Viewing 15 posts - 436 through 450 (of 965 total)