Assuming that AddressUno is an IDENTITY column this will be a lot easier to manage.

First insert the Address table for home address, business address, etc. and for each use the...

jonathan.d.myers (12/2/2016)

---

@ Eric: EXACTLY... It's the simple database objects that get the most attention because they're the simplest for a 3rd party tool to handle. They exist as actual OBJECTS...

Speaking of which, I've found that practically all database comparison / synchronization tools don't cover server level objects like jobs, logins, credentials, SSIS packages, or server options.

Jeff Moden (12/1/2016)

---

Eric M Russell (12/1/2016)

---

Jeff Moden (12/1/2016)

---

Benki Chendu (11/29/2016)

---

Friends,

I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I...

Jeff Moden (12/1/2016)

---

Benki Chendu (11/29/2016)

---

Friends,

I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using a tool called...

Area Man Uses This Simple Trick To Double His Income (AND SO CAN YOU!!)

:rolleyes:

ZZartin (12/1/2016)

---

Eric M Russell (12/1/2016)

---

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise...

Are you the DBA for this server; can you connect to the instance using SSMS or SQLCMD and execute SP_WHO2 ?

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise their ethics while on...

savibp3 (12/1/2016)

---

There is stored procedure which show no error but keeps on executing with stop.I had placed some select statements to debug when i stop the browser after some time...

Gabriel P (11/30/2016)

---

Hey, does anyone know if there's some undocumented feature that would allow you to query a table by FileID/PageID?

Something like this:

SELECT *

FROM dbo.ThisTable

WHERE $FID = @FileID

AND $PID =...

You can also strip characters from a string using the REPLACE function. The ASCII characters for carriage return is (13) and it's typically followed by a line feed (10).

DECLARE @s-2...

Even if a column contains the same value for every row, it can still very well be used. If you do choose to remove the physical column, you may want...

No, you can't open a SSIS project or package directly and edit in place, or at least it's not as easily done as jobs or stored procedures. However, there are...

For the concepts of relational algebra that underly SQL, here is an overview:

https://en.wikipedia.org/wiki/Relational_algebra

The mathematical operators and functions included in the T-SQL language are quite basic.

https://msdn.microsoft.com/en-us/library/ms187716.aspx

https://msdn.microsoft.com/en-us/library/ms177516.aspx