Browse by Tags

• Database Administration
• MSDN Forums

• Another use for the Default Trace: Mapping Temporary Tables to Sessions

  Here’s another use for the information captured by the default trace.  Ever wonder what session created the tables that exist in tempdb?  Well you can find it using the default trace and the sys.objects view in tempdb.  Any time an object Read More... Posted Tuesday, September 29, 2009 6:06 AM by Jonathan Kehayias | 3 Comments Filed under: Transact-SQL, Database Administration, Miscellaneous

• SQL Tip: Keep your Presentation Logic in your Presentation Layer

  Whether you are just starting out in SQL Server, or you have been working in SQL Server for many years, eventually in your work, you cross a boundary where someone will want data formatted in a different manner than it is stored in the database server. Read More... Posted Thursday, February 19, 2009 11:13 PM by Jonathan Kehayias | 1 Comments Filed under: Transact-SQL, MSDN Forums, Miscellaneous