Also, suggest you post the Query Plan XML instead, which has better info for us.

There's a Connect item on this open, and the feedback from Microsoft says there are no advantages and potential disadvantages, but it's in there for backwards compatibility. Personally I'm not...

Please post the query plans for both.

But that cannot...

Jeff Moden (4/25/2008)

---

rbarryyoung (4/24/2008)

---

Not a problem... knowing you, I thought you may have come up with some new bit of "rocket science" using the Tally table and was too busy...

IceDread (4/24/2008)

---

Hey

Exactly where in your lawbook in usa does it state that you have to pay taxes?

I heard a rumor that it is actually not included in your law and...

because it gets its values from a table and table values can be changed.

I am not sure at this point what you can do about it.

Ah, well, that is a diferent problem. I think that you might be able...

I've been out on a job. Sorry for throwing this out there and running, but I hoped it could get you started...

Jeff Moden (4/24/2008)

---

Barry, would you explain why you...

Like this:

(convert(char(4),dbo.fn_GetTLB()))

Here's something to get you started:

Select S.session_id, S.host_name, S.program_Name, S.Login_name, R.request_id

, L.*

, r.start_time, r.status, r.Command, r.database_id, R.blocking_session_id, R.wait_type, R.wait_time

From sys.dm_tran_locks L

Join sys.dm_exec_sessions S on L.request_session_id = S.session_id

...

GROUP BY .. WITH ROLLUP can usually get you there.

sunshine (4/23/2008)

---

for SQL Server 2005 when you click on jobs and see all the jobs on the summary Tab on the right side, you can highligt all jobs and script...

Why not just do this?:

Select

SUM(Cast(DATALENGTH(C1) as BigInt)) as [C1]

, SUM(Cast(DATALENGTH(C2) as BigInt)) as [C2]

, SUM(Cast(DATALENGTH(C3) as BigInt)) as [C3]

, SUM(Cast(DATALENGTH(C4) as BigInt)) as [C4]

, SUM(Cast(DATALENGTH(C5) as BigInt)) as...

In excel, copy your data, then in a new sheet, use Paste, Transpose to rotate your data.

From there, you should be able to get it into SQL Server and use...