shekihan (11/26/2008)

---

By putting small table first you do assure that if the Query Optimizer (not a Query Analyzer of course) for some reason fails and decides to go your way...

No. It will enable page locks for the index specified in the alter index statement

what...

ALTER INDEX < Index name > ON < Table Name >

SET (

ALLOW_PAGE_LOCKS = ON

)

GO

Also you may want to revise that script. Both showconting...

Please don't cross post. It just wastes people's time and fragments replies.

Besides, I've already answered your post over here: http://www.sqlservercentral.com/Forums/Topic609456-147-1.aspx

No more replies to this thread please.

v.reddy (11/26/2008)

---

Are you sure Trace will show satements before execution?

You're welcome to check books online. All of the events are there along with their descriptions.

i belive trace will show...

No. Just try not to have multiple constraints/unique indexes on the column(s) referenced by the key.

You need to concatenate the variables into the string (beware SQL injection). They way your dynamic SQL is currently written, SQL's looking for two table variables, called @TableInput and @TableOutput...

I'm not a fan of dynamic SQL either, but it's the only practical way to get this working with more than around 3 parameters. With 3 or less, you can...

All of the foreign keys that the query return reference the Names table. Try dropping them.

It's odd, they should be referencing the pk, not the unique index.

I'm sorry if the support here isn't up to your expectations.

As I said in...

You already have the query. All you need to do is create the table to match and then convert the select to an insert. All that required is adding the...

Nope. It performs like a dog on SQL...

Using nolock doesn't just allow dirty data. It essentially says to SQL that...

Hmmm. Odd. Did you create that through the management studio GUI? If so, what options did you select?

What do the following return?

select name, type_desc from sys.objects

where object_id = OBJECT_ID('NAMES') OR...

Create the table, then do an insert into... select ... with that query as the select. If you want it to refresh ever day, then you'll need to set up...