Absolutely NOT gail. i respect...

Not only Where BUT group by, order by , JOIN's ON...

The specialist is a person who knows everything about something but nothing about anything else.

i havent got what you actually needed and asked ? can you post your requirement with sample data along with desired output. see "we cant see what you see"

PLease note.4 years old thread.

sqlnes (1/17/2013)

---

What you can before explanting to them, test the code with the suggestion and...

From BOL If target_size is specified, DBCC SHRINKFILE tries to shrink the file to the specified...

prakash.kumar3669 (1/17/2013)

---

In my table (large one) there is mainly three select queries:

1) select * from Product where productid=101

Here productid is primary key so it is clustered index, so no problem...

Place your (

SELECT a, b FROM KEY_TABLE kt JOIN......

UNION

SELECT a, b FROM KEY_TABLE kt JOIN......

UNION

SELECT a, b FROM KEY_TABLE kt JOIN......

) T0

code in temp table and add appropraite...

this is link http://support.microsoft.com/kb/2072493 , is it production server ? if ues then DOnt do this without proper discussion

davidwarner (1/16/2013)

---

Now i added the convert(varchar(2),datepart(mi,getdate())) part which does give me the minutes into the filename. but if the backup runs on the hour the file will get called DBNAMELog_13.bak...

Unsed indexes/Sp/tables ...this task seems endless and startless for me.

Why ?

because how will and Who will decide which indexes/tables are UNUSED. how will you assure DBA, DEV ...

First you need to perform 1st then monthly job/manual...

shohelr2003 (1/16/2013)

---

If I execute an insert query into linked server, it works. But when I use trigger to execute an insert query into linked server, it fails and generates the...

sqlnes (1/16/2013)

---

It's weird, when I tried it today, it has back to the "correct" plan without set FORCEPLAN. it has been running fine now. I just wondering now would it...