GilaMonster (5/7/2010)

---

100%. SQL tries to run a query as fast as possible, so it will try to use a CPU to 100% for the duration of the query. If it...

paul.knibbs (5/7/2010)

---

Gianluca Sartori (5/3/2010)

I was confused too, Grant. I was sure MSDE 2000 had a 5 concurrent connections limit, but, after searching a bit, I found out that Express Editions...

2cams, I'm surprised that you didn't set up any of the suggested monitoring methods and you keep on guessing. I don't think you'll go far this way.

Just my personal...

So, what is your question again?

Also profiler can give you that information.

This should do the trick for you:

DECLARE @TestTable TABLE (

SalesOrderId int,

CarrierTrackingNumber varchar(20),

ProductId int

)

INSERT INTO @TestTable

SELECT 43659, '4911-403C-98', 776

UNION ALL...

SET STATISTICS TIME ON

Paul White NZ (5/6/2010)

---

Jeff Moden (5/6/2010)

---

I'm not sure where you found the time to study that but, like Seth said, I learn something new every day. I didn't know...

Rebuilding the clustered index into the partition scheme will move the whole table data into the partition scheme.

To keep nonclustered indexes aligned, they also have to be partitioned, at least...

I don't answer QotD at all.

Every now and then, when I'm bored, I answer some questions. And usually got them wrong. 😛

Congrats! It's a long way to 8000 points!

Thank you...

Gianluca Sartori (5/6/2010)

---

I could try to attach my whole SQL knowledge to that thread, it shouldn't exceed...

I could try to attach my whole SQL knowledge to that thread, it shouldn't exceed 3 Mb....

Yes, it will run fine, but will never use parallel plans, because only one CPU will be used.

No, unfortunately order is not guaranteed when assigning to variables.

I couldn't believe it when I first heard of it, but I can confirm it is so.