The only down side I have found with derived tables is that they are memory intensive.

This becomes an issue if you have an application that runs complicated queries for a...

The great thing about scripting is that you are creating documentation for your database.

I also find that a well laid out script is useful teaching aid for educating wannabe developers.

When...

I work within a programming company and everyone who has seen .NET absolutely raves about it.

The one comment that has been made is that VB.NET will make a lot of...

I've found that if you want to pass a string to use as the IN list in a WHERE clause it doesn't work!

What I did was put a small header...

The idea of certification becoming the IT worlds equivalent of a doctor's license to practice medicine is an interesting one.

I think certification should be levels of certifications i.e. MCDBA grade...

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