Search Results

large tempdb size

Thread by: Linus Yeung, Jan 17, 2007, 4 replies, in forum: Performance Tuning for DBAs

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

196M datarow

Thread by: Linus Yeung, Jan 17, 2007, 3 replies, in forum: Performance Tuning for DBAs

Hi, is it too large for a table holding 196,086,798 data row? any comment on it? thanks

View Problem

Thread by: Linus Yeung, Jan 17, 2007, 6 replies, in forum: T-SQL Performance Tuning for Developers

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

Slow Performance ....seek help

Thread by: Linus Yeung, Jan 11, 2007, 3 replies, in forum: Performance Tuning for DBAs

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

Silly Question : Data Warehouse = OLAP?

Thread by: Linus Yeung, Jan 11, 2007, 2 replies, in forum: Analysis Services/Data Warehousing

as subject thanks

Why so many process is sleeping

Thread by: Linus Yeung, Jan 11, 2007, 3 replies, in forum: General DBA Questions

I want to know why there are so many sleeping processes found in Enterprise Manager under below location? Management -> Current Activity --->...