Lets see if I understand your method Chris.

dbo.INDICATORTABLE contains a single record with the uniqifier field set to 1.

All you do is set the value of othertablepk to the primary...

Yes,

Firstly, add the NT Account under which MSSQLSERVER service starts up to your server. This should be a domain account, not LOCALSYSTEM.

Grant it SysAdmin rights.

Remove BuiltIn/Administrators

Be careful if you...

Certain kitchen cleaning products, such as bleach, damage your fingerprints. Yet another reason to delegate domestic chores!

I my setup my MSSQLSERVER and SQLSERVERAGENT account are running with a domain account with minimal permissions to the domain but in the Administrators group of the SQL Server.

Yes, I...

I agree with you on the importance of DBAs.

The big problem is that the title DBA has been down-graded in the minds of those hiring them. I am not...

Using my own personal body parts to secure corporate data?

Look, I'm sure the techno weenies are fainting with pleasure over this but I've seen "Demolition man" with the eyeball on...

Loosely speaking an INNER join requires there to be a matching record in both tables within the join.

If the codes in your main table always exist in your lookup table...

Table scans means that your proc has to trawl through the physical table rather than use indices. There are situations where it Table Scans are unavoidable but in general...

Plato said it first. Words to the affect of when people think alike then very little is thought.

I think phrases like "you achieve more with honey than you do...

I tried the following on an NTEXT column

SET NOCOUNT ON

DECLARE @sPattern VARCHAR(50), @lValue TinyInt ,@lPos Int

SET @lValue=127

WHILE @lValue0

SELECT @lValue , @lPos, char(@lValue)

SET @lValue=@lvalue+1

END

WHEN I did SELECT SUBSTRING(Trace5,,1) I...

I would tend to stick with the built in DATETIME/SMALLDATETIME data types.

If you must use SMALLINT for times then I don't see the problem with parsing it.

For CHAR(4) your programmers...

In terms of internal file space I've found that deleting records from an indexed table does not automatically reclaim space.

Running a DBCC DBREINDEX does that, similarly dropping and recreating indexes...

As you pointed out the sysindexes script only works if the index statistics are kept up-to-date. I think your best bet would be to keep them up-to-date and use...

If you look at the processors tab of the server property have a look at the Parellism settings.

Does it have "use all available processors" checked?

What is the setting for "minimum...

The beatings will continue until morale improves!

The problem with such corporate eugenics is that when encouraging survival of the fittest no-one has the wit to ask "fittest at what"? ...