Viewing 15 posts - 31 through 45 (of 1,192 total)
TLDR: If you can avoid running other performance-sensitive or resource-intensive jobs during reindexing and CHECK* jobs, do it.
Longer explanation:
Here are some of the major possible pain points.
IO:
Both reindexing and CHECK*...
March 26, 2020 at 7:14 pm
No problem. Glad you got it resolved!
March 26, 2020 at 4:46 pm
What is the log_reuse_wait_desc for the database?
SELECT log_reuse_wait_desc
FROM sys.databases
WHERE [name]='your database name';
Cheers!
March 26, 2020 at 4:34 pm
Another way, probably easier, is to set up an extended events session collecting the error_reported event, filtered to that error number, and add the tsql frame or tsql stack actions.
Either...
March 26, 2020 at 4:11 pm
This is getting a bit away from SQL Server, but I'm up for the occasional digression (and there could be some interesting SQL Server tasks once all this is hammered...
March 25, 2020 at 3:16 am
The problem is not inherent to including runners with implied probability of winning greater than 50%.
This problem would arise any time the total implied probability of winning for all picks...
March 24, 2020 at 10:30 pm
I know. I'm not saying it makes the question or answer incorrect.
I was just providing a possible reason for the explanation's being inaccurate in the way JeremyE pointed out.
That the...
March 24, 2020 at 5:10 pm
Seems like the explanation paraphrase just left out a key phrase from the official documentation:
SQL Server 2019 (15.x) supports up to 15,000 partitions by default. In versions earlier than...
March 24, 2020 at 4:53 pm
Phil's snippet is not language/dateformat dependent, so should just work.
I'm guessing what is "not working" is the application of that pattern to the OP's original problem.
The OP did say some...
March 24, 2020 at 4:38 pm
Just for variety, here's an alternative that should work.
WITH
filtered_and_adjusted AS
(
SELECT Room,
Date_,
...
March 24, 2020 at 4:25 pm
"Not working" is not helpful. What is the error message?
NVARCHAR needs a length.
What is the data type of [due date]? If it's a date, why not just
CAST([due date] as...
March 23, 2020 at 9:08 pm
A few points....
Style 104 is a dmy format, so one potential explanation is that your language is US English or another for which the dateformat default is mdy. That would...
March 23, 2020 at 9:03 pm
I still get 6.5, and not 5.5, for the first value though?
You're just adding up all the times, which doesn't give the correct number because of this requirement from the...
March 23, 2020 at 4:42 pm
Those NULLs are the NULLs from GROUPING SETS (you can use the GROUPING function to distinguish them from other NULLs).
You've specified that you want aggregates returned for two different groups:...
March 23, 2020 at 3:12 pm
First, my apologies to the OP for participating in the hijacking of the thread, but this COUNT(*) vs COUNT(1) stuff is worth handling.
On COUNT(*) vs COUNT(1), I've never been able...
December 11, 2019 at 11:24 pm
Viewing 15 posts - 31 through 45 (of 1,192 total)