Viewing 15 posts - 6,016 through 6,030 (of 59,072 total)
Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 28, 2020 at 7:41 pm
This is the main test q I use to test query-writing skill. It's not as trivial / obvious as it sounds at first.
A table contains 1, 2 or 3...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 28, 2020 at 4:12 pm
Acceptable data?
I would have to say "No"... not acceptable. The table that you've defined is different than the table that Scott very explicitly described not once but twice in...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 28, 2020 at 4:09 pm
I guess my question would be is... where would a 14 year old hear of such things in such a repeatable fashion that he'd be able to repeat them as...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 28, 2020 at 3:49 pm
--DECLARE @CurrentDate as date='2020-11-25'
DECLARE @CurrentDate as date='2020-12-10'
;WITH Data (Id, WeekName, WeekDate) AS (
SELECT 5, 'Gameweek 1', CONVERT(date,'2020-12-01')
UNION
...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2020 at 2:57 am
Regarding the accidental DBA, has no one seriously running into the anti-virus scanning issue? The more he posts, the more I'm convinced one of his servers is scanning the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2020 at 2:32 am
Thank you for pointing this out to anyone! Optimizing queries and keep your statistics up to date is far more efficient for the performance. The impact of fragmentation is...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2020 at 2:16 am
Earlier in the thread he stated the database was taking 2 hours.
Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2020 at 1:55 am
Somebody didn't read the article I directed them to. No problem. I'll just post the code in the same manner that the example data was posted to ensure they're equally...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 26, 2020 at 1:43 am
You guys must be suffering from Covid or something. You guys know better than to banter about with claims of performance without demonstrative code to prove your position. Especially since...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2020 at 10:46 pm
Yes , backups are compressed. Before deleting data it was taking around 5 hours ( this is for the all the DBs in the instance), now it is...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2020 at 10:39 pm
I have table with :

if today is 25/11/2020, then i need to retrive ID 5 because nearst date to today WeekDate is: 1/12/2020
then when today date...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2020 at 8:42 pm
It's not often that I say this out loud but now seems like a good time. Thank you Steve Jones for being one of the people that started this site...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2020 at 6:18 pm
Doubtful the cause of your pain, but.... the SQl Server Max Memory is set at the Default, out of the box value. This is usually bad - SQL will...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 24, 2020 at 10:52 pm
Voting forces a choice. Do I want A, B, or C. consensus allows me to say A, but not B, C is OK. We can come to a choice...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 24, 2020 at 5:02 pm
Viewing 15 posts - 6,016 through 6,030 (of 59,072 total)