Well, my initial response would be, no, poor choice. On further reflection, I'll fall back on the usual answer, it depends.

Are you using natural keys in your table design...

Nah, they were just working on their server and typed into the wrong window. I do the same thing all the time. In fact, that explains most of my posts.

:w00t:

You have 9000 rows for the county of Austin and you're filtering by the county of Austin... You're going to get a table scan or index scan no matter what...

Much more than compilation. Functions come in two basic flavors, table valued & scalar valued. Scalar is used for a calculation, table valued are sort of like parameterized views. Only...

No way, you're not wrong. It's just a question of trade-offs. Does having the "dead" rows affect general performance of the system? No? Then you have to weigh whether or...

Mahesh beat me to it.

Once you realize that the INSERT...SELECT mechanism is just a SELECT statement, pretty much anything possible within the SELECT statement can be used with the INSERT...

Try

SELECT * FROM pkd...tbl

Don't forget to ask for the electrified razor wire too.

I work for a large organization. We have a few rogues who still think that Dev/QA/Staging are all wrapped up in...

There is nothing I hate worse than googling a question and finding the place I posted it to as the first response. It never bodes well for getting a good...

The parameter sniffing is pretty likely. You might also have different ANSI settings from your different connections. That's worth checking as well.

Unless you've got a very good reason not to, you should make sure there is a clustered index on the table. It's really hard to tell you which column not...

The common language runtime (CLR) comes with SQL Server 2008 and can be enabled. No extra installs for .NET are necessary.

Is that what you were looking for?

You can see this in the Books Online:

INSERT INTO schema.table (columnlist)

SELECT ...

FROM ...

WHERE ....

Selecting from a table is different than selecting from a view and they shouldn't really be compared. Selecting from a view is basically selecting from a query that selects from...

I haven't heard that term before either.

We have implicit and explicit data conversions... Not helpful, but at least those words are used. An implicit procedure would be one that occurs...