As in, at the OS level check and make sure that the SQL Server executable is the process using that 50% CPU.

Have you done that?

Is SQLServr.exe the process using...

Start with the obvious. Is it SQL Server using the CPU?

If you plan an...

jpandrade (9/12/2016)

---

surely the use of a partitioned table based on something like a month would provide a more efficient response in data retrieval. esp if your queries are based on...

No, and this is not a SQL Server error. It's an error from the client tool, Management Studio. Management Studio's a 32 bit app, so 4 GB memory limit, it...

The upgrade advisor part does, you should still run upgrade advisor and fix anything that breaks, and you absolutely MUST do performance tests on SQL 2016 due to the changes...

Molap (9/27/2013)

---

Backup DatabaseA on SQL2008

Copy the backup to SQL2012

Restore the database with recovery (I can not restore with standby because it needs to go through an upgrade to 2012)

Backup the...

Sure. Google "Sys.dm_db_index_physical_stats", the MSDN documentation page will give you full details of what it returns and what parameters it takes.

Maintenance, yes. Maintenance plans, not so much. Don't use them for index maintenance (they're stupid)

Look up Ola Hallengren's maintenance scripts: http://ola.hallengren.com/

You should have backups (don't forget to clean up old...

Two down, one to go (and a seminar...

Yup, you have to set the next filegroup to be used after each split, even if all the partitions are going to the same filegroup.

It's never been recommended to switch to simple to shrink the log, and if you do that...

Hints apply to the whole query, so recompile, if you need it, would go at the end of the outer query. You can also consider OPTION(OPTIMIZE FOR ...)

Install x64.

The x86 is legacy and there's no good reason to use it any longer. SQL 2016 doesn't even have a x86 version.

There's no guarantee that books will come out. Depends on the publishers, whether they find authors willing to write to the tight deadlines and low payments that exam study books...