Viewing 15 posts - 2,986 through 3,000 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2016 at 12:52 am
Instead of guessing, maybe add some logging and diagnostics to the script?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 6, 2016 at 12:33 am
Brandie Tarvin (6/3/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2016 at 3:04 am
7 year old thread.
Please create a new thread for a new question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2016 at 3:01 am
Viewing 15 posts - 2,986 through 3,000 (of 49,552 total)