Let us suppose you have 3 logins for your app

Domain\Tom

Domain\Dick

Domain\Harriet

Within your database you would run

exec sp_addalias 'Domain\Tom','dbo'

exec sp_addalias 'Domain\Dick','dbo'

exec sp_addalias 'Domain\Harriet','dbo'

Even though your 3 users log on with their own...

If you are using stored procedures make sure that you have SET NOCOUNT ON at the head of each stored procedure. I have timed 10,000 itterations of a simple...

The ANSI standard is your method but for the most part it is a case of personal preference.

My personal preference is to keep the WHERE clause for filtering and the...

In the days of SQL 6.5 there was only ever one dbo so in order to grant dbo privileges there was an sp_addalias stored procedure to allow many logins to...

I've mentioned it before but during the industrial revolution one of the big Lancashire mill owners discovered that if employees only had to work 14 hours a day instead of...

There are two sorts of bunking off when you are not physically sick.

1. You are swinging the leg because you fancy a day off.

2. You are burnt out and need...

Personally I would be very surprised if it could but in the old days of the Commodore Pet you could POKE a location with a certain value and the motherboard...

I looked into creating extended stored procedures but I found that they were more trouble than they were worth.

I took to creating ActiveX DLLs and using sp_OACreate etc to instantiate...

What build number do you get when your run SELECT @@VERSION?

Is it 2 separate users firing these processes or a single user?

If it is one person firing off one command...

You don't actually seem to be using t_HAFAccount so why use it in the join. Assuming that you are actually going to use it and the query isn't finished...

OK encrypt your procs but make sure that you have scripts should you need to get hold of them. Frankly it is more trouble than it is worth.

I wouldn't...

How do they name hurricanes anyway?

What they don't tell blokes about marriage is that you evolve a new sense organ called the marital radar. It pings like crazy when...

Thanks Rudy,

We are currently experiencing the old TempDB contention issue that was partially fixed by Hotfix 818. We are running back at SP3a on build 760.

I am going to...

I had more or less decided to set the initial size to 4GB as creating such a file on the SAN is a surprisingly quick operation.

I was thinking of fixed...

Correct!

The performance of the stored procedure using the new table instead of the view is lower than when using the view alone.

It is an absolutely crazy result, especially as the...