311 reputation
211
bio website
location Velp, Netherlands
age 25
visits member for 1 year, 10 months
seen Jul 18 at 10:20

Oct
24
comment Can CDC or Change Tracking be against a read only secondary?
CDC enabled databases can be added to AlwaysOn Availability Groups, and databases that are members of an AlwaysOn availability group can be enabled for CDC. In both cases, however, CDC configuration is always performed on the current or intended primary replica.
Sep
10
comment Database Design for lookup tables
I agree with @AndriyM. It would be a more self explaining database design when you create separate tables.
Sep
9
awarded  Yearling
Sep
9
comment Database Design for lookup tables
You can add a new foreign key between questionnaire and question_codes.
Aug
14
awarded  Revival
Jul
30
awarded  Revival
Jul
23
comment Cannot create FOREIGN KEY for a table
This is not the answer to the problem Brady Chu is having. Try to identify the rows that have a missing reference and fix those issues. After fixing those rows (maybe link them to a dummy record if you have no other option) you can create the Foreign Key without errors.
Jul
23
awarded  Critic
May
21
awarded  Caucus
May
21
awarded  Constituent
May
16
answered Efficiently Filter Large Set With Disjunctions
Apr
16
answered How does order of index affect performance in SQL Server?
Mar
28
comment using IDENTITY column with increment -1
I meant your idea of using a BIGINT with a gigantic number as offset is nice. :)
Mar
28
comment using IDENTITY column with increment -1
I'd love your thought on this topic!
Dec
19
comment Slow queries on SQL Server
Did you solve your problem?
Dec
10
comment SQL Server Full-Text Indexer with stoplists/stopwords
Thank you for pointing out the bug report. I've tested this and I ran in the same problems. After changing my system locale to English (US) the stopwords for the English languages still didn't work.
Dec
10
awarded  Scholar
Dec
10
accepted SQL Server Full-Text Indexer with stoplists/stopwords
Dec
7
revised SQL Server Full-Text Indexer with stoplists/stopwords
added 159 characters in body
Dec
7
comment SQL Server Full-Text Indexer with stoplists/stopwords
@swasheck my problem is that the words in the stoplist are still used/ranked in the Semantic Search functions like 'SEMANTICKEYPHRASETABLE'.