I'd like more features on SSMS

Formatting of t-sql - with the ability to alter the formatting rules

Improvements in intellisense - current version is a good start, but suggests too many...

Useful, if only to learn about the new INSERT syntax

capitulate

There was an article on this site recently on deleting large numbers of records, while minimising the effect on the logfile.

http://www.sqlservercentral.com/articles/T-SQL/67898/

And more interesting tips came up in the discussion on...

This is excellent Paul, Thank-you.

The clustered primary key improved performance from a cost of 1.8 to 0.08,

I must remember the discussions on SSC are a vital part of the...

Jeff -

Did you somehow hack the site to get to be SSC-Insane,

Only this morning I checked the leader board and you were definitely SSC-Champion.

Steve Jones - Editor (4/20/2010)

---

Tom Brown (4/20/2010)

---

Tom.Thomson (4/20/2010)

---

Gianluca Sartori (4/20/2010)

---

Tom, just out of curiosity, what does your signature mean? I think it's Scot-Gaelic and you look very Scottish (my...

Reminds me of...

Tom.Thomson (4/20/2010)

---

The...

Attached screenshot of execution plans for

Top: Live (with nonclustered index)

Middle: Test (with clustered index )

End: Live (with clustered index)

Showing that the clustered index makes little or no difference to...

Thanks exactly what I needed, I've read and inwardly digested the article.

I created test data and worked out both methods - and on the test data I found the...

New to SQL2005 were Common Table Expressions (CTEs) which begin with the reserved word 'WITH' - these won;t work in SQL2000

There are many other ways that WITH can be used,...

A Good question. I learned something from this.

I've used IDENTITY for ages, assuming its both duplicate-proof and automatically indexed.

I'm glad to have this pointed out to me...

Use the XMLcolumn.query syntax

See XML Support in Microsoft SQL Server 2005

I have noticed some unusual things can happen when you use DENY permissions.

I think in most cases, a DENY will take priority over any implicit GRANTs - but...