What do you do your development in? If you are a big investor in .NET then the integration of the CLR should be a big selling point.

Although I am...

You need to be careful with this.

The execution plan will tell you the costs but actual execution time can be very inconsistent even when running on your local box with...

Unless you have a very good reason DON'T use string functions in SQL Server. You are much better off using LIKE.

If you are going to return a recordset then...

It seems to be caused by SELECT @var = MAX(datefield) FROM dbo.Table INNER JOIN etc.

The datefield is indexed but is not a clustered index so I would guess that the...

Run a trace using SQLProfiler tracking SQL:StmtCompleted and SP:StmtCompleted events.

My version doesn't use cursors. I tend to view cursors as an object of last resort because of the locking issues.

If you want to affect all views as well...

It is worth mentioning that although there is one LDF file this file also contains virtual files.

If you run DBCC LOGINFO you will see precisely how many files there are....

BOL recommends that each server be given a range of IDs in the shared tables. That is your master would use IDs 0 - 19,999, remote1 would use 20,000-29,999...

From the control panel there should be a licensing icon.

It's been a while but I believe that it allows you to switch in one direction only. That is if...

Assuming that the data to be synced on the remote servers are effectively read-only then PULL Snapshot replication should do it.

If both the central and remote servers are writeable and...

Of course if you are going to bounce the records into a temp table then you can add an identify column to your temp table and dispense with the cursor...

DECLARE @sTableName SYSName

SET @sTableName=''

WHILE @sTableName IS NOT NULL

BEGIN

SELECT @sTableName = MIN(Name) FROM SysObjects WHERE Type='U' AND Name>@sTableName

IF @sTableName IS NOT NULL

...

exec sp_addrole '[ Your role name]

'

GRANT SELECT ON [Your table or view] TO [YourRole]

GRANT EXECUTE ON [Your stored procedure] TO [YourRole]

EXEC sp_addrolemember '[ Your role name]','[Your user]'

Don't grant...

The SQL Query Analyser debugger requires that a domain account be used if the debugger is to work.

The only thing to watch out for is that if SQL Server cannot...

Do step 4 instead of step 2.

I would question the need to shrink the log file unless freak activity has seen it grow dramatically. All that is going to...