Search Results

Thread by: goboxe, Mar 9, 2009, 1 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi, I have a 8GB RAM server running SQL Server 2008 Enterprise Edition. I have allocated 5.5GB RAM to SQL Server. After some normal queries start...

Post by: goboxe, May 5, 2006 in forum: General DBA Questions

I have tested it before with 20 million records in a table. The query is very slow and even worst when doing update operation. quote:Originally...

Post by: goboxe, May 5, 2006 in forum: General DBA Questions

Thanks mmarovic. Is there any significant advantages having separate table in different databases? quote:Originally posted by mmarovic You can...

Post by: goboxe, May 4, 2006 in forum: General DBA Questions

Hi KH, The system that I am designing now need to cater input of 4 millions records daily. So the purpose of having the partitioned table is to...

Post by: goboxe, May 4, 2006 in forum: General DBA Questions

Khtan, thanks for your reply. Below is the sample script created manually for partitioned view CallRequests_All and based tables...

Thread by: goboxe, May 4, 2006, 12 replies, in forum: General DBA Questions

Hi, I need help in looking at sample script to perform automatic creation for weekly partitioned tables and also update the partitioned view...