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
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.