Just play with it a bit and you'll understand. Bellow is a small script that creates 2 tables and inserts 2 records for each table. All you have...

And happy Hanukkahfor some of us:-)

You can do an update with inner join. This way you’ll be able to get the value from the lookup table. In your update statement you should use...

One way of doing it is to run a query on all query plans that are in the cache. Here is one version that can be used. Of...

GilaMonster (12/22/2008)

---

If you answered all the questions...

Any reason that you don't want us to know if you checked for blocking as I asked you before?

Adi

subha.v (12/22/2008)

---

Hi All,

I have run the query like

Select ColB,ColC from table1 where ColD= 123.

It takes nearly 30 min to finish the execution.

In this table ColD have a non-clustered index. And...

Since the trigger is part of the transaction, and you can not backup a database inside a transaction, you...

Mad-Dog (12/21/2008)

---

I'm responsible for lots of SQL Server that have an ERP Program and this ERP program every few days creating new DB (companies) in the SQL.

i don't want to...

You can do it by running alter database statement. You can look at the script .that I’ve added as an example. Unfortunately you'll have to restart the service....

I also couldn't find anything to back me up or contradict me, so I decided to do a small test. I created a new database. Altered it to...

dhanasekar.palani (12/18/2008)

---

This table has millions of record. so when i am using a case statement in the update statement it takes time can this be written in a more optimized...

I’m not from an English speaking...

Is this is your real trigger? Your trigger will send the results of the DBCC INPUTBUFFER to the client, but it won't save the data into a table. ...

ksprashanths (12/17/2008)

---

I created a log file that is intended to capture the sql statement being used to insert/ update/delete a record in a table (see the attached code snippet) but...