Viewing 7 posts - 5,836 through 5,842 (of 5,842 total)
You mentioned doing data mining so I will assume that you actually DO need all the data from the day's join query so you can run it through some mining...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 2, 2007 at 8:57 am
>> That is correct as long you give the access to the db through application but I have seen the cases sometimes clients want to generate custom reports which requires...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 29, 2006 at 9:50 am
As long as you include a ClientID in your action queries, it would take a real blunder to delete the wrong data I think.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 29, 2006 at 8:32 am
Clearly you would not build an application that required new tables for each client. The original poster implied (to my belief anyway) that they were redesigning an existing application. The...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 29, 2006 at 7:51 am
I currently manage 10K+ databases spread over two servers. One of them is a reporting/warm standby server that keeps fairly recent data on it from another other server. It is was...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 29, 2006 at 7:26 am
Try setting your maximum memory in sql server to 3GB.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 20, 2006 at 8:22 am
Partitioning of some sort is definitely the way to go here for best performance. Too bad you aren't using SQL2005 - much better support for that there. But for the...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
December 7, 2006 at 7:03 am
Viewing 7 posts - 5,836 through 5,842 (of 5,842 total)