I am a leftie, and switched from using the mouse in the left hand to using it with the right hand. It took a lot of getting used to, but...

I agree with Steve... a game is always between 2 teams, so I would get rid of GameTeam and just have a foreign key to Team for HomeTeam and AwayTeam...

Hmmm... I wonder if the OP will start going for interviews as a plasterer with all this knowledge being imparted. 😛

If this is just a case of wanting to reduce the amount of typing, you can get SSMS to do most of the work for you...

If you expand a table...

I don't think you can kill the resultset, but you could do something like this...

create proc myproc

begin

select something

if exists(select somethingelse)

select somethingelse

else

select...

Just add the bit in bold...

create database dairy

on primary

(

name='address',

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\address.mdf',

size=5mb

)

log on

(

name='address_log',

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\address.ldf',

size=10mb

)

That MSDN article could certainly be made a lot less ambiguous.

On the one hand, it's true, you can't shrink a database below its original size using DBCC SHRINKDATABASE (which is...

The Select is waiting on the Insert, but, it's a deadlock... so the Insert is also waiting on the Select.

It's all pretty new to me too, but the query that has the parallel waits is the SELECT statement, so that would seem the obvious plan to do first.

This could be down to some Intra-Query parallelism.

Although your deadlock graph shows 3 processes, there are only 2 spids involved, and one of the waits involves a parallel exchange...

Tomorrow... when it's free!

Agreed... it looks like our reading of the original requirement is different.

I assumed the test would involve a role switch and back again, but with some updates done at the...

Are you sure? This was something I had done previously (SQL2000 admittedly) with...

You mention problems when there is a large update on the publisher. Is there any way you can reduce the size of the update transactions there (i.e. more transactions, but...

You won't break log shipping... have a look in BOL at Log Shipping Role Changes.

Essentially, you do your final transaction log backup at the primary using "WITH NORECOVERY", then

restore...