I think that Jeff's point of view is that it's safer to reconfigure a (working)...

komal145 (10/24/2016)

---

hi,

I have a source column value "abcd" , i will be updating the destination column with the source column value only if there is a change.

Example: destination is...

.Patrick (10/24/2016)

---

Hi all,

Currently we are developing a new application for our company and I got a question related to the database architecture. We one database (DatabaseA) that is our main...

A LEFT JOIN from a calendar table is probably what you need.

Take a read of this link and see whether it helps you.

BrainDonor (10/24/2016)

---

sqlserverDBA2016 (10/24/2016)

---

is it always better to add database features like analysis services and integration tools and reporting services

when installing sql server instance, and it wont complicate and cause issues...

Bravo. Gave me too much of a headache before my first coffee trying to work that out.

If you find that you cannot run this as a distributed transaction, it should be possible...

ramos.ferdinand (10/24/2016)

---

Hi Gurus,

Just wanted to seek out for your help. This is a bit opposite of what aggregation should be. :hehe:

I wanted to aggregate records with different values and...

philand3 (10/23/2016)

---

Dear All,

i would like to send out following query to all email users daily basis,can anyone guide me the direction,

it can be from SQL or external tool,ETC.

SELECT ...

You've just found a pretty good example of why SELECT * is often regarded as bad practice.

Usually, I would suggest that you specify all of the column names explicitly. But...

Super_Grover (10/23/2016)

---

Phil Parkin (10/23/2016)

---

Super_Grover (10/23/2016)

---

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row...

Super_Grover (10/23/2016)

---

It is unique AFAIKS but it's not an unbroken sequnece. In other words: it does not stay in sync with the row numbers (doc_numbers are...

Is doc_number unique?

Jeff Moden (10/21/2016)

---

Just to be sure, ol' friend... please don't ever take my sometimes (usually?) zealous contrarian attitude towards SSIS personally. Without boring you with the ugly details, I...

Is anyone experiencing the effects of this?

http://gizmodo.com/this-is-probably-why-half-the-internet-shut-down-today-1788062835