Viewing 15 posts - 826 through 840 (of 7,504 total)
All nice and well,
How about:
declare @Data table (begin_time varchar(8),
...
February 25, 2021 at 10:29 am
...MOVE N'NG_System_Data' TO N'E:\TestDB1\TestDB1.mdf', MOVE N'NG_Core_Data_1' TO N'E:\TestDB1\TestDB1.mdf', MOVE N'NG_Index_1' TO N'E:\TestDB1\TestDB1.mdf', MOVE N'NG_Log' TO N'E:\TestDB1\TestDB1_1.ldf', NOUNLOAD, REPLACE, STATS = 10 GO...
You are moving multiple files to the same...
February 18, 2021 at 12:29 pm
Double check configuration setting 'optimize for ad hoc workloads'
exec sp_configure 'optimize for ad hoc workloads', 1;
reconfigure
February 16, 2021 at 6:40 am
There is a vivid SQLServer community in Germany!
Maybe that's the way to go on your quest: SQLPass.de
February 15, 2021 at 7:54 am
What version of SQLServer are you on ?
SELECT SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel -- SQL 2014 SP1 CU5
, SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference
... February 15, 2021 at 7:48 am
If I were you, I would indeed test it in SQL2019 and see how it performs.
Start with "Data migration Assistant" !
Then migrate - and follow up as Grant pointed...
February 9, 2021 at 8:46 am
I should indeed have been a bit more thoughtful and provided the nice context as you did, Grant.
A couple of sentences providing the full set of activities that are actually...
February 8, 2021 at 1:28 pm
February 8, 2021 at 11:07 am
In your first query ( "then" part ) you only select columns of the "DROPS " table.
of course, your "ELSE" part will only get executed when it does not find...
February 8, 2021 at 11:04 am
if your storage is a SAN, you could implement Storage Replication with failover capabilities. ( Storage arranges sync )
On the newer SQLServer side ( first on SQL2012 ), you could...
February 5, 2021 at 12:45 pm
Just my 2ct:
Azure AD <> on-prem AD !
Granting an Azure AD user or group requires :
1 ) An Azure AD account ( user or group ) to be granted Azure...
February 5, 2021 at 12:33 pm
...Example (dates changed to integers to simplify the problem) ...
Just wondering how the current solution performs with date/datetime data types on a larger set of logging data.
February 4, 2021 at 7:16 am
Regarding your I/O errors: You MUST investigate these as SQL Server is only raising this alert if a single I/O takes more that 15 SECONDS !
This may indeed have a...
February 3, 2021 at 10:50 am
Do you document "preferred node" in SQLServer ?
If yes, you could have a startup stored procedure checking that value to the current value and raise an alert or send an...
February 3, 2021 at 10:45 am
Have a look at powershell module dbatools ! it has very nice features to support your migration.
DBATools sql server migration enhancements
February 1, 2021 at 2:40 pm
Viewing 15 posts - 826 through 840 (of 7,504 total)