That's an excellent idea Steve - would it be possible to link to his related CBO blog entires also?

http://sqlblog.com/blogs/joe_chang/archive/tags/cost+based+optimizer/default.aspx

Grant Fritchey (8/28/2009)

---

I'd recommend the Inside SQL Server series. You'll be hard pressed to find better information. Specifically I'd suggest getting "T-SQL Querying" by Itzik Ben-Gan, "The Storage Engine" by...

Marcin Gol [SQL Server MVP] (9/6/2009)

---

Paul, your idea is quite interesting but when you are using NewId() - there are "only" standard problems with indexes (you can use fillfactor and...

Thank you for the feedback 🙂

Marcin Gol [SQL Server MVP] (9/6/2009)

---

using dbcc updateusage helps ? it shouldn't. there were some problems with counting allocations but on sql server 2000! 2005/2008 are running good. the only...

The following script illustrates one way to use a read-only file group.

-- Temporary database

CREATE DATABASE [6D79D4CD-D98F-4D75-B3C0-6134DF86BDC2];

GO

-- Add a file group to hold read-only tables

ALTER DATABASE [6D79D4CD-D98F-4D75-B3C0-6134DF86BDC2]

ADD...

There are at least three things you could do:

1) Download the evaluation edition of SQL...

If CHECKSUM page validation is enabled for the database (and always has been*), the chances of a data corruption going undetected are rather small. So long as this is...

One logical possibility is that the client or driver is converting the value to an integer type.

Try tracing the connection with SQL Profiler to see the text of the statement...

There's nothing special about a Navision database (except maybe in the 'special needs' sense) so a linked server would be by far the better option. Trying to use .NET...

I always enjoy Joe Chang's work - his blog on SQLBlog.com is a favourite of mine.

The referenced article is a typically thorough and measurement-based analysis; it's also a good summary...

I'll have a look at the results you posted, but the site formatting makes it kinda hard 🙂

It may pay to save the results to a CSV file (right-click and...

Jack Corbett (9/5/2009)

---

Just read in Grant's book, Chapter 8, that:

To limit contention with the operating system, I will usually set the max degree of parallelism setting to one less than...

Hi Aidan,

If you could run the following and upload the results it would help enormously.

Thanks

Paul

-- scheduler info (inc. NUMA)

select parent_node_id,

scheduler_id,...

PRINT OBJECT_DEFINITION(OBJECT_ID(N'master.dbo.sp_helptext', N'P'))