SQLRNNR (2/24/2016)

GilaMonster (2/24/2016)

jasona.work (2/24/2016)

/Me leans back, grabs bucket of popcorn

Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the comments about...

Consider spinning up Azure VMs for your test lab machines. They're not all that expensive, probably cheaper in the long run than buying hardware from home, and if you shut...

INSERT INTO...

That's not what I meant by performance. I asked earlier about index maintenance on part of the table as a reason for you to be doing partitioning, same as data...

If he's using his domain account, then either his account has been granted access, or he's a member of a group that has been granted access. Check the logins, check...

It sounds like you're partitioning with the expectation of performance gains. If you are, don't waste your time. Partitioning is not, in general, done for performance and you don't automatically...

That's not a good design for partitioning, it involves a lot of data movement. It's generally advised that once rows are in a partition, that they not be moved (because...

Anyone? http://www.sqlservercentral.com/Forums/Topic1763388-2799-1.aspx

It's not SQL Server (the UNIQUE gives that away at the least). I don't know what it is, and the OP keeps posting questions here that turn out to...

What database are you using? That is not SQL Server, and since it's not SQL Server, you're unlikely to get help here (this is a Microsoft SQL Server site).

The revised only has three columns in the group by, the original had 5.

Hang on. That's not even SQL Server. What database engine are you using?

This site is specifically for...

I didn't say remove the HAVING line.

The ordinal specification of columns is a really bad idea, hard to read and prone to errors. Go and fix the group by and...

Lol, the vendor is talking garbage.

Log backups truncate transaction logs in full/bulk-logged recovery. Checkpoint truncates the log in simple recovery. If you're in full/bulk-logged and doing regular log backups you...

Start by specifying column names in group by and order by, If, once you've finished doing that there's still an error, post the revised query.

That's not a workaround, that's the correct solution. All tables should be schema-qualified in procedures. You should start...

So the rebuild didn't fix it then.

There are two ways SQL can read an index, first using the IAM, second using the index root page and the next page pointers....