If your unique ID is your primary key or a unique index then SELECT XYZ FROM dbo.abc WHERE key='232' is going to be fast no matter how many records you...

No, there is no drive mapping involved. It is simply a case of writing to a local directory.

I have tried right-clicking on the scheduled job and adding my intended...

Jeff,

Have you seen the trick where you do a completely superfluous WHERE {ClusterIndex} BETWEEN {ClusterIndex}.MinValue AND {ClusterIndex}.MaxValue

In SQL2000 this can force the clustered index seek even though the clause does...

I don't have BOL in front of me but look for a procedure with a name like sp_resetstatus.

Once you have done that you should be able to DROP the database.

This mind intentionally left blank

If you do WHERE {Function(field)} = {value} then you will probably do a TABLE SCAN because the value isn't an indexed value.

Probably won't matter in a small-ish database but in...

So am I correct in thinking that it is if a single transaction requires a growth in excessive of current free space limits plus one expansion?

That is (Company Removed) added to my SPAM filter and blocked internet sites!

SQL2000 also makes use of the INFORMATION_SCHEMA views. You can see the definitive list within the MASTER database.

Some of the system tables have changed in SQL2005 so I would...

bcp is one way. I use BCP to export the results from stored procedures.

You can use SQL Query Analyser .See The best kept secret about SQL Query Analyser....

It depends what you mean by huge

I had a requirement to produce a search that had certain compulsory search terms and a number of optional ones.

What I did was have...

I take it that these were not Windows Account users?

A login has an SID number which is unique to the box. SID 1 is the SA account.

If you recreated...

Try this article

Frank Buchan and David Reed both make the point about weaknesses in business analysis contributing to poor code quality.

Quality is something that needs to be something applied to throughout a...

The INT method does not require any padding.

The user wants to query for a range of dates then

CREATE PROC dbo.MyQuery

@StartYear INT ,

@StartMonth INT ,

@EndYear INT ,

@EndMonth INT

AS

DECLARE @StartPeriod INT ,@EndPeriod...