Viewing 15 posts - 76 through 90 (of 6,831 total)
No, not directly from SQL Server anyway. SQL has no mechanism to allow only certain parts of data in a table to be backed up.
You back up databases (or filegroups,...
May 26, 2022 at 5:26 pm
Look at the usage stats for the indexes to see if they are useful (and/or more useful than not).
There's no single number of max indexes for a table. It depends...
May 25, 2022 at 3:32 pm
Didn't have usable data to test with, so the code is untested:
SELECT A.Name, A.DateOfBirth, ot.Count
FROM TableA A
CROSS APPLY (
SELECT TOP (1) *
...
May 24, 2022 at 5:26 pm
Your structure should be normalized, as you stated.
create table #countries
(
company int,
[year] int,
rev int,
country_sequence smallint,
country varchar(100)
)
(12011,2010,121,1,'Egypt')
(12011,2010,121,2,'France')
,,,
May 23, 2022 at 3:10 pm
We need to see the actual lookup code to offer more specific advice here.
Proper indexing could also be critical to getting best performance for this task.
May 23, 2022 at 3:05 pm
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]
FROM #JobsToDisableEnable
@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 FOR
SELECT job_name,[enable] --<<--
FROM #JobsToDisableEnable
Also, in the EXEC, you...
May 20, 2022 at 5:32 pm
Hello,
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
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 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
Viewing 15 posts - 76 through 90 (of 6,831 total)