Ed,

Have a look at http://www.microsoft.com/technet/prodtechnol/sql/2005/frcqupln.mspx

But, before you read...

Did you compare the execution plans? If that is the issue, you could copy the execution plan from the fast executing pre-service pack version.

Regards,

Andras

Vika (10/5/2007)

---

Andras,

I read that. I run rebuid for the index that was recommended to be rebuilt and it didn't help, it still suggested me to rebuild it in the reports....

Chirag is right, you need to get this information by querying the system views. The result you are getting is the result of a query. Whether a returned column is...

Hi Yoav,

there are some differences between 2000 and 2005 compatibility mode 80, among these are some of the system views that were previously system tables. Some of their fields are...

You need to log on and have permissions to Attendee Live 2007 parts.

Assuming you are logged on (www.sqlpass.org) and have permissions, the url is

https://www.sqlpass.org/summit/2007/Downloads/Forms/AllItems.aspx

Regards,

Andras

If you want to have a local database you will need to install SQL Server. You can download SQL Server Express for free, but it is restricted. If you have...

To demonstrate the exact problem (the solution is in my previous answer) just see what this results:

select 'this will be converted to bigint and will fail' + cast ('2' as...

you are trying to concatenate a string (.... ' AND ErrorId <> ') and something you convert to bigint. What is happening above, is that the first string is actually...

...

i thought that in relationship of databased, when ever we insert data in first table, the foreign key in the second table will get the same data. But the...

Vika (10/4/2007)

---

Physical statistics for all indexes, Indexes, Operation recommended. It says reorganized or rebuild. Does it mean indexes should be reorganized or rebuild? Why should they and what would happen...

You may want to look at the Service Broker. It will allow you to send the inserted data to a queue which you can process sequentially and transactionally. This would...

sivicako (10/5/2007)

---

Hi!

When a new record is added to a table, can a trigger create a text file for the new record? Is this possible? If not, is there some other...

The idea to use a persisted computed column is indeed nice. Concerning whether the row is moved to another partition if you update the column on which the computed column...

ishaan99 (10/4/2007)

---

I am trying to use sp_MSforeachtable to show what sp_help shows up. I need on every single user table on a database. Can anyone please help me how...