srik.kotte (12/28/2011)

---

select cal.datevalue

,datename(DW,cal.datevalue) day_of_week

,isnull(flowon.sum_flow_on,0) flow_on

,isnull(flowend.sum_flow_end,0) flow_off

...

Have you checked the disk(s) where tempdb is located to see if the disk itself is full? That is the first thing I would check if I got this...

Based on what you have stated your coworker hasn't granted you access to his system to access the file. Also, you have another problem with your restore command, happens...

What happens if you use the CTE in an EXISTS clause in the WHERE clause like you are using the temporary table?

They are a quick way of setting up backups and maintenance routines, but they have limitations.

Before we can really help, however, we need to know how your current processes are...

SequelSurfer (12/27/2011)

---

Well done Lynn, I had to settle for taking the Consolation Cup back across the water. If only I hadn't finished the season on 4 straight losses, ah well,...

Would help if you posted the query and the two actual execution plans.

SQLDCH (12/27/2011)

---

Congrats to the SQL Bolts!

Lynn fought her way to a wild card and never looked back, defeating Ditka and the regular season dominating Orange Engineers en route the Super...

Looks like the SQL Bolts are now the 2011 SSC Fantasy Football League Champions.

It has been a heck of a season. Thank you all for participating and I look forward...

We'll have to wait and see what happens tonight. You never know what may happen. The match up was really close through Saturday.

Championship game is close. Both teams have one player still active but there is a 10 point differential between SQL Bolts and SSC Steelers and SQL Bolts are leading!

This...

Glad to hear this, but it is also important for this query as well. I'd help right now, but...

I have to agree with Jeff. I feel like you are preaching to the choir here. Many of us know that our immediate supervisor and/or manager is actually...

One thing that will really help you get good answers quickly is to follow the instructions in the first article you will find referenced below in my signature block. ...

LutzM (9/2/2011)

---

Depending on the percentage of rows to delete it might be more effcient to copy the remaining rows into a new table and rename it. It depends...

As an alternative...