Viewing 15 posts - 271 through 285 (of 599 total)
definitely user seeks = 0, debatably user scans = 0
The best scenario is an index seek, second-best is a scan. So, if there are no seeks and no scans,...
November 1, 2007 at 5:18 pm
1) Assuming you have reporting services installed and are on SP2, Right click on the DB, Go to Reports | Standard Reports | Index Usage Stats
also query:
select
si.name,
db_name(ps.database_id),
ps.*
from
sys.dm_db_index_usage_stats...
November 1, 2007 at 4:59 pm
And using Safari's search feature I found in the same book:
SQL Server 2000 makes much heavier use of session-owned locks; in SQL Server 2005, transaction_workspace locks are used instead. A...
November 1, 2007 at 11:46 am
The only thing I can think of is that they are assuming it's a low-traffic DB - maybe a DW with a nightly population? Bulk-logged mode?
I know I'm working...
November 1, 2007 at 11:01 am
You're welcome. I love that book. Kalen has a blog, too if you're interested:
November 1, 2007 at 10:53 am
Can't find anything in the books I have access to right now except this from Kalen Delaney's Inside SQL Server (the storage engine) book:
SQL Server provides two separate locking systems....
November 1, 2007 at 10:26 am
select max(datalength(YourColumn)) from YourTable
October 30, 2007 at 9:45 pm
GilaMonster (10/30/2007)
Just watch out for the simulations. They catch a lot of people.
Heh. That's why I haven't taken the exam yet. I've got lots of experience with 2K5...
October 30, 2007 at 4:38 pm
sp_who
sp_who2
Management | Activity monitor in SSMS
KILL [SPID] to kill the process
October 30, 2007 at 11:16 am
There's a GUI indicator that you can change the filegroup (look on the Storage page). However, when I scripted one out it just gave me a generic create index...
October 29, 2007 at 2:27 pm
When I try to connect remotely I get:
An error encountered in the transport layer. The peer prematurely closed the connection. (pfutil90)
I connect fine to the Database engine, just not...
October 24, 2007 at 4:52 pm
From my research, this is what I recommend:
Set AWE to enabled.
Run SQL Server under a Windows account that has Lock Pages in Memory enabled.
The Maximize data throughput for network application...
October 18, 2007 at 3:36 pm
No, the surface area configuration tool is a feature of 2005. You need to post your questions to a SQL Server 2000 forum as Full text works differently.
October 16, 2007 at 10:51 pm
It's a Windows service account:
SQL Server FullText Search (MSSQLSERVER)
Right click, go to properties and check the Log On tab.
You also want to double-check that it's enabled in the Surface Area...
October 16, 2007 at 10:03 pm
Viewing 15 posts - 271 through 285 (of 599 total)