oh.................if bounded by date.........no duplicate data exists
it is about 78 GB Do you think it should be split into multiple DB
However, if union all is used, duplicate data cannot be resolved.
Thank you Thomas that means if I create an index on datadate then although SQL Server process both parts, it takes only little effort on second part...
Hi, a question on the size of tempdb. it is found that the tempdb size always keeps to be about 14~15G a daily shrink job is built at night but...
Hi, is it too large for a table holding 196,086,798 data row? any comment on it? thanks
Hi I have a question about View in SQL Server Suppose I have two DBs DBA & DBB in two DBs, there is a table tableA with same schema In...
Hi All, All the DB is run at the same server. "sometimes it takes a hour to execute a minutes sql" means some simple SQL script only need to run...
Can i setup some jobs to kill them automatically?
Hi, I have encountered serious problems in my company SQL Server: background : 1. there are about 150 Databases setup in the SQL Server 2. there are...
as subject thanks
I want to know why there are so many sleeping processes found in Enterprise Manager under below location? Management -> Current Activity --->...
Separate names with a comma.
