While I have known how to use PerfMon for some time, what I'm searching for today is information on specific counters to select from the many available under "SQL Server"...

I'm afraid that this one was a Home Simplson [doh!]

My issue turned out to be that one side of my comparison was nchar

and the other side was char.

I had...

I was ultimately successful by calling procedure sp_removereplication, even though the database was not actually doing any replication.

Something was just corrupted.

https://technet.microsoft.com/en-us/library/ms188734%28v=sql.105%29.aspx

No, but I have just discovered that the log reuse indicator for this database is "REPLICATION", and we're not replicating this MSDB database, so I'm trying to learn how to...

Grant Fritchey (9/21/2015)

---

There are only 38k distinct values in a data set of 25 million. ... ... The number of pages being accessed alone implies that a scan is...

I've tried JOIN as well.

The issue appears to be only with the memory-optimized table, resulting in the M-O table running slower than the disk-based table.

When it uses the index...

Now I've added a second column to the index, but I still see my 64/65 column split:

WHERE ZipCode IN ('64 values', '...') AND

...

As you might expect, the key count is simply the number of ZIP codes in our data:

KEY_COUNT TOTAL_COUNT KEY_RATIO

38245      25932222 678.05522290495489

I...

I can report that the "alias" approach works where replication cannot be otherwise disabled.

I had wondered how deeply in the code aliases were utilized, as I've been using them quite...