Welcome to MSDN Blogs Sign in | Join | Help

February 2008 - Posts

Thursday, February 14, 2008 9:35 PM

How It Works: Linked Servers and Collation Compatibility

Customer Question:   "Why I am getting different results when is change collation compatibility from true to false?" This actually turned out to be an interesting issue because no error was raised but the results are different. The query
Posted by psssql | 2 Comments
Wednesday, February 13, 2008 9:54 PM

How it Works: SQL Server Per Query Degree Of Parallelism Worker Count(s)

The question invoking the discussion was why did a query elect to use 100+ workers, approximately half the configured worker threads?  Before erasing this topic from my whiteboard let me document the highlights.  Often overlooked is the degree
Posted by psssql | 3 Comments
Tuesday, February 12, 2008 6:10 PM

How It Works: SQL Server 2005 Connection and Task Assignments

I have talked about how connections and tasks get assigned as PASS and during many other mentoring opportunities.  I just finished working on an issue that forced me to dig deeper into the subject. The customer reported that on a NUMA machine the
Posted by psssql | 3 Comments
Filed under: , ,
Thursday, February 07, 2008 8:43 PM

How It Works: SQL Server 2005 Database Snapshots (Replica)

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. I encountered an interesting issue today that I would like to share.  
Posted by psssql | 5 Comments
Filed under: ,
Wednesday, February 06, 2008 7:28 PM

How It Works: How does SQL Server Backup and Restore select transfer sizes

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. A customer asked: "Why does backup to disk choose a transfer size of 1MB but
Posted by psssql | 1 Comments
Tuesday, February 05, 2008 3:47 PM

High waits on CLR_MANUAL_EVENT and CLR_AUTO_EVENT

If you have a SQL CLR application, you may notice that waits on CLR_MANUAL_EVENT and CLR_AUTO_EVENT from sys.dm_os_wait_stats are very high. This is normal and can be safely ignored because these waits reflect internal CLR runtime waits under normal conditions.
Posted by psssql | 2 Comments
 
Page view tracker