I got this wrong as well. I've seen both STATIC & FAST_FORWARD work better in different circumstances. "It Depends" should have been the right answer on this one.

Nope.

You can use SSIS to do the work for you, but the analysis is up to you.

The only way I know of will hurt your performance. You can put FAST 1 hint on the query and it will start returning data immediately. It will however, really...

Gail is on the money here, totally.

Instead of trying to avoid having multiple queries, accept the fact that you will have multiple queries and then get some code to generate...

Posting the execution plan would help in the evaluation. Not seeing your structure and only seeing a query, we're all limited to making guesses.

I can't honestly say that I wouldn't have hit the guy. Nice exercise in restraint.

9 months at a start-up run by Harvard grads who's operating phrase was "Think Outside The Box." This extended to every single part of the company. One of the more...

It depends on the context that it's running under. If you're running it in a query window, it probably will return NULL.

Try this:

CREATE PROCEDURE ProcName

AS

SELECT OBJECT_NAME(@@PROCID);

GO

EXEC [ProcName];

You should see 'ProcName'...

SELECT OBJECT_NAME(@@PROCID);

Thanks for reminding me. That helped.

🙁

Crap! That was seven years ago.

Like everyone else, I'd suggest starting small. The best way I found to convince someone of the need to normalize was to find data that was messed up and by...

I got that old feeling last year when Joey Ramone died... Now it's starting to feel like a conspiracy. I wasn't really a fan of Aspirin, but the others... This...

I've been very happy with ER/Studio, but we mainly use it for documentation. All the management stuff that comes with it haven't worked out for us.

Actually no, it's not that weird. The optimizer and the query engine are pretty amazing pieces of engineering. They're able to identify that you only need a single row returned...

The key problem is, desiging, building and deploying software is still not an act of engineering like building a car, a toaster or a bridge. As Steve pointed out in...