It probably doesn't apply in your case but if a clustered index is placed on the field that has the LIKE condition it works quite well because clustered indexes are...

Apparently it is possible to run a standard diesel engine on recycled vegetable oil.

There is a bloke around here that gets his supply of vegetable oil from fish and chip...

The methods discussed in the following article can be used

http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

Of course the instant you use them you will probably breach your support agreement.

Does your 3rd party app need the rights...

Assuming that you have various methods of maintaining your data and can't put the logic in stored procedures try the following

INSERT INTO dbo.HistoryTable (column1, column2......column99999,Action)

SELECT I.column1, I.column2, I.column3 ,....column99999 ,

CASE...

Let us suppose that project A had a task called documentations and project B had a task called documentation. In a projects and employees schema these would be non-atomic.

If you...

Well you cluster for resilience so why wold you want to cluster on the same box?

When you install on a cluster the Enterprise Edition knows that it IS a cluster...

I used to develop using IIS5 and ASP and found that getting Visual Interdev to debug properly was an impossibility. For that reason I always developed a middle tier...

No the 2nd parameter is the user within the database.

Normally, within SQL 7 and 2000 a single login can be a single user in any one database.

What we...

I've spent 1 month tuning 400 queries that use a variety of methods for joining tables so from a performance point of view it makes little, if any difference whether...

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...