sestell1 (7/20/2012)

---

Wow, interesting. I'd been under the false impression that the full backup used an internal snapshot to capture the state of the database at the time the backup...

george sibbald (7/20/2012)

---

A full backup contains enough of the transaction log so the database can be made consistent on restore. The way the question is worded transaction 4 commits before...

Took well over a month, but the betas now all show up on my transcript....

Here is the problem:

"A Table Variable can have primary keys and indexes defined"

This can be read two ways.

1) "can have defined" can be read to mean "can have the ability...

cfradenburg (6/25/2012)

---

Toreador (6/25/2012)

---

I took a risk and made the correct assumptions, so guessed the right answer 🙂

But strictly speaking, the answer should be "false, false".

A Temporary Table can have primary...

Well, according to Hugo, it does in fact create an index, so an index does get created somewhere for it. However, it may not be in memory; I have...

You cannot define indexes at object creation. And while a typical table will create an index for a primary key, I suspect that this does not happen for table...

OK, still no email from Microsoft, and still no sign of 461, 2, or 5 in my MCP history (though 464 is there). Are others seeing these delays, and...

Here's another perspective on certs:

In 1997 I was departing the world of humanities education, with a Master's in ancient Greek and Latin. I had no idea what to do...

I still have seen nothing to convince me that regulatory requirements like HIPAA, SOX, FDA validation, et al can be safely supported in an external cloud. Internal, maybe, but...

I would never write that code either, but the value of such an exercise is that someone else might, and in my current position, I write very little T-SQL but...

Really? Well, then, that is kind of a negative about sequences then, I would think. I would have thought they would have been more static/controllable. Obviously I...

I can see no documentation to prove this, but I suspect you are seeing the results of deprecation of 2000. Most 2000 database server management is not possible in...

Well, the assumption is that you don't have the same availability constraints on a data warehouse, I would assume. May not be true in the real world but there...

If the value of the PK is vital, and gaps cannot be supported, I'd look at implementing one of 2012's new features -- a SEQUENCE. You can programmatically control...