microsoft tell me there is a new web site which should help in this area

http://www.microsoft.com/sql/alwayson.mspx

I can follow the a/p scenario, this I've had described. In a full failover situation how do you ensure your data integrity? The explanation I've had is that san replication...

you prob need something like this

create function fn_StringToTable2(@String varchar(8000),@delimiter  char(1))

-- table has an indentity and index for forced ordering and selection

returns @results table(c1 varchar(250),NumKey int identity(1,1) primary key clustered)

as

BEGIN

DECLARE @Phrase...

I've encountered various problems with replicated database backups taken to other servers. There are some procs which can be called which make the database non replicated. I'd guess this is...

It's most likely poor disk performance. Raid 5 by any chance?

run the perfmon counters to check i/o completion time, if this more than say 5 or 6 ms then this...

I've found when running batches , usually on a database with simple recovery, adding a checkpoint and update stats ( on the tables involved ) between batches definitely improved performance....

probably the bigint, I use them quite often.

Although you can't technically manage, my favourite application to use with SQL Server is Diagnostic Manager, I've used it since it was SQL Probe back in 1999 ( ish )

sorry, I'm struggling to read the plan, but are you getting parallelism involved ? Please please don't alter the server settings but you might want to try your query with...

My view is that it's not a good idea - but - if there is a good reason why you need to do this then fine. I prefer keys which...

The options for placement of files are within the setup dialog. User databases are easy to move, BOL will document moving of system databases, I guess, I haven't attempted this...

As a production DBA I attempt to discourage the use of ALTER, whilst it might maintain permissions it does not update the create date of the object. When prod systems...

most sites will include functions which will do this, search through the script libraries

it will return a status of running or stopped ( or paused ), you can also query other non sql services

I think the important point about the views on normalisation is to implement what works for you.

You'd normally consider normalisation at the design stage and then modify the schema...