No need and possibly even harmful. Rebuilding indexes...

See this for some tricks on working with datetime values

http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/

Great. Now which of those queries is the slow one?

From management studio you can script table and you can script indexes. Don't think they can be done as one step....

darth.pathos (9/1/2009)

---

As far as the Network Traffic, would this (albeit minimal) increase not have an overall impact on the application, especially as it would appear the developers have written all...

Only the ones that are execution plans. If you take a quick look at each, it should be easy to see which are execution plans and which are real data.

Not datepart, but try dateadd.

p.s. the way you've written those queries is highly inefficient. By putting a function on the column, you're forcing a table scan, SQL cannot use indexes...

You may still need some extra locking, depending how you do the insert.

Bytes sent and bytes received is just the network traffic. No indication at all which query is more optimal on the server. To investigate that, use the execution plan and...

Nah. It confuses lots of people.

http://www.sqlskills.com/blogs/paul/2007/10/25/DebunkingACoupleOfMythsAroundFullDatabaseBackups.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/More-on-how-much-transaction-log-a-full-backup-includes.aspx

Actually,...

From the info that you've given us, all I can suggest is to add indexes to support the queries. If you want more specific help than that, please post the...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Mike Stuart (9/1/2009)

---

Back to the original statement of "... you shouldn't have installed all that for an evaluation edition" - why not? Isn't that why we have evaluation editions:...

Not that I'm aware of.

If you're just interested in which were backed up and which were not, query the backup history tables in MSDB. There's a few of them, backupset...

Go to the job step, the advanced options. There's an option there to log to a file. Use that, it'll log the full error message.

All it's saying is that the server uses a NUMA architecture (non-uniform memory access) and it's showing you how the NUMA nodes are configured. When the server uses the NUMA...