Power Query

Technical Article

RE: Baffling Sql2k backup times

  • Reply

We had a similar issue - backup times had gone up drastically - and it turned out that 1 of the disks in the array had gone bad - as soon as we replaced that disk - the backup time came down to normal.- DK

2004-03-09

Technical Article

RE: sp_spaceused tablename for each database

  • Reply

And Expanding on Mohammed Excellent idea:DECLARE @SQL  NVarchar(4000) if OBJECT_ID('tempdb..#T1') IS NOT NULL  drop table #T1 create table #T1 ([name] varchar(60)   , [rows] varchar(11)   , reserved varchar(11)   , data varchar(11)   , index_size varchar(11)   , unused varchar(11)   , DBName nvarchar(128))SET @SQL = ' SET NOCOUNT ON ' SELECT @SQL = @SQL + ' INSERT INTO #T1 […]

2004-02-20

Blogs

Rotating a Certificate Used by TDE

By

In terms of encryption, Key Rotation is the process of replacing your encryption keys...

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Read the latest Blogs

Forums

Ownership chaining

By Duncan Lawrence

Hi, I have four views on one database to which one sql authenticated user...

Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Encrypting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encrypting the Database Encryption Key

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers