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.

Hugo Kornelis (1/27/2016)

---

Oh, and a second reason for allowing multiple instances is that they can be different versions. So if you have SQL 2012 and you want to upgrade to...

Here's an excellent article on building you list: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

If you're working towards converting the rows into individual columns, then this article is what you're looking for: http://www.sqlservercentral.com/articles/T-SQL/63681/