Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be including half...

Give the man a cookie for doing the actual math work! 😀

Mark Harley (7/23/2014)

---

My event data actually comes from oracle and is stored in a temp table, which I believe means that we can't add an index to it. And...

BTW...

mickyT (7/17/2014)

---

This query will not perform the best in 2008 as it will not use spatial indexes, however in 2012 it should use them. You will need to make...

What do the indexes on your tables look like?

sqlvogel (7/23/2014)

---

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the...

Grant Fritchey (7/23/2014)

---

Brandie Tarvin (7/23/2014)

---

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to...

Try this:

SELECT c1.*

FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1

INNER JOIN (SELECT COMPANY

FROM [CPACONTACTS].[dbo].[CPACONTACTS2]

...

Grant forgot to mention that you can't take transaction backups in Simple recovery mode. So verify your recovery mode first. If it's already in Simple (EDIT: given your original post...

There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural composite PK...

mattech06 (7/23/2014)

---

Hi,

I have a table BankRef with a BankID column that was populated from the first 24 characters of a column TransDesc from another table BankTransactions.

I wish to repopulate the...

There are two ways you could do this. The first is using the MERGE keyword. I have not used MERGE, though, because it hasn't yet been useful to me. So...

How many of those data files are read-only files that could be moved to another disk to free up space for the read-write files?

How much of the data in...

Ah-HA!

While scripting the securables from the database role, I found this interesting piece of code that I don't see in BOL. This, apparently, is the syntax for adding a specific...

I think I've found a possible solution. I'm going to create a database role with these permissions in Production and then just assign the user group to that role in...