network profile
| bio | website | blog.daksatech.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 6 months |
| seen | Apr 12 at 21:06 | |
| stats | profile views | 6 |
|
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 |
