Jeff Moden (4/1/2008)

---

Karl,

Would you be kind enough to post your cursor code? I'd like to take a peek at it becauase I think I've only written 2 in...

Thank you very much - that's very helpful.

Interestingly, I did a simple test with about 1500 rows (just concatenating names from sys.objects) and I managed to get...

Jeff Moden (4/1/2008)

---

SQLZ (4/1/2008)

---

Say I want to run an ALTER INDEX ALL ON table_name REORGANIZE;

command on all tables that are more than 10% fragmented.

I know I can use sys.dm_db_index_physical_stats to...

shine.mm (4/1/2008)

---

HI All,

I would like to change the default schema details of all the logins created

Could yoy please specify how do i find out the schema details

and also i would...

Have a look at using the @query_result_separator and using a comma...

Hi Patrick,

I'm not sure you'd need to use a loop. Would a cross join not work?

select sid, pid, mid

from testA, TestC

rbarryyoung (4/1/2008)

---

SQLZ (4/1/2008)

---

Say I want to run an ALTER INDEX ALL ON table_name REORGANIZE; command on all tables that are more than 10% fragmented.

I know I can use sys.dm_db_index_physical_stats to...

Kathleen,

I meant to mention this in one of my other posts. If you're making a lot of schema changes then that could be a problem as far as the...

Jeff Moden (3/31/2008)

---

Buxton69 (3/31/2008)

---

Could you point me toward a good resource for examples of code without using cursors, I have some examples where you load a select statement into a...

baumgaertner (3/31/2008)

---

Thank you for you answer, Karl.

But I do not want to rename the table and then insert the data to the new table.

When you have big tables this approach...

Buxton69 (3/31/2008)

---

Would any of you use the undocumented SPs sp_MSforeachdb or sp_MSforeachtable to do the iteration for them if the situation suited using these? Anyone know how these work,...

I've got to be honest and say I'm still not sure on what you need...

Ramesh (3/31/2008)

---

While running my query i will get 'N' num of rows, and i dont know in which rows are containing the [PO]# in the LogMessage column..

How to find where...

What network properties do you want to see?

Hi Raf,

That's a shame because it was my best guess as to what was going wrong. Just to be sure, I wouldn't use sp_helpsort to confirm the collation. ...