exec sp_changedbowner '<>'

Putting your code in stored procs is best practice.

Putting your SELECT DISTINCT into CommandText means that you have to grant read access to your table therefore someone with a valid...

Create a temporary table that holds the extracted IP Address from MT then do an inner join between status and your temp table

ADO tutorial

If you are using ADO to connect to the database have a look at the ADO Stream object.

If you are using .NET use a file stream and Binary reader...

I believe that SQL Clustering has a limit on the number of nodes but assume a server per node plus some form of centralised storage that is available to all...

Well you are likely to get more than one "Chris Smith" as well as more than one "Chris" and more than one "Smith".

ALTER TABLE dbo.MyTable

ADD CONSTRAINT unq_MyTable UNIQUE (FirstName,LastName)

If I get a vague definition of what an update on a table is supposed to do I carry out something similar to the SQL below:

CREATE PROC dbo.setTable @id Int,...

I wish that the editorial was included in the home page of the site.

It adds a bit of variety and is a reminder that there is a human...

If all your tables have a clustered index then

SELECT object_name(id),SUM(rows)

FROM sysindexes

WHERE indid=1

GROUP BY object_name(id)

WITH ROLLUP

indid=1 is the clustered index

I don't have BOL to hand but I seem to remember that you can do something like SELECT @@SERVERNAME

Developer edition is supposed to be limited to 5 connections but apart from that they should be identical.

There is an explicit role called db_accessadmin that allows existing logins to be added as users in a database.

Where possible my approach would be to have Windows authentication and granting...

It sounds like someone set the initial size of TEMPDB to 15GB so if you reboot it will get built at that level.

You can check this by running the following...

If you CREATE TABLE #TableName it should be for the current connection only.

If you CREATE TABLE ##TableName then it will persists until the creating connection disconnects.