What Michael posted about the calculation on the column (which is called a non-SARGable predicate) is spot on. This is inefficient with a table of any size, but you'll...

Since you said you can send your results if you're sending less than 4000 rows, it sounds like you have database mail set up correctly. I don't think there's...

As a bit of a sidebar, I have to ask about the performance of your procedure. I saw a scalar function, non-SARGable join predicates, non-SARGable where clause predicates and...

Orlando Colamatteo (1/27/2016)

---

Any reason why you need this procedure to add a column named DUPLICATE to a table, i.e. why is the column not already on the table if it...

I don't get what you're asking either. When you use the CRM to upload a file, does it store the file in the table or does is save the...

What service pack level are you running? Do you know which database is affected? When was your last known good DBCC CHECKDB on that database?

Yuck

Memories

Grant Fritchey (1/27/2016)

---

Michael L John (1/27/2016)

---

I haven't come up with a good idea on that yet. Our Azure initiative is in it's infancy. There are a couple very small...

After reading about your covering index and statistics, I have to agree with Kevin about the index reduction. The next place I'd go is one you probably won't like...

Grant Fritchey (1/27/2016)

---

Database maintenance, like index defrag, statistics, still has to be done. DMVs are there, although there are differences. For example sys.dm_os_wait_stats is pretty useless. Instead, there's a new...

Brandie Tarvin (1/27/2016)

---

Given that there are no instances, I assume there are other things that are not like normal servers.

How does the SAN features (if there are any) work? I'm...

People

Lots

The function dbo.NetPortal_GetProductPrice is the obvious one, so please include the DDL for it in addition to what Hugo asked for.