Viewing 15 posts - 991 through 1,005 (of 1,838 total)
This scenario looks incomplete. It looks like UPDATE 1 would be blocked by UPDATE 2, but for this to be a deadlock there must be some other DML in session 1...
April 25, 2017 at 12:44 pm
Yes, TFS does store things in SQL Server databases, with names such as:
Tfs_DefaultCollection
Tfs_Warehouse
(plus a bunch to support SSRS and SharePoint)
Do you know what information you're...
April 24, 2017 at 2:41 pm
Yes you need the Users entries. Long story short, for 2008 R2:
- Logins are at the instance level, and can be an active directory user, an active directory group,...
April 21, 2017 at 12:57 pm
April 21, 2017 at 9:58 am
you can verify that the ACE OLEDB 12 drivers are loaded on the server,
in Control Panel / Programs and Features, look for something named "Microsoft Access database engine" or...
April 21, 2017 at 8:42 am
I have an overactive imagination, so I can easily brainstorm ideas, analyze them, and sort out pros and cons alone. I find the most creative ideas I have though usually...
April 21, 2017 at 8:08 am
Looking at the SQLPLAN, I see there are 3 massive sorts to support the GROUP BY operators you have. In the Oracle query, I see there is only 1 GROUP...
April 20, 2017 at 3:07 pm
April 20, 2017 at 2:49 pm
Are you able to post a execution plan as a .SQLPLAN file? You should be able to view and save the execution plan from within Management Studio. Just working from the...
April 20, 2017 at 1:23 pm
you could add an OUTER APPLY to find the prior OPEN record:
SELECT c.ProcessDate, c.ProcessDateShort, c.AccountNumber, c.AccountStatus, l.SumOpenShareBalance
FROM #Temp c
OUTER APPLY (SELECT TOP...
April 20, 2017 at 1:10 pm
it would be easier on a newer version of SQL Server, but for 2008 how about this?
SELECT nArticle_Id, nRev_Id, dStart, dEnd, ROW_NUMBER() OVER (PARTITION BY nArticle_Id ORDER...
April 20, 2017 at 12:21 pm
This would depend on a number of things, if you TRUNCATE the table before loading, this resets the identity value back to its initial value. You could manually reset the...
April 19, 2017 at 1:50 pm
this error looks like it could either be the linked server security isn't configured right, or potentially a double hop issue is occurring where it can't pass the credentials from...
April 19, 2017 at 1:42 pm
April 19, 2017 at 12:03 pm
this would probably work better as an outer apply to a correlated subquery instead of a left outer join since you want multiple columns from the same row, something like:
April 19, 2017 at 11:28 am
Viewing 15 posts - 991 through 1,005 (of 1,838 total)