Thank you i did change it for the databases.

select *

from sys.sql_modules

inner join sys.servers

on definition like '%' + sys.servers.name + '%';

select *

from sys.sql_modules

inner join sys.databases

on definition like '%' + sys.databases.name +...

Thank you for the reply,

Ok let me kind of get this right,

Used the index usage dmv to figure out what indexes are not used very often.

found few indexes which...

Thank you John 😀

That was indeed not what i expected, the idea is that its an index which i think is not used in the query stats only some amount...

Any DBCC PAGE output on this.

Yes Paul this is what i was after,

2008 test page copied from your output.

Slot 0 Column 3 Offset 0x8 Length 5 Length (physical) 5

z = 200.08

2005 test dbcc...

Thans for the help with the "Alter Huge Table" It was sweet of you to drop a complete test script,

I will do the output for 2008 today night. but...

Paul White (2/21/2010)

---

The reason I asked for details was because the best solution often depends on the details.

All you've done really is ask me to trust you, and that there...

Jeff Moden (2/21/2010)

---

Vinay,

I've not read all of the posts on this thread so let me ask... can the system be down while you do this or not? If so, for...

bhushanvinay (2/21/2010)

---

Sorry for the Very Very Late Reply Paul.

Here we go.

https://connect.microsoft.com/SQLServer/feedback/details/531260/datapage-difference-in-2005-vs-2008

it has all the details on what i have given the SqlServer guys.

I have also attached the test...

Sorry for the Very Very Late Reply Paul.

Here we go.

https://connect.microsoft.com/SQLServer/feedback/details/531260/datapage-difference-in-2005-vs-2008

it has all the details on what i have given the SqlServer guys.

I have also attached the test scripts...

Mando_eg (2/20/2010)

---

Thanks lmu92 for your reply

You put me on the start point, I will keep searching...

I hope if you have some examples to put the links to see it because...

Its is not very uncommen to have a business change in the current business conditions and we get new upstream and downstream systems and Our OLTP needs to cope with...

soulreader7 (2/18/2010)

---

guyz i am having problem in delete a record

i am using northwind database and want to delete custom.

the customer table pk is fk in order table and order tablt...

Foreign keys it realy depends, When you delete...

Well i beg to differ, make sure of what kind...