Not a problem.

Another option, and it might not work for you, is to pass these values in a comma delimited format and then join against that single variable using a...

. (7/22/2009)

---

Okay, gang, I'm trying a new approach to lazy posters. Experiment #1 is found here.

Steve, if you would prefer I didn't go forward with...

It could work, but you're going to run into a lot of issues, possibly. Do you have source control available? If not, get something like Microsoft's Team Foundation Server or...

Are there functions in the WHERE clause?

If you want to view the cause of a lock, query sys.dm__tran_locks.

BTW, This is a cross-post. I answered the same question over here:

http://www.sqlservercentral.com/Forums/Topic757335-145-1.aspx

Please don't post the same question in multiple locations. It really diffuses the conversation and duplicates effort.

The one good source I know of is Allen White's blog. He's also published a couple of articles over at Simple Talk. If you find anything else good, let me...

Yeah, estimated plans are seldom terribly helpful. It's basically the same plan though. It really looks like, based on what you provided, SQL Server is doing the right thing. An...

That's a slightly odd looking plan. It doesn't have a SELECT statement or a query or any of the meta data about the plan in the XML. How did you...

Kit G (7/22/2009)

---

Grant Fritchey (7/22/2009)

---

I've played Paranoia a couple of times where we couldn't get out of the mission briefing room. Everyone kept shooting, stabbing, kicking each other to death,...

Ah, right. ALZDBA answered it. You're not forcing the backup, you're forcing the restore, but not even that really, you're just kicking all the users off the database.

Kit G (7/22/2009)

---

Paranoia... what a beautiful game. The only game where you start off with SIX copies of your character! You have clones that get activated when you...

Tara (7/22/2009)

---

Grant

I think your point make sense to me but would like to know about how it works.

As you said we do have a column " Cdate " which is...

You need to use the SQL Agent. It's right there in Management Studio. It runs as a service on the machine with SQL Server. Right click on the Jobs folder...

It's hard to make suggestions without seeing the query and an actual execution plan. Can you post those? Also, in case people need to experiment it's useful to post the...