Viewing 15 posts - 3,166 through 3,180 (of 9,715 total)
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...
July 23, 2014 at 7:56 am
ChrisM@Work (7/23/2014)
At a guess, you have 741 duplicated rows, 73 triplicated, and 1 quadruplicated.
Give the man a cookie for doing the actual math work! 😀
July 23, 2014 at 7:50 am
Mark Harley (7/23/2014)
July 23, 2014 at 6:42 am
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...
July 23, 2014 at 6:20 am
What do the indexes on your tables look like?
July 23, 2014 at 6:19 am
sqlvogel (7/23/2014)
Brandie Tarvin (7/23/2014)
July 23, 2014 at 6:10 am
Grant Fritchey (7/23/2014)
Brandie Tarvin (7/23/2014)
July 23, 2014 at 5:40 am
Try this:
SELECT c1.*
FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1
INNER JOIN (SELECT COMPANY
FROM [CPACONTACTS].[dbo].[CPACONTACTS2]
...
July 23, 2014 at 5:38 am
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...
July 23, 2014 at 5:34 am
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...
July 23, 2014 at 5:31 am
mattech06 (7/23/2014)
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...
July 23, 2014 at 5:28 am
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...
July 23, 2014 at 5:22 am
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...
July 23, 2014 at 4:45 am
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...
July 17, 2014 at 8:06 am
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...
July 17, 2014 at 6:52 am
Viewing 15 posts - 3,166 through 3,180 (of 9,715 total)