Reputation
764
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 12 29
Impact
~62k people reached

  • 0 posts edited
  • 0 helpful flags
  • 93 votes cast
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
Sep
2
asked Data center from scratch which way to go
Aug
13
revised Mathematical method for spotting irregularity in numbers flow
added more details
Aug
12
asked Mathematical method for spotting irregularity in numbers flow
Aug
5
awarded  Yearling
Jul
10
accepted How to design index for faster deletes
Jul
4
asked How to design index for faster deletes
Jun
24
answered copy only tables with data from one database to another database
Jun
23
asked Insert missing rows to subscriber of Transactional Replication
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.
Jun
15
accepted how I can create check sum to validate no changes at int string pairs on table
Jun
15
answered Column of generic/variable type?
Jun
15
asked how I can create check sum to validate no changes at int string pairs on table
Jun
10
asked Will performance be better if I specify a filter multiple times?
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
31
asked How to add an automatically-populated custom sequence number?
May
14
accepted Replication between SQL Server 2005 and Azure database