Reputation
747
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 11 28
Newest
 Tumbleweed
Impact
~59k people reached

  • 0 posts edited
  • 0 helpful flags
  • 92 votes cast
May
10
comment Installation of SQL Server RAID 10 vs RAID 5
maybe this can help dba.stackexchange.com/questions/7773/…
May
7
asked Is there a difference in performance between @date and getdate()?
May
4
accepted Easier way to handle so many isnull() situation
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
revised Easier way to handle so many isnull() situation
added 1425 characters in body
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
26
asked Easier way to handle so many isnull() situation
Apr
24
awarded  Popular Question
Apr
17
awarded  Notable Question
Apr
12
accepted How to handle update or insert situations
Apr
11
comment How to handle update or insert situations
@AaronBertrand Then I should avoid adding SET NOCOUNT ON; inside my sprc ?
Apr
10
asked How to handle update or insert situations
Apr
8
awarded  Popular Question
Mar
7
awarded  Popular Question
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
Feb
20
comment Are there differences in performance of getting data between FullText Search and indexed columns
@AaronBertrand is there any other option to use any part of string inside search, beside using full text ?