Reputation
789
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 14 31
Impact
~73k people reached

  • 0 posts edited
  • 0 helpful flags
  • 93 votes cast
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
31
asked How to add an automatically-populated custom sequence number?
May
14
accepted Replication between SQL Server 2005 and Azure database
May
14
accepted Find top by values by percents using range in SQL Server
May
14
accepted Are there differences in performance of getting data between FullText Search and indexed columns
May
14
accepted Is there a difference in performance between @date and getdate()?
May
14
awarded  Caucus
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 ?