Viewing 15 posts - 1 through 15 (of 39 total)
Sorry about that... yes, in the example of the "equality" search, you would need an index on the encrypted column.
January 2, 2024 at 7:08 pm
In the example I gave, the "sensitive date" has no meaning if not associated to the Customer (in this case); they are just dates, so they would not...
January 2, 2024 at 7:05 pm
Hi @etheral1980,
There is no need for an index on the encrypted column. The index seek would be on Birthdate in the dbo.Customer_Birthdate table (yes, you'd want an index...
January 2, 2024 at 6:57 pm
Nice breakdown of CTEs. I find them extremely useful for logically building queries and maintainability.
One thing I think is important to remember about CTEs is that they are syntactical simplifications...
October 20, 2023 at 5:09 pm
A follow-up to my original post:
After some more testing, I was able to confirm the SQL optimizer is smart enough not to evaluate a function with static input parameters more...
June 8, 2023 at 11:27 pm
Hi Grant,
I'm going to respectfully disagree. I have plenty of experience with programming languages that require trailing semi-colons, but I learned SQL a long time ago and never used semi-colons,...
January 31, 2022 at 11:07 pm
Angeline,
I sure do wish I had updated this thread after. 🙁
I honestly can not recall if the restart solved the problem. I did manage to find some notes I still...
June 16, 2020 at 7:26 pm
I had great hopes for this idea of yours, @scottpletcher.
Unfortunately, it doesn't seem to have affected index selection. I tried increasing the values orders of magnitudes, to no...
February 3, 2020 at 11:25 pm
There are a lot of indexes, but an example would be:
CREATE TABLE [dbo].[MyTable] (
[TaskID] INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
[Active] BIT NOT NULL DEFAULT(1),
[TaskTypeID] INT NOT...
January 28, 2020 at 10:00 pm
This thread is old, but I'm trying to figure out if something like this is possible.
I have a table that somewhat large (80M rows, 104GB) and has 31 indexes totaling...
January 23, 2020 at 7:36 pm
@SGT_squeequal, @jonathan-2 AC Roberts, @scottpletcher:
I'm sorry I wasn't clear. I've solved my problem. The solution is to use <>
("not equal to") instead of >
("greater-than")....
October 10, 2019 at 4:58 pm
Hi Grant. Yes, you are correct about resizing any data type.
When testing previously, I thought I had successfully resized a DATETIME to SMALLDATETIME and back without dropping indexes. Upon retesting,...
September 25, 2018 at 9:06 am
Since I didn't hear back from anyone on this, I did the testing myself.
There are a lot of articles on...
September 11, 2018 at 4:51 pm
I've enabled trace flag 1800 on all replicas now and I'm still receiving this error. I did not restart the SQL service though. I place the trace flag in the...
November 24, 2015 at 10:49 pm
Good call, I hadn't enabled the trace flag. I've done this on the secondary (with no affect). I'll enable the trace flag on the primary during the next maintenance window...
November 24, 2015 at 11:38 am
Viewing 15 posts - 1 through 15 (of 39 total)