You can get some from queries. For example, the dynamic management view sys.dm_os_performance_counters contains the buffer cache hit ratio.

Sorry, I stated that badly. I'm not aware of any exceptions.

The one thing that might be an exception would be that the SELECT statement can only return the same number...

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 ....