GilaMonster (10/14/2009)

---

I haz two tables and no question

http://www.sqlservercentral.com/Forums/Topic803081-338-1.aspx

Some else can have the pleasure of this one. I'm going to spend an hour trying to conquer the galaxy, then going to...

forum member (10/14/2009)

---

Hi,

I need help with sql query

I have bookings in one table and bookingstates in another table which contains states related to booking

Booking Table Schema ...

Yeah, what Gail said.

Seriously though, she's right. There was missing index information in the execution plan, it was moving scads of data around to retrieve 600 rows, you're getting a...

Slick84 (10/14/2009)

---

Grant,

Thank you for the information. Can you possibly point me to the right direction for updating stats on the tables as well as more information for "Full Scans". I...

You're getting a scan on the tblProductSizeWidthColor table, from the name alone, I think you've violated some design principals, which is reading, if I counted the digits correctly 332 million...

Sorry. It sounds like to do what you want, you need to make a change to the code.

Yeah. This is untested psuedo-code, but it illustrates what you do:

CREATE PROCEDURE A

(@p1 int)

AS

EXEC B @p2 = @p1 OUTPUT;

SELECT @p1;

GO

CREATE PROCEDURE B

(@p2 int OUTPUT)

SET @p2 = 42;

GO

You can look up...

s ss (10/14/2009)

---

Bob Hovious 24601 (10/14/2009)

This is why people who waste our time are irritating, as are the people who insist that their problems are urgent and somehow more deserving...

In 2008 you could make a table variable and pass that between stored procedures, but you'd probably still need to make it an output parameter to get it back out...

Can you post the execution plans?

Excellent. Now tell me what color your parachute is and you're hired.

An output parameter from Sp2 would be available within sp1. Have you tried that?

It's possible to do a cascade delete, but to do a cascade update, not so much. You're not actually removing the address value, you're changing which one the customer points...

Can you do it? Yes. Should you do it?

You're running into the same situation that lots and lots of people have run into with clustering. They're trying to have it...

However large the log file is, it is. There's nothing wrong with a large file. But... it does raise the concern that you're logging operations that should not be, that...