Thanks for the report muthukkumaran, but as long as you keep the link in your post, they still get what they want!!

TIA for the edit.

Wow you attract weird managers in your life!!!

never had that issue in 10 years.

Yup.

Of course, but not 40 hours / week.!

we need the actual .sqlplan file!

testing something.

sqlchanakya (3/21/2011)

---

DOP setting is 4. We do not wanna set to 1 as am not finding any other occurances. Even I find something, I will try to make not to...

And this the original thread that started the connect ticket.

http://www.sqlservercentral.com/Forums/Topic607455-145-1.aspx

intrope (3/21/2011)

---

You can also do this with two variables with one SELECT:

DECLARE @t varchar(max)

DECLARE @s-2 varchar(1)

SET @t = ''

SET @s-2 = ''

SELECT @t += @s-2 + Tag, @s-2 = ','...

Thanks for the info.

I ask because I support Ms Dynamics Nav which as you may know is extremely rbar, so this info can come in handy in the future.

Thanks for...

Yous guys are made for each other... you'd make a nice couple!! 😀

GilaMonster (3/21/2011)

---

Ninja's_RGR'us (3/21/2011)

---

Grant Fritchey (3/21/2011)

---

If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that...

Grant Fritchey (3/21/2011)

---

If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that is causing...

Plan B.

Script the table with all objects, constraints, triggers, etc.

Drop it and recreate it.

Vegard Hagen (3/18/2011)

---

Basically, if you want to do log backups at all, you'll want to do them fairly often!

Doing so only once a day is both a lot riskier and...