Viewing 15 posts - 706 through 720 (of 59,066 total)
This reminds me of the good ol' days on these forums... thanks for the memories, folks.
February 20, 2024 at 8:42 pm
If you install this DateRange function, this gives certainly the shortest SQL if not the fastest
select CONVERT(date, d.value) Date,
...
February 20, 2024 at 1:58 pm
IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind any missing...
February 20, 2024 at 5:02 am
My opinion though - SQL Server and xp_cmdshell is an odd tool to use for downloading files from sharepoint... Powershell is a much better way to do it in...
February 20, 2024 at 3:16 am
I have a Job running a Maintenence Plan. The plan performs the Backup Database, Check database Integrity, Maintenence Cleanup and Reorganise Index tasks. Occasionally the Reorganise Index task fails...
February 20, 2024 at 3:06 am
Between the time that Rubrik starts its snapshot and ends it snapshot, tlog files are deleted.
I don't use Rubrik but any decent tool will turn off the "A" (archive)...
February 20, 2024 at 2:40 am
the best way is to use openquery (use dynamic SQL if required to pass filtering parameters) and convert all numbers and dates to strings on source - if required...
February 20, 2024 at 2:33 am
IMHO, the only "actual competitor" is ... the people writing the code.
If they not so good at SQL Server, the code is going to be slow. What makes you think...
February 20, 2024 at 1:50 am
Just to ask the question, have you tried running the database in the 2019 Comparability Level to see if that fixes the issue?
February 20, 2024 at 1:03 am
Like I said 😉 ...
You could/should setup an Extended Event to capture anything (including code) that makes the log file grow. Of course, you'd have to shrink the log...
February 18, 2024 at 5:22 pm
What I'm actually suggesting is to avoid all sorts of problems. You have a process that you want to "throttle" because it uses a lot of resources. Consider what that...
February 18, 2024 at 4:58 pm
IMHO (and a tiny bit of experience more than a decade ago), it would be more effective to have the Oracle side do the necessary "cube prep" and export the...
February 17, 2024 at 2:46 pm
From the Article:
That's a different standard, and while most people in surveys think they are better than average, that's not how averages work. Half of us are below the average.
Sorry...
February 16, 2024 at 6:28 pm
Here's how we'll do it:
February 16, 2024 at 4:13 pm
maxdop is set to 1 at instance level and at database level it is set to 4. looks like each operator within plan is taking 4 threads
Is...
February 16, 2024 at 3:01 pm
Viewing 15 posts - 706 through 720 (of 59,066 total)