Phil is right. If this is any column, you might have a lot of work.

In general, you can use a count() on a column, with that column as a group...

Script out replication, always, and keep it handy. There are times you'll need to reset it up.

Use that to move replication to a new, SQL 2014, instance.

This might be easier to consume. Wasn't aware of it myself until Argenis Fernandez mentioned it

DBCC DBTABLE

The TCO,...

lionfan91 (1/13/2016)

---

I was in a position where I had written a few small single purpose applications that a bunch of folks used. They were somewhat related, so we ended...

Andy sql (1/13/2016)

---

Let's not forget that a COTS still involves an employee's time, from evaluating the possible products available, determining specs, reading the documentation (if there is any), pulling hair...

Gary Varga (1/13/2016)

---

I would recommend it being outside the...

I was told it was in the boot page for the snapshot (or db)

DBCC TRACEON(3604);

DBCC PAGE(0,1,9,3);

If you're looking for other exercises, exercism.io is another place.

I'll grant you that if there are no non-clustered indexes, this isn't a problem, but you have other problems if you have no indexes on the table. If it's a...

Thanks, will check it out.

peter.row (1/12/2016)

---

Really Steve?

A Google site appears not to work on an MS browser? Did you read the rest of my post?

Obviously we are all biased by the sites we use....

Interesting question. If I create a snapshot in a clean db/log, I get only 3 log records. They are the

LOP_BEGIN_CKPT

LOP_XACT_CKPT

LOP_END_CKPT

I'm guessing it's one of these, likely the end, but...

Do you mean how does VMWare ( or the hypervisor) work with SQL Server inside a VM? Meaning there is a host and inside of multiple VMs, SQL Server instances...

This is bad. Don't do it.

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2930-fixing-heap-fragmentation/