My understanding is that you can...

GilaMonster (1/27/2014)

---

I don't see the point of writing you an alternate query if I can't test it...

SELECT a.ID AS Master_ID, b.ID AS Duplicate_ID

FROM dbo.Merit_Build2 AS a

INNER JOIN dbo.Merit_Build2 AS b

ON a.Country = b.Country

AND a.Postcode = b.Postcode

AND a.organisationname = b.organisationname

AND a.Address1 = b.Address2

WHERE...

>> FROM sys.identity_columns

Thanks for that nugget Jeff - almost 45000 man hours working with SQL Server and still learning!! :w00t:

Search web for sp_msforeachtable. It will iterate through all user tables in the database and execute code you specify. You will need to test syscolumns joined to sysobjects...

Read Books Online. They are a tremendous resource and are free with the product.

Mani-584606 (1/24/2014)

---

We have Vmware VM machines. As per Systems team, if we wanted to use Quorum as a Shared drive, then they need to create RTM drive And if they...

dave-L (1/23/2014)

---

Our production server has been generating rather frequent (at least once a day) 825 errors and I am considering enabling trace flag 818 for more information on the issue.

KB...

You gave the answer right in your quote of guidelines:

> Even number of nodes, no shared storage ...

Evil Kraig F (1/23/2014)

---

GilaMonster (1/23/2014)

---

In that case, Kraig's comments on contention don't apply, he was talking about the practice of...

Shrinking a tlog will not necessarily shrink it, or shrink it to a size you want (which should NOT be a tiny size, btw). It depends on where the...

Mani-584606 (1/22/2014)

---

Hi,

I want to set up AlwaysOn Availability Groups using 2 windows servers.

1. I have 2 Winodows enterprise servers ready

2. Clustering feature enabled on both of them

So before I...

Joe.Spitler (1/23/2014)

---

We are running MS System Center Operations Manager (SCOM) with 2 nodes, always on, with SQL Server 2012. Our transaction logs are growing and filling up the the...

I STRONGLY recommend a 2-number scheme over GUIDs to ensure uniqueness for numbering across multiple servers. Bigint plus smallint is just 10 bytes vice the 16 you need for...

Can you provide more detail on exactly what it is you are trying to accomplish and what your problem(s) actually is/are? Also please provide 3 or 4 tables and...