For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records. To keep the size manageable, we run a job every hour which moves records older than 60 days into an archive database. We used to run it every day […]
2004-06-22
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
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
2004-02-19
In terms of encryption, Key Rotation is the process of replacing your encryption keys...
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Hi, I have four views on one database to which one sql authenticated user...
Comments posted to this topic are about the item Schedule Jobs on a Clustered...
Comments posted to this topic are about the item Encrypting the Database Encryption Key
Ask SSC