niall.baird (7/7/2010)

---

Thanks for the reply, but what I wanted to know is whether 'update' also includes 'insert' and 'delete', especially when you have a trigger (i/u/d) on the table, as...

touchmeknot (7/7/2010)

---

Thanks for the query Bhuvnesh. I ran it and saw that there are records which are not updated.

Adi, you are right, the records are filtered and I am updating...

You should take the recommendation under consideration, but don’t fallow them blindly. As stewartc Already mentioned, it shows the recommendation per query that was used on the server....

Truncate doesn’t activate delete trigger nor instead of delete trigger. Also unlike delete statement regular users don’t have permissions to truncate a table and can not be...

Dates have many formats. There is a default format that is used on the server level, but this can be overwritten by login’s settings and session’s settings. Because...

You have a join and a where clause. Most chances are that both (the join and where criteria) filter the records that should be effected from your update query.

Adi

If a user belongs to both groups, he could do all DML statement on the table. When a user belongs to more then 1 group, he’ll get the...

You can use the openxml function. Below is a code that works with some explanations, but I suggest that you’ll read about in BOL (Books On Line).

declare @xml varchar(500)

declare...

You need to give more information and explain what you need to do. There are many ways to write a query in an XML document (for example open...

I’m guessing that you meant that you want to get the query’s result as an XML document and not the query itself. If I’m correct, then you need to...

You also have to grant him permissions to modify the schema that the table is build on (by using grant alter schema statement). The problem is that you...

You can use a case statement inside sum function to check if you need to count a record according to the value in the flag column. Here is an...

This can not be done this way. You can use dynamic SQL and then run the string that you created. Another way is to create a select query...

You can find which table is referencing a specific table by running sp_help on the specific table. You’ll get lots of information about the table, and the last piece...

imSQrLy (6/13/2010)

---

Thanks for the reply. During the issue i ran 3 tlog backps. The log still continued to grow. So it was acting as if a transaction was keeping the...