Luis Cazares (1/6/2016)

---

Here's a nice short article about concatenating strings:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Here's an example based on what you posted:

WITH CTE AS(

SELECT DISTINCT ID1, ID2, ID3

...

have2much (1/8/2016)

---

Hi,

I am new to sql server and trying to use resource governor to limit maxdop for DBCC CHEKDB and if possible for other maintenance job like backup and optimizing...

Start by reading Stairway to Integration Services[/url]

😎

Echoing Jeff and Hugo, we need more information in order to help with this problem.

😎

My thought is that this nested case approach may not be the correct one for this...

Don't think automating this is a good idea and especially on a remote server, anything goes wrong and it's...

Mac1986 (1/8/2016)

---

I might be the dummest person and i'm sure it might wront to recycle NICs one at a time at 15 hour interval. I'm seeing that IPV6 is slowing...

Quick question, did you just add the SPMs or did you remove them before adding them again?

😎

The article benjamin.reyes posted a link to has good instructions on how to handle...

Here is a quick example to help you get started.

😎

Note: do not make the mistake of using functions on the date column in the where clause, forces the server to...

Sweetbee870 (1/8/2016)

---

I Need some help! I'm New and learning SQL I have the basics of SQL down but I need some help with Joins more specifically Inner Joins with linking...

Piling on, with this little information there is...

SQLRNNR (1/9/2016)

---

A little salt lick with that.

There are several million wordpress blogs that use mysql in that figure. I wonder how many of...

Those are IP6 addresses, probably better to disable IP6 if it is not being used.

😎

Here is an excellent article on the subject by Pinal Dave.[/url]

😎

srinivas.akyana (1/9/2016)

---

Hello,

We have ASLB installed with 3 servers for load balancing, there are times we observe that one of the servers are causing in slow in performance. It was more...

Jeff Moden (1/9/2016)

---

Eirikur Eiriksson (1/9/2016)

---

If the logic can be encapsulated in the actual date table and it is used more than once then a physical date table is almost always...