CSS SQL Server Engineers

A series of questions related to start time, duration, end time, T-SQL waitfor delay command and others crossed my path again this week.     As I was trying to explain it to a fellow engineer and I realized it has become a bit complicated...

I was recently asked how SQL Server handles exceptions in the core code of the engine. I looked around at various references and did not find a concise document.   When an exception is encountered in SQL Server error details such as the following...

We frequently come across situations where databases take a long time to recover. A common scenario is where the recovery process has to roll forward or back several transactions for a database after a SQL Server restart. However, you might also see one...

Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard. SQL Server 2008 Cumulative...

Last October I posted on our updated policy for support of SQL Server in a virtualization environment. This policy is based on a KB article that summarizes our policy. You recall this article is the following: Support policy for Microsoft SQL Server products...

From an IIS perspective, there were changes between IIS 6 (Windows 2003) and IIS 7 (Windows 2008).  Reporting Services 2005 utilizes IIS for the Report Manager and Report Server Web Service.  If you had a Windows 2003 Server with Reporting Services...

I have recently had several questions related to the dbcc memorystatus and associated memory DMV display values for locked pages and single page allocations.   After reviewing several outputs and the code I will attempt to summarize my findings...

In the previous posts we have discussed the working set trim message “ A significant part of sql server process memory has been paged out ” that gets written to the SQL Server Error log. You can find the details about the various parameters that determine...

_____________________________________________ Subject: RE: dumptrigger question They don't survive service restart. SQL 2000 did not have dumptrigger enabled for all error messages and I think 1105 is an ex_callprint instead of ex_raise so it won't work...

I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications...

We have a customer who uses Form based authentication in his ASP.NET application. But he also wants to use FileStream feature. Authentication becomes a challenge. In order for FileStream to work, sql connection needs to use ingetrated security (not SQL...

I was in the process of setting up a repro for another Blog I’m going to be posting and ran into an unexpected situation.  My VM was running Windows 2003 and I had installed SQL 2008.  I was then going to upgrade to Windows 2008 Server and came...