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...
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
is it too large for a table holding 196,086,798 data row?
any comment on it?
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
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:
1. there are about 150 Databases setup in the SQL Server
2. there are...
I want to know why there are so many sleeping processes found in Enterprise Manager under below location?
-> Current Activity
Separate names with a comma.