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...

When I present I blow the font up large and I change it to Lucida Sans. It seems to work well for most people. I don't use that normally (maybe...

glamourth (6/13/2012)

---

Hi All,

I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join...

Steve Turner - SQL Managed (6/12/2012)

---

Actually, you can now host Windows Servers on Azure. This was in beta for a while but MS just announced the new Azure code...

Ah, missed that it was tempdb. Still, assuming my disks are going off, I'm running an extra backup. I may still run DBCC on the other databases too.

First thing you should do is run a set of full backups. Then save that somewhere on the side or, better still, off-site.

After that, you can try to identify the...

Windows Azure is just application hosting. It's not an entire OS. For that you'd want to look at Amazon or Google. Windows Azure is for applications and SQL Azure is...