The question I would ask myself in order to answer your question, what is the most common access path? What will be used more often than anything else to query...

Personally, I'd suggest using a tool that works well with scripts and source control. The three that come to mind are DBGhost, in which I have no experience, Red Gate...

How about disappointed. I was hoping for more. I guess I've been spoiled by Red Gate's SQL Prompt.

Are you kidding, thank you. I hate posting bad information.

I must be regurgitating bad stuff again. Sorry. It's when it's a delimited list that it behaves like that, right?

However, I did a little looking around IN clauses don't work...

It depends...

IN basically is an OR statement. It's one of those hidden RBAR (row-by-agonizing-row, TM: Jeff Moden) operations because it's going to check each row of the IN clause against...

ruyfigueiredo (9/30/2008)

---

The problem is that the log files increase a lot.

I have an database with 250MB and a Log File with 24GB.

After i reconfigure the Autogrowth i have to made...

On top of what these guys have very correctly told you, put a limit on the growth of the database so that it won't fill the drive. A full file...

You'll have to drop all foreign key constraints against the table first by using

ALTER TABLE OtherTableName DROP CONSTRAINT ConstraintName against all the related tables. Then you can use ALTER...

You have to have a way to differentiate which value belongs with which row. I know this is probably not exactly what you're looking for, but something like this is...

With these estimated plans, there's almost no difference. Some of the estimated costs are slightly different and the location of the table scan of 'RO' changes between the two, but...

I guess I don't understand the question. The storage engine does the data retrieval, including sorting and aggregating the data, as you said. What is the concern with where this...

The proc doesn't look so complicated that a RECOMPILE would take six seconds... Hmmm.... You may have to go to old-fashioned tuning. What do the execution plans look like?

It sounds like parameter sniffing. Try adding WITH RECOMPILE to the procedure and then run it again. That won't help tune it, but it will prevent you getting a bad...

If it's ASAP, look it up in Books Online. That's what the documentation is for.

It really depends on whether or not you're calling a scalar or table valued function.

A scalar...