Viewing 15 posts - 556 through 570 (of 1,048 total)
opc.three (5/12/2011)
sturner (5/12/2011)
opc.three (5/12/2011)
This can be solved by running the batch in either the SNAPSHOT or SERIALIZABLE isolation level.
Yes, that is a hack way of masking the underlying issue, but...
May 12, 2011 at 11:42 am
opc.three (5/12/2011)
May 12, 2011 at 11:22 am
Well here are two concrete reasons why not to do it the way they are doing it:
1) Performance: there is a overhead associated with each batch, from the network latency...
May 12, 2011 at 8:42 am
Your assumption is correct. The XACT_STATE() can be 1 or -1.
You need to test for XACT_STATE != 0
May 12, 2011 at 8:28 am
I agree with you, it is an ugly and not scalable way to interact with a database server. They should pull all of the rows they need relating to a...
May 12, 2011 at 8:07 am
If the process occurs every day on the same file, same format I'd agree there was a valid argument for doing it in a dedicated process and that the time...
May 11, 2011 at 6:26 am
Lordy.... I can't imagine taking the trouble to write a dedicated C++ program just to do all of those specific aggregations on a raw CSV file.
Don't get me wrong, I...
May 10, 2011 at 2:16 pm
It could be a number of things, but find out if you are trying to connect to a developer version of SQL server as the number of connections it allows...
May 5, 2011 at 8:39 am
Slick. Certainly solves the deleting old files problem in a very efficient manner.
The command shell is actually pretty powerful but I've always had a hard time finding a document anywhere...
May 4, 2011 at 2:37 pm
see if you can find the process associated with that AppDomain (look in the SQL Server error log and run sp_who2) then try to kill the process if it is...
May 3, 2011 at 1:50 pm
I wrote a .net utility that runs as a windows schedule task. You tell it what to doe via a config file which specifies the top level folders (wildcards and...
May 2, 2011 at 9:15 am
It really depends on the applications at the client and how they are used. In some cases a DSN can be superior to a connection string. OTOH, DSNs are...
May 2, 2011 at 9:00 am
Your idea about another column in the table is a good one, and the most flexible. If more selections are added and/or deleted in the future you only need to...
May 2, 2011 at 8:56 am
LutzM (4/27/2011)
Why using a CLR in the first place?Wouldn't something along those lines do the job, too?
Excellent point. It appears that this custom "aggregation" depends upon a certain ordering of...
April 27, 2011 at 2:57 pm
Viewing 15 posts - 556 through 570 (of 1,048 total)