If your maintenance plan includes 'Reorganise data and index pages' option, your transaction log will blow out as SQL Server reorganises the data. Under the covers, SQL server will run...

Use the Microsoft SQL Server Best Practises Analyser and Microsoft Baseline Security Analyser tools. Highly configurable, and they can be run over and over a server (or number of servers)...

Have you checked in the MSDN Subscriber Downloads section ? You'll need your MSDN username and password, and I think you have to download either the entire cd / dvd...

True, statistics are used by SQL Server's query plan optimiser. 

Perhaps you turned off 'auto create statistics' or 'auto update statistics' on your database. Make sure both of these are on,...

The transaction log becomes full ?  <- That's your reason!

DELETE works just like every other transactional command (SELECT / UPDATE / INSERT). When you use DELETE, every row that is...

Enter CASE, your new friend...

UPDATE myTable
   SET myColumn = CASE WHEN myColumn = '' THEN 'C'
                                          ELSE myColumn
                  END
WHERE ...

So in your case it may be somthing like:

UPDATE followup 
  ...

Yes. You can

USE database
GRANT CREATE TABLE TO user

The user can then create tables in their own userspace / schema. BUT they can also delete the tables they create. Just...

I'd store it in a varchar field. That will allow you to international code prefix it, and use other local formatting things that people from other countries use.

here in australia...

Logged into Windows using an account that is part of the local windows machine Administrators group:

- Run regedt32.exe

- Browse down till you have the registry key selected

- Right click,...

in addition to the data columns that you select, you need to select the events that you want to actually recieve data for. There are a number of templates included,...

does your database have 'auto create stats' and 'auto update stats' turned on ?

If auto create stats is not turned on, you would have to manually create statistics. Auto create and...

RAISERROR is the way to go if you are going to throw an error up the chain.

At the very least if you are using RETURN you should be giving...

The performance counter is available for download now from

http://www.microsoft.com/downloads/details.aspx?FamilyID=64983af0-7902-427e-9b41-7c2e8fdcc140&DisplayLang=en

It's collecting statistics for me, but the collector doesn't seem to be importing them for me... let me know if it...

Extended stored procedures are a great way to get over the limitations of T-SQL.

If you installed the Development Samples with SQL Server you will have a...

Restoring the master Database from a Current Backup

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp

Tivoli Data Protection for Microsoft SQL Server Installation and User's Guide

(Restoring the master database)

http://publib.boulder.ibm.com/tividd/td/DPSQLN/SH26-4111-02/en_US/HTML/ab5m1m13.htm#Header_122