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...

Assuming the question is directed to me.

I do the daily tlog daily because we are on full rather than simple (didn't want to make thing even worse) and I want...

Oh crap, I know I should have checked that one myself... never take the word of someone online when you think they're wrong! :w00t:

Looks like we misunderstood each other...

His reply will be known next week because we're both heading out for the week-end now.

Thanks again and keep 'em coming!