710 reputation
11026
bio website robotsarajevo.com
location Novo Sarajevo, Bosnia and Herzegovina
age 32
visits member for 3 years, 4 months
seen 13 hours ago
Hello ! I am coming from Bosnia and Herzegovina,Sarajevo capital, I work in family firm as an IT administrator, My primary task is to eventing works well and lot of other stuff such as buying software, buying equipment, administrating SQL servers and much more. Our Company business is retrial and We have shops all around country with more than 300 working station with more than 1000 employed. In free time I try to learn programing in .NET and I having fun driving motocross bike, some time by summer I do a solar gliding flaying as sport pilot. If You fund my English is bad do not be maid my education was mostly during the war in Bosnia, in that time we did not have to study much for good ratings. Best regards Admir

Aug
18
comment How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012
My stored procedures have logic of rising errors when business process is in violation. I am using sql to generate ERROR message which will tell user where are they wrong.
Aug
18
comment How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012
In that way I still need to do replace, Can I avoid using replace ?
Sep
13
comment Help me to map Column types betwenn SQL and TopSpeed Clarion Tables
@marc_s I know that there is DATE in SQL but I can't find way Clarion holds dates and in what type of data is reserved for date fields
Sep
5
comment Design concerns for using 3x bit or one char(1) or one integer in table for holding status of item
I do including statuses because of filtering, One of my common task is to extract only items with some status for one warehouse
Sep
2
comment Data center from scratch which way to go
My main database is 80GB but It is not normalized, and I have a lot missing index, I except that it will grow up at leas 0,5TB when I will have space to demoralize it, Like extincting sells data per days,weeks etc.
Sep
2
comment Data center from scratch which way to go
@JonSeigel Currently I am running my business on 2x SQL servers which have 38 GB of ram at all, They have IBM Sas raid controllers and I do not have more spice for adding new discs. My servers is from 2006 year and I think that there is a lot of bottlenecks on them.
Sep
2
comment Data center from scratch which way to go
@JackDouglas Yes and deed Thanx a lot
Sep
2
comment Data center from scratch which way to go
@JackDouglas If I go with one physical server, What will be my failover (recovery) device. Replicated database is in READ_ONLY mode , I have few more tables inside for denormalizing data (data mining) and It is receiving queries on entire dataset
Jun
15
comment how I can create check sum to validate no changes at int string pairs on table
Shame on me, I read several books about SQL and I can't remember that I saw anything about check-sum function.
May
31
comment How to add an automatically-populated custom sequence number?
@AndriyM yes that is purpose of calculated field
May
31
comment How to add an automatically-populated custom sequence number?
@MartinSmith That number is reference for humans, Every doc have number own number. For me it is common case for apps, How do you count bills. Considure this table as bills holder I need to show users some bill number. But I have different type of bills and each have own numbers
May
10
comment Installation of SQL Server RAID 10 vs RAID 5
maybe this can help dba.stackexchange.com/questions/7773/…
Apr
26
comment Easier way to handle so many isnull() situation
@AaronBertrand Thanks a lot on trying to help, Ill show Full source immediate when I got finished my work, That is way there is bugs. I start writing query and saw where it is going and than I stooped and start searching for help
Apr
26
comment Easier way to handle so many isnull() situation
@Closers why vote to close ?
Apr
26
comment Easier way to handle so many isnull() situation
@AaronBertrand Thanx on that, I was hoping that I can set ANSII NULL param but looks like it ANSII NULL is not in common whit my problem
Apr
26
comment Easier way to handle so many isnull() situation
@AaronBertrand I do calculations (+,-,*) inside TSQL but my tables are mostly Left Outer Joined and I have many nulls
Apr
11
comment How to handle update or insert situations
@AaronBertrand Then I should avoid adding SET NOCOUNT ON; inside my sprc ?
Feb
20
comment How to sort category by path and sort order?
did you try order by level,path ? You can put more then one column in order
Feb
20
comment Are there differences in performance of getting data between FullText Search and indexed columns
@AaronBertrand Perhaps I am afraid because I do not have enough knowledge about it. Ill try anyway thank you on nice comments.
Feb
20
comment Are there differences in performance of getting data between FullText Search and indexed columns
@filter in most time will be part of name (naziv) or part of catalog number (sifra). User knows only part of catalog number or part of name of an article. And then searching. Does that mean that it is no propose of setting full text indexes