Yep that covers it, but it's maybe not the clearest or most comprehensive page ever added to Books Online 🙂

There's a load more interesting stuff around the storage of the...

Hey Mark,

Wouldn't mind seeing...

I don't know how to do it.

kthxbye

Flo - thank you so much for the Tui billboard :laugh:

I should have known you'd get your revenge! Man, that made me snigger out loud at my desk....!

Hey everyone, just a quick note before I go to work this morning. I love the way this thread it going - huge thanks especially to C# Screw (lol!)...

Thank you 'brigzy'...you seem to have a much faster machine than my old laptop!

Hey Jeff,

The performance of the code in the article (unless I have really messed up) seems very dependent on collation. For a long time yesterday, I couldn't understand why...

To the C# crew:

This seems to be the fastest method so far (on my machine at least)...would one or more of you please try it out?

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class...

If you need sequential numbers, use DENSE_RANK.

http://support.microsoft.com/kb/271624

http://blogs.msdn.com/psssql/archive/2009/05/15/how-it-works-dbcc-memorystatus-locked-pages-allocated-and-singlepageallocator-values.aspx

http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?List=46f36841-4c69-4240-b060-e0712db6f3ba&ID=8

:laugh:

Can't really be bothered to go back that far. I'll take your word for it.

See this is what happens when you take a break Flo! You get overtaken!

Hmmm I think I preferred SSCommitted to SSCrazy, but it...

Good advice.

I think you misread...

brigzy (11/17/2009)

---

You really should address Thiago who wrote the test data generation SQL. Thiago's script does generate a complete table quite nicely, this we used for testing the techniques....