February 2006 - Posts

Quick Reference Cards in PDF format

Okay - although this is tangential to SQL Server itself, I thought this link may be of interest for those SQL Server professionals that dabble in other programming paradigms.  This site includes links to quick reference cards (in PDF format).  Syntax references for JSP, C, Java, C++, Perl, PHP, UML, XML and more.  I'm sad that Transact-SQL isn't in that list, nor .NET - but perhaps someone out there in web-land will fill that gap.

posted Tuesday, February 28, 2006 9:27 AM by joe.sack with 0 Comments

Don't use disk compression with SQL Server files

Using compressed volumes with SQL Server can impact both performance and recoverability.  For more details, check out the Microsoft Knowledge Base Article:

http://support.microsoft.com/kb/231347/en-us

 

 

posted Monday, February 20, 2006 10:00 AM by joe.sack with 1 Comments

SQL Profiler Events: The difference between RPC:Completed and SP:Completed

Ever wondered what the difference was between the RPC:Completed and SP:Completed SQL Profiler events?  Andrew J. Kelly, SQL MVP, gives an excellent explanation here.

posted Friday, February 10, 2006 2:27 PM by joe.sack with 0 Comments