Viewing 15 posts - 2,986 through 3,000 (of 49,571 total)
As in moving to another country and working there? Or staying at home and working for companies/clients overseas?
If the former, then the first thing you need to consider is how...
June 6, 2016 at 6:16 am
alex.sqldba (6/6/2016)
So the locking DOES start from the beginning of the search? Or only after it has located the rows?
A session must have a lock to access a row. So...
June 6, 2016 at 6:15 am
Nothing particularly strange there. If a sleeping connection still has a transaction open, it will still hold locks. You can get an idea where the problem is by querying sys.dm_exec_connections...
June 6, 2016 at 12:52 am
Instead of guessing, maybe add some logging and diagnostics to the script?
June 6, 2016 at 12:33 am
Brandie Tarvin (6/3/2016)
June 3, 2016 at 5:23 am
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option to install with the rest...
June 3, 2016 at 4:46 am
ChrisM@Work (6/3/2016)
GilaMonster (6/2/2016)
Grant Fritchey (6/2/2016)
jasona.work (6/2/2016)
I read this and suddenly felt millions of DBAs cry out in horror...(Yes, it's the Daily WTF, scarily it might even be (mostly) true)
Great story....
June 3, 2016 at 4:43 am
Look through your logs and history, if the job failed there should be a reason somewhere in some log.
June 3, 2016 at 12:28 am
Grant Fritchey (6/2/2016)
Wow!And the explanation... "SQL Server sucks!"
Oracle, not SQL Server in this case, but kinda yes.
June 3, 2016 at 12:20 am
Grant Fritchey (6/2/2016)
jasona.work (6/2/2016)
I read this and suddenly felt millions of DBAs cry out in horror...(Yes, it's the Daily WTF, scarily it might even be (mostly) true)
Great story. A true...
June 2, 2016 at 4:26 pm
chandan_jha18 (6/2/2016)since there are matching rows, it will update all the rows in 'eligibility' table but the OP needs the column updated on rows which are matching.
Will it really?
UPDATE eligibility
SET...
June 2, 2016 at 9:10 am
jasona.work (6/2/2016)
Happy National Leave the Office Early Day!!![/url]So, who's going to celebrate this day today?
😀
I wish, but I've got a social club meeting from 5pm til 6.
I think I'll celebrate...
June 2, 2016 at 5:42 am
You still have a severe SQL Injection vulnerability that you need to fix before your company becomes the next 'data breech' headline.
June 2, 2016 at 4:04 am
coolchaitu (6/1/2016)
So, can we conclude that it stopped when it ran for the first time due to log backup job running at same time?
What evidence are you using to jump...
June 2, 2016 at 3:04 am
7 year old thread.
Please create a new thread for a new question.
June 2, 2016 at 3:01 am
Viewing 15 posts - 2,986 through 3,000 (of 49,571 total)