Whole heartedly agree.

I also remove all rights assigned to the PUBLIC group/role so that a user has to be explicitly associated with a specific role. You don't come in...

I haven't checked either because I'm working in a pure development environment and at this stage is is all pretty hypothetical.

I will do some testing at a later stage to...

Thanks Guys

But what I was after was something like

SELECT @@ROWID,*

FROM Tbl_

WHERE @@ROWID BETWEEN 10 AND 20

I've seen your select TOP queries where a sub-query also has a TOP clause...

Yes definitely

When I did the SQL 6.5 courses I was lucky enough to be taught by a trainer with commercial dba and they stressed the importance of this.

One thing I...

http://support.microsoft.com/support/kb/articles/Q305/7/11.ASP

I agree with using Hungarian notation for objects and variables.

I would NOT use it for anything that a user might see such as a column name.

I picked up the idea...

Trawling through the Microsoft site it turns out that this is a known bug when SQL is configured for Windows NT Authentication.

The work around is, as Andy recommended, to use...

Thanks.

I've tried that but it doesn't let me reassign the SA account back to the dbo user.

I'm a bit concerned that any further databases created all seem to have this...

I was recently asked to install some databases for a client and their support company specified that the database should be split into 3 filegroups.

1. PRIMARY - to be...

The problem is that the number of queries you need to write grows geometrically.

1 variable = 2 queries.

2 variables = 4 queries.

3 variables = 8 queries etc.

In other words the...

Just to clarify:-

The index is on ColA, ColB.

If the WHERE clause searches on ColA only will the index be used?

Yes, it works.

I read somewhere that evaluating NULLs has a performance hit, although I suspect it is very minor in this case

They say that lazy people take most pains!

I had seen a syntax for an INSERT statement that went something like:-

INSERT Tbl_X

EXECUTE Sp_Y

Where Sp_Y returns a recordset.

I was wondering if there...

Here is the same thing avoiding CURSORs.

Use Test

GO

Declare @MyRecipients nvarchar (255)

Declare @MyMessage nvarchar (255)

Set @MyRecipients=''

Set @MyMessage = ‘Your timesheet is overdue, please send it ASAP.'

WHILE @MyRecipients IS NOT NULL

...