Viewing 13 posts - 1 through 14 (of 14 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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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.
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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,...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
January 29, 2013 at 4:23 am
sqlnaive (1/25/2013)
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
January 25, 2013 at 6:31 am
Grant Fritchey (1/25/2013)
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
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...
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
January 25, 2013 at 4:57 am
SQL 2000 Standard/Enterprise doesn't work under XP. You need to use SQL 2000 Personal.
___________________________________________________________________
Is better shut up and look stupid than open your mouth and eliminate any doubt
March 15, 2010 at 5:17 am
Viewing 13 posts - 1 through 14 (of 14 total)