sql server 2005

Welcome to the 'sql server 2005' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'sql server 2005'.

Are you an expert about 'sql server 2005'? Do you want to be the Technorati authority on 'sql server 2005'? You can write a description that will appear right here: Join Blogcritics!

Latest blogosphere posts tagged “sql server 2005”

 

• T-SQL – Get a Historical Record of SQL Statements Hitting a Table

  
  — Authority:
  Today I’ll review two useful queries that you can use to get information from SQL Server about what SQL statements are hitting one or more of your database tables. If you are interested in further T-SQL tips and tricks, please have a look through related articles I have written. The first query will check SQL […]
  2 weeks ago

• SQL Server 2005 Diagnostic Information Queries (May 2013)

  
  — Authority:
  Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries , with some minor tweaks and improvements to several of the existing queries. To go with it is an updated, blank 2005 results spreadsheet , where the tabs in the spreadsheet are labeled and in the same order as the queries. The idea ...
  2 weeks ago

• T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

  
  — Authority:
  In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim / [...]
  3 weeks ago

• T-SQL – Using the OUTPUT Clause to Get Identity Keys and Log Historical Data

  
  — Authority:
  The OUTPUT clause is a useful part of your T-SQL arsenal that has been added as of SQL Server 2005. You can use the OUTPUT clause in the same vein as @@IDENTITY, IDENT_CURRENT, or SCOPE_IDENTITY(), or even extend it to be a historical logging mechanism. Unlike @@IDENTITY, or SCOPE_IDENTITY(), you need to populate a ...
  3 weeks ago

Comments about sql server 2005