In SQL Server 2005/2008 you can issue this:

select socket_count = cpu_count / hyperthread_ratio

from sys.dm_os_sys_info

In SQL Server 2000 I'm not aware of any way of querying this.

Duplicate post. No replies please.

See here for replies: http://www.sqlservercentral.com/Forums/FindPost1201808.aspx

Jonathan Kehayias describes a different method here:

Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail[/url]

Hope this helps

Gianluca

This post on Paul Randal's blog should help:

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Using-DBCC-PAGE-and-DBCC-IND-to-find-out-if-page-splits-ever-roll-back.aspx

I guess you're right Jeff.

It should be DLLHOST.EXE (default surrogate for out-of-process load). Since I have many of these running, choosing the right one to kill would be a russian...

BTW, I must be very low on that tree, because I was never able to make my point loud enough as to have all the sins I mentioned above fixed.

I...

Tom, you made a very good point and it would be great if you gave me the permission to include your considerations in my article.

Indeed, there are good reasons to...

Thanks Elliott, I already have tried that, with no luck.

But you made me remember a quite important thing:

The provider gets loaded out of process and I should probably kill the...

GilaMonster (11/7/2011)

Ninja's_RGR'us (11/7/2011)

So you're un-annoyed now? Or did we just transfer that from the op to us?...

onedaybefore (joindate) ==> DATEADD(day, -1, joindate)

Thanks Jason and Wayne!

I still have to wite a decent intro and include performance tests results.

I must warn you: lots of code in there.

Hope it turns worth publishing with your...

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I put together an article (well,...

You don't need to format dates.

Let the application do it.

Can you post the plans at least?

Identical parameters? I would exclude parameter sniffing then.

Can you post tables + indexes definition and good + bad actual execution plans?