Of course that forces the entire table to be rewritten every time.  In a typical rebuild, often large parts of the table do not need rewritten because they haven't...

One thing I am disappointed not to be hearing more about is the use of resumable index rebuilds.

I've stopped using reorganize on huge tables where we can't rebuild because...

How many megabytes does the database currently have, how many megabytes to you want it to have, how much FREE SPACE is currently available in the data base, and how...

Hi,

I have a stored proc that takes comma separated list , split it and use it to match against table columns.

e.g.

execute spValidationGet '821780031254,821780031250,1473983,1473903,65644'

I need to implement some input validation...

Just one more thing... The example above spans 29 months.  Is there a good way to separate it out to place three columns for each month within the...

You added OPTION (RECOMPILE) to the code you posted for this thread.  That's what I'm talking about.  The OP said the code was being run thousands of times per day.

I agree with Aunt-Green but it may require you to add an "EXECUTE AS OWNER" to the stored procedure.  "It Depends".

I'm not a SSRS expert. I know enough to get myself in trouble. Anyway, if memory serves, I recall seeing somewhere a blog post, maybe a Microsoft documentation article,...

I have such an issue. I have units, on sale date and also how many weeks the unit is on sale. However, my current formula with DATEDIFF grabs only...

Just one more thing... The example above spans 29 months.  Is there a good way to separate it out to place three columns for each month within the date...

Phil:

Happy to comply, but I'm not sure I know how to do those things.  I will try to figure it out.

Other sites have controls for these things, which I...

I  totally agree that tables scans are bad but adding OPTION(RECOMPILE) to every CATCH-ALL query is a really bad thing.  And, you state the truly obvious when you say anything...

The difference of bad data before and after computers is that bad data in computers can be perpetuated and disseminated so much faster.

And that more people believe the bad...

Hi Jeff,

Good questions Jeff, its in development so not sure exactly what to do with results yet?

If Client has only one row then leave it out of the results...

Heh... nothing could go wrong there, right? 😀