select UID, ReferenceNumber, Type

FROM myTable

WHERE ReferenceNumber NOT LIKE 'TR%' AND

Type = 1

Is thi squery giving different results than yours one?

:w00t:

No performance issue. This is right approch. You can keep the linked server name same even if I need to rename REALDATABASE. You do not need to change the simple...

Foreign key constraint are to maintain the data integrity.

If your database is highly transacted, this integrity check may slow in performance. If you are managing the integrity properly while inserting...

There is column filter - you can filter out the trace for particular session id- SPID.

Check the check box - exclude rows that do not contain values.

Understand the select query requirement and think of following options-

1. Partitioning the table

2. Identify and Adding non clustered indexes

3. Checking the query plan to see indexes are being used...

Database may go into recovery while restore. Never seen while backing up. :hehe: Please share the command

so what is the problem with this query?

WHy are doing below step ?

I've tried setting the recovery mode to Full, doing a log backup, DBCC shrinkfile (2,0,TRUNCATEONLY) and then putting it to simple mode, same thing.

set recovery...

please help the guys here with good amount of details so that they can help you out.

Why are converting varchar to Ntext ?

please search for basics of normalization on internet and read it.

u can think of the method which will have less impact and fast solution. 😎

Please refer to Security audit events in profile.

Not sure how feasible is it.

http://msdn.microsoft.com/en-us/library/ms191148.aspx

"Audit Schema Object GDR Event Class"

Sorry!! its working- giving all statements in one line.

why u want to sort when u want to delete all jobs?

This code is not having loop to alter all the tables you want.

Please check the code logic.

Alter statement should be fired for each table