Reputation
419
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 5
Newest
 Yearling
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
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
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/…
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
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
29
comment Current wisdom on SQL Server and Hyperthreading?
Yes. That is correct.