Viewing 15 posts - 16 through 30 (of 74 total)
I started replying before Lynn's answer posted. Lynn's answer give's you a better estimated execution plan.
March 28, 2016 at 1:50 pm
Use the GROUP BY and HAVING operators. Try something like this:
DELETE P
FROM @Policy P
JOIN (
SELECT Download, AccountNum, RootPolicyNum
FROM @Policy
...
March 28, 2016 at 1:45 pm
Thank you all for your help and suggestions. I figured out what's going on. When I asked for IT to stand up a SQL 2005 server so I could do...
April 30, 2015 at 8:48 am
So I tried both suggestions:
I can't restore or attach a new empty database created by the machine that is doing the scrubbing onto a third SQL 2005 SP4 machine. I...
April 30, 2015 at 8:23 am
mxy (4/29/2015)
is it a native backup or using a third party tool.
native
what is the extension of the backup file.
.bak
can you do restore headeronly and filelistonly on the server...
April 29, 2015 at 2:11 pm
Steve Jones - SSC Editor (4/29/2015)
April 29, 2015 at 2:10 pm
Backups are being done to a local drive and are copied over the network to the other machine.
April 29, 2015 at 11:09 am
Thanks for the suggestions. Version was one of the first things I checked. Both instances of SQL are running the exact same version (9 SP4, build #9.0.5069). I will try...
April 29, 2015 at 10:01 am
Scrubbing the data while it is still secure is very important and I addressed that in the overview, but I failed to say why. That was an oversight on...
January 6, 2015 at 9:00 am
If there is a number range that will never be used for SSNs, it may make a lot of sense to use it for scrubbed data. I wasn't suggesting that...
January 6, 2015 at 8:09 am
Where I work, we have kind of a hybrid approach. We recently created views for all our tables, refactored the code, and then removed all access to those tables from...
August 21, 2013 at 11:47 am
That's not completely possible in our system right now. We have however, created views for all select access, and we do require that all inserts, updates, or deletes occur through...
September 22, 2012 at 4:32 pm
Jayanth_Kurup (9/22/2012)
September 22, 2012 at 1:14 pm
L' Eomot Inversé (9/22/2012)
I won't repeat what others have already said; I agree in particular with what Jeff wrote.
Table Design
3.Do not blindly normalize everything
Risks being read as a license to...
September 22, 2012 at 12:58 pm
GilaMonster (9/22/2012)
September 22, 2012 at 12:36 pm
Viewing 15 posts - 16 through 30 (of 74 total)