Reputation
398
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 14
Newest
 Curious
Impact
~10k people reached

  • 0 posts edited
  • 0 helpful flags
  • 58 votes cast
Apr
12
comment How do I find a long running query with process ID, process name , login time, user , start time and duration?
Filter on st.dbid
Nov
27
awarded  Curious
Nov
9
accepted SSIS Failed to start project
Nov
4
accepted Effect of changing data types with row compression enabled
Nov
3
comment Effect of changing data types with row compression enabled
Say the table contains 32,000 rows with an ID column (BIGINT) with values ranging from 1 to 32,000. In this case all values would fit in a SMALLINT. The values from 1 to 255 would be compressed to 1 byte. The other values would be compressed to an SMALLINT. All rows would be compressed, and thus cost CPU. When the datatype is changed to a SMALLINT, I would think SQL Server knows it can only compress the values from 1 to 255, and only uses CPU for those rows. Is this correct?
Nov
3
comment Effect of changing data types with row compression enabled
Thank you for the repro. Can you tell me more about the usage of CPU?
Nov
3
asked Effect of changing data types with row compression enabled
Jun
8
awarded  Popular Question
Sep
2
awarded  Popular Question
Aug
9
comment SSIS Failed to start project
I didn't het an error about the objectname. When I'm back in the office I'll try and zee if there is an error somewhere. The strange thing is that SSIS 2008 is running fine.
Aug
8
revised SSIS Failed to start project
Added the error in text.
Aug
8
comment SSIS Failed to start project
Thank you for posting an answer so fast. The problem was not upgrading a solution, because I created it in Visual Studio 2012 with the Project Deployment Model.
Aug
8
answered SSIS Failed to start project
Aug
8
asked SSIS Failed to start project
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