Don't pull the indexes. That would be bad.

I'm with the others, putting an index on the FKs is a good idea. In fact, you might want to try changing the...

Just to narrow it down for you a bit, memory management is primarily predicated on the OS, not SQL Server. So a 32-bit OS with a 64-bit SQL server, the...

No, that's almost the opposite of what I see in most cases. Usually PLE is a constantly increasing value which suddenly drops to near zero once a day or once...

It's not just the sorts though. You're scanning hundreds of millions of rows. The sorts are making things worse, yes, but the sorts are setting you up for merge joins,...

Timeouts might be from blocking during the rollback of transactions that were selected as a victim of deadlocks, but I'm with Gail, it's likely just standard blocking. Deadlocks are both...

Validate the settings are basically the same between both servers. Enable the 'Optimize for Ad Hoc Workloads' option on your server. That frequently helps ORM apps. Possibly look at using...

Actually, if you look up,...

Daxesh Patel (6/13/2012)

---

if table has a large size data, I think SELECT * INTO should be avoided due to its limitations.

I would create New table ahead of time with partitions...

DZN61 (6/13/2012)

---

Tks Grant for your answer.

My table value functions (both inline and multistatements) returns about 500 rows...

For what I have understood from your statement is this is not foreseen for...

Whoa! That's cool. You have 9.9 billion rows being aggregated down to 12. I think you need to put filters in place, a WHERE clause, to limit the number of...

The 2000 databases will have to be updated to 2005 or 2008 before you can make the jump to 2012.

Other than that, you have two ways of doing the upgrade....

Microsoft doesn't really support a direct mechanism of backup & restore through Azure. You can do an export/import through the Azure storage. I have a blog post about it here....

You wouldn't be connecting your source control directly to your production server anyway, so that's not a problem. It just needs a server on the side that you can pull...

The reason that functions are slower than stored procedures is not because of compilation. They're both compiled. It's how things get compiled that are the issue.

If you're talking about an...

Yeah, we'd at least need the execution plan to understand what's going on. Nothing jumped out as horribly egregious. The GROUP BY will put more load on tempdb depending on...