Andy Hughes (6/22/2009)

---

Each of these tables could be partitioned on CompanyID with the partitions residing on a separate filegroup(s). This should make it possible to point-in-time restore for a...

Just for clarity:

32-bit example:

Microsoft SQL Server 2005 - 9.00.4035.00...

If I understand you correctly, you would like to run multiple instances of the application to introduce some element of parallelism to this task - and you are looking for...

I tend to look at sys.dm_db_index_operation_stats, to see how many lock promotions were attempted as well as how many succeeded:

SELECTTOP (10)

OBJECT_NAME(object_id, database_id) object_nm,

index_id,

partition_number,

index_lock_promotion_attempt_count,

index_lock_promotion_count

FROMsys.dm_db_index_operational_stats

(DB_ID(), NULL, NULL, NULL)

ORDER BY

index_lock_promotion_count DESC;

see the...

Florian Reischl (6/23/2009)

---

Just remembered a thread about two month ago, you posted some code with font size 5 (I think). It looked fine in Chrome as you wrote but it...

Oh boy. So now "standard SQL" has been invoked.

Jeff's gonna absolutely love this - I just hope Carl likes pork.

http://www.sqlservercentral.com/Forums/FindPost740591.aspx

Oh - ha ha ha 😉

Actually it renders just fine in Chrome 2 - albeit somewhat faster than in Internet...

RBarryYoung (6/23/2009)

---

It looks like my code got partially garbled when they tried to format it for the article. I have attached the actual code in a text file for...

Well I did try! :ermm:

Once I have removed the line numbers and line breaks, I get this:

declare @s-2 nvarchar(999) Set @s-2='Œ''~‚,ROWS~€ŒŒ~}and~|le~{char(1~\e...

I would start with the basics - you need to...

Jeff,

Using my preferred measure of total_worker_time as reported by sys.dm_exec_query_stats:

Triangular join: 10,218,749µs (~10.2 sec)

Your method:

Receipts running total: 41,015µs (~0.04 sec)

Shipments running total: 240,234µs (~0.24 sec)

Final SELECT: 4,425,781µs (~4.43 sec)

Total...

Ian Scarlett (6/23/2009)

---

You're right, it is an interesting blog, as much for the discussion that follows, which shows the...

Yes, Ian is absolutely right - the information in the article he posted still applies.

Nevertheless, sysprocesses is deprecated - so you could (and probably should) take a bit of time...

Actually, that looks pretty awesome!

I'd like to try it for myself - but has the posted...

Why not try: http://www.dbasupport.com/

/ha!