This is an sql site. C# site search will get you an answer in 30 seconds.

Left join to both code lookups.

Then use coalesce in the select.

--Borrowed from the activity monitor

SELECT

[Session ID] = s.session_id,

[User Process] = CONVERT(CHAR(1), s.is_user_process),

[Login] ...

I have water in my pool, do I have enough?

Only you can monitor that and answer this.

Don't mess with it unless you're sure this is a 1 time occurence.

Tempdb just needs space to process stuff and there's nothing you can do except give him the space.

A...

Make room on the drive so it can grow.

See if you have long pending opened tran you can close (might be you)

Add a file on another group.

See if you have...

Check your zoom in IE. That setting is tab specific, not application level.

Back to step 0.

Why do you think you need to use an indexed view?

Brandie Tarvin (9/7/2011)

---

I've already checked "fails for me too" on this. But give me a few to finish catching up at the office and I'll see if I can get...

What are they doing in Sybase that is so magic that no more space is required for loging?

I'd track how you populate the createdby and updatedby columns and use the...

that's pretty much irrelevant. I'd say ± 2 GB depending on features.

The real space problem is how much space you need for your dbs. Which in my experience...

I'd love it if 1-2 of you guys could rerun the test with 2 modification. Set implicit transactions OFF and put begin tran before the first select into.

PSS is...

I personnally use backup history for this. Of course I do fulls only once per day so it might not be what you need.

It's safe to run the backup during prod. The main side effect is that your response time to queries might be slower (couple ms in all systems I've tried,...

Brandie Tarvin (9/7/2011)

---

GilaMonster (9/7/2011)

---

Agreed. I made a few snide replies to his more vicious posts...