Viewing 15 posts - 9,706 through 9,720 (of 59,078 total)
One more thing to add... IF you're using SET IDENTITY_INSERT tablename ON, then THAT's the problem with performance. It's a well know fact (and there is a posted plea with...
March 7, 2019 at 7:48 am
Without seeing the code you're using, we'd only be guessing.
March 7, 2019 at 7:44 am
First, let's clear up the notion about reducing logging... the only way that you can reduce logging during INSERT/SELECT is if a bunch of things happen...
1. The database...
March 7, 2019 at 7:42 am
March 7, 2019 at 7:18 am
I guess my question would be, why aren't you using T-SQL to do this?
March 7, 2019 at 7:05 am
March 7, 2019 at 7:02 am
March 7, 2019 at 6:53 am
March 7, 2019 at 6:39 am
March 6, 2019 at 3:00 pm
March 6, 2019 at 2:09 pm
This is Part 2 of Slow in the Application, Fast in SSMS. How...
March 6, 2019 at 9:42 am
March 5, 2019 at 12:56 pm
March 5, 2019 at 12:19 pm
The following formula will do it for you.
(DATEPART(dy,DATEADD(dd,-53684,DATEDIFF(dd,-53684,@SomeDate)/7*7+6))-1)/7+1
1. It finds the first Sunday on or previous to the given date (-53684 is...
March 4, 2019 at 10:37 am
Viewing 15 posts - 9,706 through 9,720 (of 59,078 total)