220 reputation
1311
bio website techgineer.blogspot.com
location Amsterdam, Netherlands
age 27
visits member for 2 years, 8 months
seen yesterday

Data Warehouse developer at Info Support B.V., with a background in Computer Science. Love to discover new things in code, platforms and more.

When I'm not working, I like playing the piano (& hammond organs - I LOVE those), spending time with friends (going out, having some beers, discussing Deep Thoughts about Life And The Universe) and travelling.


Aug
21
awarded  Notable Question
Apr
16
awarded  Famous Question
Dec
18
accepted Enforce Schema-bound views
Dec
16
awarded  Yearling
Dec
12
asked Enforce Schema-bound views
Oct
26
awarded  Popular Question
Oct
24
suggested suggested edit on SQL Server Decimal(9, 0) vs INT
Oct
24
comment SQL Server Decimal(9, 0) vs INT
I think SQL Server optimizes something there indeed. Despite the optimization DECIMAL still takes usually somewhat longer (at least on my development system). In a run of 10 tests around 51 ms DEC vs. 46 ms INT.
Oct
14
comment SQL Server Decimal(9, 0) vs INT
@AndriyM, I think this is the greatest benefit. Rephrase it into an answer instead of a comment and I'll mark it as answer.
Oct
5
comment SQL Server Decimal(9, 0) vs INT
Your answer makes sense, but a processor doesn't have any knowledge of datatypes. So one datatype of 4 bytes, is compared just as fast as another datatype of 4 bytes. Can you show (with a repeatable performance test, for example) that there's a performance hit in using DECIMAL(9, 0) instead of an INT?
May
27
awarded  Caucus
Apr
29
awarded  Popular Question
Oct
17
awarded  Notable Question
Sep
14
revised Running an SSIS package owned by a domain user from SQL Server running on a local service account
Update in response to several proposed answers
Sep
14
comment Running an SSIS package owned by a domain user from SQL Server running on a local service account
@Justicator: Maybe, as a last resort. But whenever domain logins are possible, I prefer not to use SQL Authentication.
Jul
23
awarded  Popular Question
Jul
16
revised SQL Server Decimal(9, 0) vs INT
Further clarified the title
Jul
16
awarded  Editor
Jul
16
revised SQL Server Decimal(9, 0) vs INT
edited title
Jul
16
asked SQL Server Decimal(9, 0) vs INT