Viewing 15 posts - 6,391 through 6,405 (of 49,571 total)
Note that the MS site has the Hashbytes function on the CreditCardID, they're not hashing the column that they're encrypting (which is what your code does)
Maybe ditch the example and...
March 19, 2015 at 7:23 am
Why are you first hashing and then encrypting the value? And why, when you try to decrypt are you first hashing the encrypted value and then trying to decrypt that?
March 19, 2015 at 7:13 am
Katerine459 (3/18/2015)
Unless the CTE is also a correlated subquery, wouldn't it just run once
And who said that a correlated subquery doesn't run just once?
March 19, 2015 at 6:28 am
Brandie Tarvin (3/18/2015)
GilaMonster (3/18/2015)
Jack Corbett (3/18/2015)
Steve Jones - SSC Editor (3/18/2015)
For your discussion: https://medium.com/@sailorhg/coding-like-a-girl-595b90791cce
That was an interesting read. I can't disagree with any of it, but I...
March 18, 2015 at 12:31 pm
dan-572483 (3/18/2015)
Is there any harm to leaving this as is?
Yes.
You'll go to set up something like replication, or maybe CDC, or any one of the other features that...
March 18, 2015 at 12:21 pm
No good news, I'm afraid
https://msdn.microsoft.com/en-us/library/ms177570.aspx
Permissions
The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner...
March 18, 2015 at 10:10 am
Jack Corbett (3/18/2015)
Steve Jones - SSC Editor (3/18/2015)
For your discussion: https://medium.com/@sailorhg/coding-like-a-girl-595b90791cce
That was an interesting read. I can't disagree with any of it, but I can honestly say...
March 18, 2015 at 10:00 am
qur7 (3/18/2015)
I updated the job step in the advance tab with log to a txt file.
Yup, that should do it. Run the job again, if it fails...
March 18, 2015 at 8:37 am
Alvin Ramard (3/18/2015)
March 18, 2015 at 8:35 am
Koen Verbeeck (3/18/2015)
ChrisM@Work (3/18/2015)
appdev13 (3/18/2015)
March 18, 2015 at 8:00 am
Koen Verbeeck (3/18/2015)
you can create a new non-clustered index on ID and GPSTime.
This, assuming there aren't any other indexes which we haven't been shown
March 18, 2015 at 7:21 am
jennifer.elkhouri (3/18/2015)
the first step in my nightly maintenance plan is "Shrink database, limit 50 MB, free space 10%" ...
Ow, sob, wince, sob, cringe :hehe:
but I read another blog post...
March 18, 2015 at 7:19 am
Lowell (3/18/2015)
GilaMonster (3/18/2015)
Lowell (3/18/2015)
also, why not count(*)? it would be faster, i would think.
In this case it's unlikely to be faster as the column in the count is already in...
March 18, 2015 at 7:13 am
Lowell (3/18/2015)
also, why not count(*)? it would be faster, i would think.
In this case it's unlikely to be faster as the column in the count is already in the where...
March 18, 2015 at 6:26 am
Please?
GilaMonster (3/18/2015)
Index definitions (CREATE INDEX) and table definition please. I think I know what's going on, but need confirmation.
March 18, 2015 at 6:23 am
Viewing 15 posts - 6,391 through 6,405 (of 49,571 total)