Viewing 15 posts - 7,396 through 7,410 (of 8,416 total)
Please see my reply to your other question about encryption.
Your basic error is trying to store the encrypted data as the original datatype rather than using VARBINARY.
Paul
July 25, 2009 at 8:26 am
The encryption functions, such as EncryptByKey, return VARBINARY, with a maximum size of 8000.
Your table attempts to store these binary values as VARCHAR or NCHAR. This is wrong.
The decrytpion...
July 25, 2009 at 8:23 am
You might consider storing the characteristics in a separate table. This separate table would have a key and a value for each characteristic, linked back to the main table...
July 25, 2009 at 6:26 am
Consider:
1. EAV - see http://en.wikipedia.org/wiki/Entity-attribute-value_model
2. Storing the data in XML, and using XML indexes and persisted computed columns to promote properties
3. Consider using SQL 2K8's sparse columns...
July 25, 2009 at 6:19 am
The blog post you linked to seems to explain the difference well.
It is interesting, but I am not sure how relevant it is. It is generally better to use...
July 25, 2009 at 6:09 am
Linz,
It would help if you provided a sample script to illustrate the problem and what behaviour you wish to produce.
Generally, some combination of nested transactions, save points, and judicious table...
July 25, 2009 at 5:44 am
That illustrates nicely why I dislike the COUNT(1) construction so much.
It is pointless and potentially confusing. It seems to be born out of some idea that COUNT(constant) is somehow...
July 25, 2009 at 12:47 am
Jeff Moden (7/24/2009)
total_worker_time total_physical_reads total_logical_reads total_elapsed_time
392055 ...
July 25, 2009 at 12:37 am
jcrawf02 (7/24/2009)
Hmm, thanks Paul. Wonder how much shipping would be from NZ
:laugh: Possibly enough so it would be cheaper for you to collect it :laugh:
I am told that other auction...
July 24, 2009 at 6:50 am
GilaMonster (7/23/2009)
July 24, 2009 at 6:43 am
Lynn Pettis (7/23/2009)
Jeff Moden (7/22/2009)
Lynn Pettis (7/22/2009)
Why? Seeks are faster than scans.Heh... because "A developer must not guess... a developer must KNOW." 😉 It'll be a nice test.
If...
July 24, 2009 at 6:40 am
John Paul (7/23/2009)
How can we need to remove Table Stats Warning on Table Varibale ..
Even though SQL Server does not support column statistics on table variables, that doesn't...
July 24, 2009 at 2:06 am
jcrawf02 (7/23/2009)
July 23, 2009 at 11:28 pm
Lynn Pettis (7/23/2009)
We could use the DDL for the table (including indexes), some sample data (readily consummable), and your update queries.
Absolutely. Without this it will be impossible to help...
July 23, 2009 at 11:23 pm
Viewing 15 posts - 7,396 through 7,410 (of 8,416 total)