Whoa! Wait a minute....

Although, if you need to insert values into a table that has an identity column, you can make it possible using IDENTITY_INSERT

SET IDENTITY_INSERT myschma.mytable ON

Just remember to set it to...

If you haven't looked at the execution plan, you really need to. When you don't know what's happening with a query, that should be your first stop.

Also, be very, very...

I'm OK with the xxx part. Sorry that was just meant to designate '*' or 'whatever' or 'fillintheblank.' My only exception was with the Hungarian notation on table names.

I don't know how Access is calling this, but the TSQL command has correct syntax and should work. You might want to schema qualify the tables to ensure that you're...

If the function is embedded in other statements you'll probably need to generate the list of places where it's used and then run the server-side trace as Gail suggested, looking...

Oh please no, not tables named TBxxx. That's just so 1992 (not to mention, very, very Access). Surely, at this point in history, we can simply name a table, or...

Over time the characteristics of the data that makes up the indexes could change. This can result in different execution plans. Based on what you're saying, I think this is...

You do have to define refresh. For example, we do a regular "refresh" where in we move the production database down to our QA environment through a backup and restore....

In regards to the question, it does fill books. I'd take a look at the first two chapters of Itzik Ben-Gan's book, Inside T-SQL Querying. It's a good overview of...

'

Oh absolutely....

Brandie Tarvin (10/12/2010)

Paul White NZ (10/11/2010)

A cheaper room-mate?...

reggie burns-317942 (10/11/2010)

Thanks for all the input.

After running update statics on 5 of the must active tables the queries are running much better, as if it was still in...

I think there's a bit too much fear around GUIDs. In my own experiences, as long as they're not the clustered key, even the sequential ones, you generally won't have...

Also CATCH won't catch syntactical (is that a word) errors, so you may see two errors in fact, but you'll only catch one