New answers tagged

1 vote

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?

Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days? It's still a relevant consideration, perhaps more so now than ever as core counts increase. It ...
user avatar
  • 70.9k
0 votes

Taking backup of all the databases in SQL Server

Here is solution using Powershell Get-SqlDatabase -ServerInstance YourInstanceName | Where { $_.Name -ne 'tempdb' } | Backup-SqlDatabase Which I have mentioned here also How to backup SQL server ...
user avatar

Top 50 recent answers are included