No probs, thanks for the feedback.

Hi there Antares686, here is the DML

CREATE TABLE [Application_Function] (

[application_code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[function_id] [int] NOT NULL ,

[parent_function_id] [int] NOT NULL ,

[function_code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT...

Hi all

Some things to remember..

a) measures physical io, not logical, flush buffers when testing

b) force checkpoints when testing writes to force log flush

before trying it all on prod

Cheers

Ck

Hi steve, good article.

Other things to watch:

a) if moving msdb and model at the same time, attach model before msdb. I have run it issues with database ID's...

Fantastic article.. thanks for the insight into some of the lower level commands, most appreciated.

Hi

Thanks for the emails. Sorry about the query actually, my fault, this was 1 of the many in an attempt to improve overall performance. The

DELETE FROM corpsys.dbo.organisation...

DELETE FROM corpsys.dbo.organisation

where exists

(select org_id

from corpsys.dbo.organisation B with (nolock)

where last_updated_by = 'NTISImport'

and organisation.org_id = B.org_id)

(167 row(s) affected)

17min 35sec

btw.. i didnt even vote yet, where did my 3 stars come from?! sorry, it should be 5 stars! 🙂

Hi

First of all from a comment made:

>>I am a great believer that SQL Server is too easy and has shot itself in the >>foot, as developers have designed bad databases,...

Hi

Its far from worst practice, but is something to consider. Archiving off data and making it subsequently accessible for historical reporting (typicaly old user queries and auditing) is difficult...

Hi

Ok, cool, i initially ripped an example from sqldts.com for looping but its a tad restrictive with access databases. In the end, I adapted this code to generate a...

Hi

One question:

WARNING: - This will use 1/8th of the memory available to SQL Server.

So, we open up 10 4kb documents it will do what to memory?? and what memory structure...

Great article !

Hi

"duplexing" log backups (and fulls!) is common place for oracle dba's, but typically not to another server. Where possible, I always code it in with a simple custom SP...

Hi all

This error can also occur if the proxy account's password expired, account is locked etc.

cheers

ck