Hi Steve,

I've rewritten a follow article on Hekaton which I'll submit soon, you can see a preview here though if interested - https://paulbrewer.wordpress.com/2015/06/27/hekaton-the-good-the-bad-and-the-ugly/[/url]

Hekaton is very, very fast when processing lots...

Thank you for the positive feedback John, very much appreciated.

Nice one 🙂

Microsoft Dynamics CRM used to suffer (7 years ago, not sure if it still does) from a lot of 'Key Lookup' deadlocks related to excessive use of complex views built...

Have a look at the views in a microsoft dynamics CRM database. Views upon views upon views. Users create new ones dynamically too just to make it a bit more...

Hi Gail,

I spent a couple of hours last night using this stress testing tool SQLQueryStress to compare temp table\table variable latch contention. You were right, I could...

There are important items missing from the checklist, 'Instant File Initialization' for example. Also, no mention is made of the consequences of changing certain settings, changes to MAXDOP for example...

This might be a good way of comparing 'create table' differences between table variables/temporary tables:

http://www.sqlskills.com/blogs/paul/determine-causes-particular-wait-type/

It describes a way of defining an extending events session to capture the internal...

I'm not 100% sure to be honest, no. From experience the latch contention associated with table variables 'seems' a lot less profound but I've never investigated or tested to be...

The only 2 advantages table variables have over temporary tables (in my opinion) are:

1. Do not cause statement recompilation (or procedure recompilation in SQL Server 2000) as frequently, reducing compile...

Could you try the latest versions - paulbrewer.wordpress.com

There is a change to the timeout setting, works much better.

Thanks

No, the xml file is created and referenced the the powershell, you don't need to do anything to it. It sounds like you might have permission issues.

Regards

Paul

I've run out of enthusiasm for the project but someone found and fixed a problem related to Case Sensitive database collation. The master copy of the source has been loaded...

Hi,

Just a quick note to advice getting the latest version of the stored procedure and PowerShell script.

Click here for the most current version of the ps_RestoreGene script. [/url]

Click here for...

Thanks Patrick, please let me know if you have any problems with it.

Best Wishes

Paul