169 reputation
16
bio website naya-tech.co.il
location Israel
age 24
visits member for 1 year, 8 months
seen 7 hours ago

hi my name is Shimon, I am a SqlServer DBA in a large organization, i am experienced with MongoDB MySql C# JS vb.net vba html css TSQL and performance tuning

i'm not crazy, my mother had me tested --sheldon cooper


Sep
28
answered Large queries are slower in SSMS
Jun
25
comment Should I add it as an additional column or a seperate table?
you can make it accept nulls, or insert the division before the region. its more a question of how you use it and write to the db..
Jun
24
answered How to print ORDER wise using LEFT JOIN in SQL?
Jun
24
answered Save different account types in a database
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
and you should check to see if its really damages the performance because you cant guess stuff like that without making a real check
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
so you need to use a stored procedure or collect the table data once on each run to a local db and run the query there
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
run the cte/query for each one of the inputs you have and you will get correct results
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
you cant use it with in(value1,value2,...)
Jun
24
revised how to select column3 from rec1 value which is matched to column1 val in rec2
added 139 characters in body
Jun
24
comment how to select column3 from rec1 value which is matched to column1 val in rec2
thats not a stored procedure... and you dont need the create table / drop table / insert parts of the code because you allready have the data and table
Jun
24
answered how to select column3 from rec1 value which is matched to column1 val in rec2
Jun
24
revised Should I add it as an additional column or a seperate table?
deleted 2 characters in body
Jun
24
answered Should I add it as an additional column or a seperate table?
May
16
awarded  Popular Question
Apr
22
answered Query multiple rooms with different conditionals (Adults, Children)
Apr
22
answered ORM for Image model
Apr
22
accepted Is it impossible to store 2^266 records on a database of some kind?
Apr
2
awarded  Commentator
Apr
2
comment Is it impossible to store 2^266 records on a database of some kind?
here is the data i am asking about directory.io (all of the records)
Apr
2
comment Is it impossible to store 2^266 records on a database of some kind?
the number of records is the number of bitcoin addrresses and private keys.. actual number, not absurd, real data..