It's going to allocate an extent first then put pages there, but why does it matter?

And just to reinforce what the others have said, read this blog post[/url].

First, let's note, the DTA is notorious for offering bad advice, so be very careful in implementing it's suggestions. Test your stuff very carefully.

The best way to run the DTA...

No, SQL Server 2012 itself is brand spanking new. It was just released last week. There aren't any updates yet. I'm talking about the client DLLs for connecting to SQL...

Hmmm.... May be a driver issue on the web server? Hard to know. That looks like an error we used to get in 2008r2 that was related to bad drivers...

If it has been recompiled, you're getting the new plan. That's what gets stored in cache.

Lowell (4/11/2012)

---

since there is no WHERE statement, there's not really much to tune, right? that'll be a full table scan regardless of the indexing, I'm thinking.

returning 4.9 million rows will...

Not seeing where the $NewSales is coming from, maybe that's it. It's the values passed or the WHERE clause. One or the other. The T-SQL syntax looks proper.

I can't see how the $Variables are being generated within the code, but the basic UPDATE syntax looks right. So what do you mean by "does not work"?

Hard to know without a lot more information. That general error type has been around forever. It's not unique to 2012. Do you have other information? Is it happening at...

SQL Packager is an option, but you could just build a batch command using SQLCMD.EXE. It won't be an executable, but a batch file will work the same way. Another...

Hints are not what's needed. In fact, I'd drop the FAST(1000) hint to start with. That's going to generate a skewed execution plan if you're returning more than 1000 rows....

sqlnaive (4/11/2012)

---

Hi Grant. As per my understanding the 'with recompile' option to be used only when there are different range of parameters passed to the procedure. As long as there...

I haven't tried setting up an alert, but I have set up monitoring using some of the DMOs available. This Book Online entry lays out a bunch of the options.

You down-graded from 2008 to 2005? You can't move the time column because they don't exist in 2005. You'll have to store it as a string, a varchar, or you'll...