Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: SQLIOSim Checksum Validations

    I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic.  It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the data and do the comparison.   1.     ...
  • Blog Post: Don’t change value of that parameter

    Parameter sniffing is a well known among SQL User community.   But I have seen variations of this frequently that need a bit creative handling and solution may not that straight forward. One of the variation is that a user changes the value of the parameter inside the procedure.  When...
  • Blog Post: How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!

    This issue was puzzling until we stepped through the code and studied it in some detail.   The report was “SQL Server won’t use the physical memory I expect it to use.” Scenario:   SQL Server 2008 R2, 32GB RAM  - SQL only using ~22GB of total memory and won’t use anymore. Let me try...
  • Blog Post: SQL Server TempDB – Number of Files – The Raw Truth

    I continue to answer questions about the number of TEMPDB files and trace flag –T1118.   It seems there are plenty of advice blogs, wikis, articles and other resources.   To help clarify this I am going to post my latest e-mail exchange. From: Robert Dorr Sent: Thursday, June 04,...
  • Blog Post: How It Works: What Are The Event Source Names Used By SQL Server

      Sent: Tuesday, March 17, 2009 4:24 AM Subject: Event Source changed from MSSQLServer to MSSQLSERVER to all upper case   Our different SQL server versions write to the Eventlog in a mixture of upper/lower case.  One version writes as Event Source “MSSQLServer” the other one...
  • Blog Post: How to copy DTS 2000 packages between servers (and from SQL 2000 to SQL 2005 and SQL 2008)

    I was posed the question today, how do I migrate my SQL Server 2000 DTS packages to a SQL 2005 Server without upgrading them, thus leaving them as legacy DTS 2000 packages within SQL 2005? In other words, how do I copy or move DTS 2000 packages into SQL Server 2005... If you did an in-place upgrade...
Page 1 of 1 (6 items)