ariel_mlk (8/11/2011)

---

It is said...

It does turn blue on my 2k8 R2 express machine.

Like you said BOL is quite useless here!

It's called touch-typing.

You might try it someday :hehe:.

P.S. Totally agree that this should be done at the presentation layer. Just getting tired of saying that ;-).

Any reason why you have varchar(700) for all your columns? That seems a little excessive.

Any reason you're note using the correct datatypes. I can't recommend enough you get...

It doesn't turn blue in 2k5... if it can help.

Add % (3600 * 24). That will wipe out anything above 24 hours. This must be applied when the data is in seconds.

http://www.ssmstoolspack.com/

No argument there Gail, but I'm just calling it as I see it. The filter has some power (33% of the table left) but I've never seen the insert...

I loaded up the plan in sql sentry plan explorer (free) to figure out the biggest queries and it doesn't look real easy (99%+ of each query is wasted on...

Lynn Pettis (8/10/2011)

---

drew.georgopulos (8/10/2011)

---

there's a lot of funk in the sprocs, so i uploaded them too.

im sure the examples' submission could be improved, but i hope they are adequate to...

Are you sure you didn't delete something critical??

C.K.Shaiju (8/11/2011)

---

Ninja, Correct. But for me in the actual script almost 62 batches are there. So I tried Ron's solution. If I get the result in a single exec, it...

Seriously, this is what you need to learn to do, not how to use DTA.

Ninja's_RGR'us (8/10/2011)

---

We can't see the image you posted. You can upload it as an attachement.

Back...

That's what we're here for :-).

Do they have access via AD groups maybe?