Don't spare him/her, not even a little bit.

What you might be seeing is the Business Intelligence Design Studio (BIDS), which is basically all the tools needed to create SSIS packages and SSAS cubes and is run through...

Have you tried setting the procedure to run using sp_procoption? That will enable a procedure to run when SQL Server starts up. You can also schedule jobs to run when...

Dan.Humphries (4/22/2010)

---

With all respect

How would writing 20 Million rows to a temp table not be part of the problem even with the for-mentioned query problems. I would be very surprised...

CirquedeSQLeil (4/22/2010)

---

Alvin Ramard (4/22/2010)

---

CirquedeSQLeil (4/22/2010)

---

Grant Fritchey (4/22/2010)

---

Alvin Ramard (4/22/2010)

---

You've got things on your property you want to get rid of? Gail did a great job of that this morning....

Temp table or not, this code:

((LTRIM(RTRIM(lt.name))

Is going to kill your performance. It's going to prevent any indexes on the tables from being used and you'll see nothing but table...

yoacer (4/22/2010)

---

Hi Atif,

I need to find a different solution Dynamic SQL is not what I want, I want another kind of solution even if I need to create a filter...

Alvin Ramard (4/22/2010)

---

You've got things on your property you want to get rid of? Gail did a great job of that this morning. It would work as well...

Gianluca Sartori (4/22/2010)

---

Jack Corbett (4/22/2010)

---

Gianluca Sartori (4/21/2010)

---

I've seen even worse things in my app (Visual Basic):

Public const SC AS String = "'" 'Yes, you got it right, it's...

Personally, I shy away from it in almost all situations. Alternatives are to enable snapshot isolation, so that you can read rows while the data is being manipulated. Or, if...

White phosphorous? I'm not sure, that could be overkill.

Joy Smith San (4/22/2010)

---

Thanks for the quick response.

But for SQL Server 2005 the executable is "SQLWB.EXE" no ?

To really understand performance issues, you need to...

jcrawf02 (4/22/2010)

---

So what would you do if everything died? Fix what you know of and wait for the users to yell about whatever you didn't know of?

Anyway, if it's...

Arjun Sivadasan (4/22/2010)

---

Thanks Grant and Kshitij.

@Grant: What do you mean by missing rows? Rows that are there in the dataset but not present in database as a result of...

trivedi.nikesh (4/22/2010)

---

Hi All,

Last week we designed a query to generate a report. Initially this query was running fine fetching all records in 10 sec, but this week it is running...