I have a sp that can script permissions for a role, including column permissions and the Grant option.  If you want a copy, mail me at evassie@cls-services.com

We are not clustered and have a similar disk situation to Andy.  I decided to put tempdb data files on the local disk.  The local disk also holds the paging...

f this applied to UK customers purchasing from Amazon.co.uk (that is, everything is within UK jurisdiction), then I think UK law is fairly clear...

If the supplier says thay will charge...

I don't have any kids, which could make me more objective or less relevant.  Anyway, my view from living in England is...

The recommendation I make to friend's teenage children is that...

The normal recommendation about shrinking any database file is: do NOT do it.

It is only worth shrinking a database file if you expect the smaller size to remain long-term.  If...

As Colin says, there are a lot of incorrect posts about tuning SQL memory.  For what my 5+ years of SQL experience is worth, Colin's post gives the right answer.

You are almost right about transaction log behaviour in Simple mode.  You need to take into account the impact of logical log files (see BOL for details of these) as...

Look out for 'Desert Island Disks' on the BBC Radio4 site.  It is interesting to hear that week's celeb discussing what they would take and why.

As previous posts have said, you need SQL Server Management Studio.

If your box does not have access to the internet, then you may find SSMS is a tad slow in starting...

The figures for space used in sysindexes appear to get updated automatically when new extents are added to the object, but are not updated automatically when extents are released.  This can...

The join order can affect efficiency.  It depends...

The SQL optimiser is a good cost-based optimiser, but it is not psychic - if you do not tell it something it could...

As far as doing te upgrade is concerned, I recommend uninstalling SQL 2000 and doing a clean install of SQL 2005. 

You should script all your user objects from master,...

Another way to get your error message is if the auto grow parameters on tempdb are very small.  This also applies to all other databases. 

When SQL decides it needs to...

If your server is connected to a AD domain and you change the server clock to be outside the time tolerance of AD, then you risk corrupting AD on your domain...

Another factor to consider is the use of VMWare RAW disks.  I did a SQL benchmark in 2004 with raw compared to native disks compared to a physical OS.  With all...