Viewing 15 posts - 1 through 15 (of 6,751 total)
It's probably a bad idea all the way around anyway. 🙁 How many people do you know that actually have a "Baseline" to compare against?
For me, it would work...
May 20, 2022 at 7:44 pm
You have the general structure for that, you just had a typo in the SELECT for the cursor. You had:
DECLARE job_cursor CURSOR READ_ONLY FOR
SELECT @job_name, [enable]
@job_name will contain NULL...
May 20, 2022 at 7:41 pm
The DECLARE for the cursor is incorrect: you need to remove the @ from before "@job_name":
DECLARE job_cursor CURSOR READ_ONLY FORSELECT job_name,[enable] --<<--FROM #JobsToDisableEnable
Also, in the EXEC, you...
May 20, 2022 at 5:32 pm
I was looking over the Edition specifications, and Standard is capped at 128 GB RAM is that correct?Can someone recommend me to use sql server enterprise edition or...
May 20, 2022 at 3:59 pm
If you're using 500GB now, it could be very hard to squeeze down to 128GB.
It's likely, however, that you are not using data compression now. From SQL 2016...
May 19, 2022 at 8:27 pm
Please don't use reserved words like "COUNT" and "TIME" for column names.
Please don't state that "COUNT" and "TIME" are reserved words in SQL Server because they are not.
May 19, 2022 at 8:19 pm
In fact, you cannot restore any newer-version SQL Server db to any older-version SQL instance, period. Just does not work.
May 18, 2022 at 8:19 pm
It's likely, however, that you are not using data compression now. From SQL 2016 on, that...
May 18, 2022 at 8:17 pm
EXEC msdb.dbo.sp_update_job @job_name='<your_job_name>', @enabled = 0 /* to disable, or 1 to enable */
May 13, 2022 at 8:22 pm
You're not going to be able to this calculation:
ISRECNUM % 20 = 5
sargable. By definition, it just isn't.
May 13, 2022 at 1:54 pm
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just...
May 13, 2022 at 1:41 am
Absolutely correct. McAfee could end up damaging your db files, esp. log files.
May 13, 2022 at 1:32 am
I suggest using a table to simplify the calcs:
;WITH test_data AS ( SELECT CAST('08/31/2021' AS date) AS [Period date], CAST('07/31/2022' AS date) AS [target...
May 13, 2022 at 1:29 am
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had to...
May 12, 2022 at 4:45 pm
I suggest using SUM rather than COUNT. THEN 1 ELSE 0 is a consistent, clean pattern, whereas THEN 1 ELSE NULL is a kludge.
,SUM(CASE WHEN tc.IsEnabled =...
May 12, 2022 at 3:34 pm