If you look at a yacht these usually have a small 14" turbine to power up the radio and GPS navigation equipment. If you put one on your roof...

I second the warning on the strange brand bulbs. I've had some of the branded ones for 8 years but some of the el cheapos lasted 6 months.

The more...

I recently visited Sellafield/Windscale in Cumbria, UK. There is an exhibition there that illustrates that if we all do a relatively minor thing, such as switch to low energy...

If you supply no arguments to the sp_Tables stored procedure then it drops through to the last query in master.dbo.sp_tables which has a where clause of

where

o.name like @table_name

and user_name(o.uid) like...

Within Access from the Tools menu select Analyse/Documentor and follow the Wizard.

Within SQL Server Enterprise Manager choose your table, right-click, choose All Tasks/ Generate SQL Script

It is usually a string character going into an integer field.

Script your table, then use the Access documentor to document the offending table and compare the two scripts.

sp_tables retrieves tables that the user owns and has at least select permissions on one column.

What is different about the single table that is retrieved and the others that are...

You can force a Clustered Index Seek by adding a seemingly superfluous WHERE clause that searches for values in that index between two values.

For example, if the clustered index was...

I have, but they appear to be in some form of binary format.

Its Windows 2000 Advanced Server cluster (Active/Passive) dedicated to SQL2000 Enterprise Edition 32 bit at SP3.

Yes I have read the Microsoft literature. The situation is that I have just joined a company as their first DBA and they have a very knowledgable infrastructure team...

Yes, it is not set.

Our infrastructure guys said that SQL 2K automatically recognised the memory out of the box from a standard install.

No it is the 32Bit version and the SQL Server seems to recognise 3GB RAM.

The server is running in an Active/Passive cluster so I was wondering if the cluster service/manager...

If you look downt the FIX list for SQL2000 SP4 + the AWE cockup hot fix you will see that a number of fixes are for improving slow running queries.

I...

If you have a table function then you can do a SELECT on the output of that function where as with a stored procedure you can't, at least you can't...