Viewing 15 posts - 1 through 15 (of 17 total)
I think you do not need the "Group by":
SELECT TOP (1) DateTime,
MAX(CASE WHEN TagName = 'WFI_LP01_Cond.PV' THEN value END) AS Cond,
MAX(CASE WHEN TagName = 'WFI_LP01_Temp.PV' THEN value END) AS TempAtMaxConductivity
FROM...
January 10, 2021 at 9:12 am
From Brent Ozar,
Rebuild: An index ‘rebuild’ creates a fresh, sparkling new structure for the index. If the index is disabled, rebuilding brings it back to life. You can apply a new fillfactor...
January 10, 2021 at 9:00 am
It looks like you got what you needed. I would suggest to have an error table / file to capture the error records with a time stamp. Then you can...
January 10, 2021 at 8:34 am
I am not familiar with the ZERTO product. I would agree "ALWAYS-ON" is a proven/effective replication technique. There is also transactional replication w/o log shipping. If you have small/medium size...
January 10, 2021 at 8:14 am
The limit of 1gb is for a singe SQL instance. You can create extra instance and that will use 1gb also.
The restriction of memory is for buffer cache. SQL Server...
January 10, 2021 at 7:55 am
From other sources:
The current master key cannot be decrypted. If this is a database master key, you should attempt to open it in the session before performing this operation. The...
January 10, 2021 at 7:20 am
The following must be in your select statement:
(CASE WHEN displayorder IS NULL THEN 1 ELSE 0 END)
You will require an additional T-SQL variable.
Cheers
January 10, 2021 at 6:53 am
November 25, 2018 at 5:46 pm
The following site has some useful information:
Regards,
September 24, 2017 at 11:55 pm
Greetings,
Please review the following Web site: (setting up the SSIS package should be done as explained in this site.)
Please test your solution in a...
September 24, 2017 at 11:35 pm
Greetings,
You could partition the huge SQL server table to partitions to alleviate the heavy burden. Then you can apply indexes much easier to different file groups. Please see additional comments...
September 24, 2017 at 11:15 pm
Greetings,
Please try this power shell script:
$colItems = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace "root\CIMV2" | where{$_.IPEnabled -eq "True"} Write-Host "# --------------------------------------"Write-Host "# Local IP address information"Write-Host "# --------------------------------------"foreach($objItem in...
September 24, 2017 at 9:40 pm
Greetings,
Well, you could run your individual scripts on each server as you stated.
The other option is to run a power shell script, which would connect to each...
September 24, 2017 at 9:01 pm
July 10, 2017 at 10:20 pm
Viewing 15 posts - 1 through 15 (of 17 total)