351 reputation
13
bio website blog.daksatech.com
location
age
visits member for 3 years
seen Nov 3 at 20:45

Nov
15
awarded  Yearling
Jul
3
answered Maintain index on SQL Server table
Jul
3
answered Table partitioning for archiving data
Jun
29
awarded  Supporter
Nov
30
comment SQL Server Partitioning - what to use for partition key?
So basically you would have to delete/remove approx 15 million rows every week. How wide is the table? I would suggest you partition the table by date column. This way the weekly deletes would be a simple meta operation. You simply have to SWITCH the oldest partition out of the main partitioned table into a staging table. Then drop the staging table. This is called Sliding Windows scenario. Look up the first white paper I posted oh how to do this.
Nov
30
comment SQL Server Optimization/Configuration for Inflexible Application
Mark, Thanks for pointing out the issue with my description. I had accidently forgotten to put the "NOT" in the sentence " does not take a S lock". You are also right about the implications - specially on tempDB space.
Nov
30
revised SQL Server Optimization/Configuration for Inflexible Application
added the "not" in "does not take a S lock"
Nov
30
comment Possible attack on my SQL server?
currently SQL Server cannot do this. You will have to depend on a Firewall or Windows to do this. See this blogs.msdn.com/b/sql_protocols/archive/2006/04/10/572605.aspx
Nov
29
answered SQL Server Optimization/Configuration for Inflexible Application
Nov
29
answered SQL Server Partitioning - what to use for partition key?
Nov
19
answered Why would recompile query hint result in different plan for same adhoc statement after freeproccache?
Nov
19
awarded  Editor
Nov
19
revised What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
did further research and added clarifications
Nov
18
answered What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
Nov
18
answered Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
Nov
15
awarded  Teacher
Nov
15
answered How recording of every change of a row in a database is generaly stored?
Nov
15
answered One Big Database vs. Several Smaller Ones