419 reputation
25
bio website sqlblog.com/blogs/…
location Tampa, FL
age 34
visits member for 5 years, 6 months
seen Nov 4 at 5:11

Sep
29
awarded  Yearling
Feb
10
answered SQL Server 2005 Service Pack 2 - Failed Cluster Node
Jan
7
awarded  Nice Answer
Oct
31
answered What kind of values should I worry about in in sys.dm_os_wait_stats?
Oct
31
answered Recommend a good .NET 4.0/SQL Server 2008 web host (shared platform)
Aug
17
awarded  Yearling
Oct
16
awarded  Critic
Oct
16
comment Find last login datetime for SQL Server login
Yeah I wish I could say different but this is a common problem people encounter, especially when dealing with external compliance auditors.
Oct
15
answered Managing Reporting Services
Oct
15
answered Find last login datetime for SQL Server login
Oct
15
comment Restore MSSQL backup that was done with NO_LOG option
Robert - Check out Paul Randal's blog post on this subject. sqlskills.com/blogs/paul/post/…
Oct
14
answered Restore MSSQL backup that was done with NO_LOG option
Sep
16
awarded  Supporter
Jun
30
answered drop data from systemcenterreporting DB for MOM 2005
Jun
30
comment When to change SQL 2005 max worker threads on 64-bit server
For your scheduler question, you have 4 user schedulers (scheduler_count) column, but you also have other background schedulers, for example the DAC. Take a look at sys.dm_os_schedulers and you will see the individual schedulers. If they have a status of VISIBLE ONLINE then it is a scheduler for user requests.
Jun
30
awarded  Editor
Jun
30
revised When to change SQL 2005 max worker threads on 64-bit server
added 10 characters in body
Jun
30
comment When to change SQL 2005 max worker threads on 64-bit server
I don't see the discrepancy. The true default for Max Worker Threads is 0 which allows SQL Server to configure and manage the value for max workers based on the following calculation: ((NumberOfSchedulers - 4) * 8) + BaseThreadCount For 32 bit SQL Servers the BaseThreadCount is 256. For 64 bit SQL Servers the BaseThreadCount is doubled to 512. The table on the BOL link just shows the value of max workers if the default 0 is configured for various common configurations of CPU's. The recommended maximum is 2048 which would equate to 96 CPU's on the server using the default calculation.
Jun
30
answered When to change SQL 2005 max worker threads on 64-bit server
Jun
29
comment Current wisdom on SQL Server and Hyperthreading?
Yes. That is correct.