Viewing 13 posts - 1 through 13 (of 13 total)
Thank you Phil for the idea, it looks very promising at the first glance. It is so nice and simple to implement that I'm really pissed off now that I...
February 23, 2021 at 12:25 pm
Unfortunately no. The trigger is the webservice call received from the external application. We can't control when they make the calls.
February 23, 2021 at 10:51 am
Hello Phil,
The problem is "b) Multiple files are processed at the same time (because multiple instances of the same stored proc are running)". Because of this the verification for duplicated...
February 23, 2021 at 10:27 am
It is annoying because you can't see in SQL Server Logs the relevant messages because of the garbage generated by these repetitive logging.
Maybe is the same case as yours... I...
August 23, 2016 at 1:41 am
OK, with the help of a friend of mine, which is an excellent DBA (and maybe a member here, but I don't know his username 🙂 ), the problem was...
August 12, 2015 at 12:42 am
Hello,
I struggled a lot, but I'm really stuck here.
Context:
1. SQL2008 R2 Enterprise Edition 64 bit SP1
2. Recovery model: Simple
3. Log file reached 2 TB, I needed to add another one...
August 11, 2015 at 12:57 pm
Bhuvnesh (1/30/2013) Does it mean that you added an intermediate step where u pulled out the larger table data into temp table then used it in further steps...
January 30, 2013 at 1:39 am
Finally, I got to a solution. Is not a nice solution (old fashion style) but it works. I have clear criteria for selecting the data from the three major tables,...
January 29, 2013 at 5:08 am
Hello again,
I tried updating the statistics using sp_updatestats. Well, now is it worst because executing the stored procedure code is also slow in execution now. Is good that it behave...
January 29, 2013 at 4:23 am
sqlnaive (1/25/2013)
January 25, 2013 at 6:31 am
Grant Fritchey (1/25/2013)
January 25, 2013 at 6:03 am
sqlnaive (1/25/2013)
What exactly are you checking from query analyzer ? Running the procedure with parameters or the code inside the procedure ?
I tried both. Running the procedure with parameters (exec...
January 25, 2013 at 4:57 am
SQL 2000 Standard/Enterprise doesn't work under XP. You need to use SQL 2000 Personal.
March 15, 2010 at 5:17 am
Viewing 13 posts - 1 through 13 (of 13 total)