You should convert these to the same data type to join them. Ideally they would be, and you will lose some indexing benefits if they are not.

You could use...

You must have had something that made it grow large. Some transaction that created a lot of logging in tempdb. It's possible that you need that much log for your...

Sean is correct. There is no way to know what might make sense.

As a general rule, you might build indexes with multiple columns. I might, depending on the data, build...

Shouldn't be anything for the end user. They shouldn't know, or care. Services should just work.

The cloud, hosted services/servers/platforms, is just...

Joe Clifford (5/23/2012)

---

Zynga.com has probably the most interesting/compelling story "out there" about their use of the cloud - they started as a 100% cloud play and then discovered that they...

Steve Cullen (5/24/2012)

---

Just my opinion, but I think bcp would be simpler for this. The fixed width format file can be generated quickly from a staging table and a...

No

Sam, no worries.

Bruce, go for it.

Ahem, unlike...

SQLRNNR (5/23/2012)

---

Nah - I want to see him beat down the Broncos and Peyton every...

We can only hope.

I believe that the way you have the maint plan set, it will create a new file by default. If you pick a specific file, you can access the drop...

Look in the Configuration Manager. This is an application running on the server. That's what I referenced in the last post.

If you don't understand that, please use Books Online to...

Not login, service account.

SQL Server runs as a service (control panel | services, or Configuration Manager). The account that runs SQL Server is what accesses the backup file.

Append adds the new backup data to the same file. Essentially you get one file like this:

-----------------------------------------

backup 1 | backup 2 | backup 3 |

-----------------------------------------

all stored in one file in...