sql server 2008

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

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

Latest blogosphere posts tagged “sql server 2008”

 

• 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 […]
  1 week ago

• SQL Server Upserts – Using MERGE to INSERT or UPDATE Table Rows

  
  — Authority:
  The idea of an Upsert was added in the SQL 2003 standard for databases and is implemented using a MERGE statement in both Oracle and SQL Server. So You Might Ask: What is an Upsert? An Upsert does pretty much does what it sounds like: it runs an update on a row where a condition […]
  1 week ago

• SQL Saturday #200 - Philadelphia

  
  — Authority:
  If you read my post from yesterday you will know I will be spending some time on the US east coast at the end of May.Last week my friend and fellow Learning Tree instructor Sharon Dooley asked me if I would like to attend SQL Saturday #200 in Philadelphia which is being organised by the Philadelphia User group. Seeing ...
  1 week ago

• SQL Server 2008 Diagnostic Information Queries (May 2013)

  
  — Authority:
  Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries , with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008. To go with it is an updated, blank 2008 results spreadsheet , where the ...
  1 week ago

• SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

  
  — Authority:
  Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries , with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2. To go with it is an updated, blank 2008 R2 results spreadsheet , ...
  1 week 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 / [...]
  2 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 ...
  2 weeks ago

• .NET Based CMS Alternatives To WordPress

  
  — Authority:
  .NET Based CMS Alternatives To WordPress In this article we will look at a few alternatives to WordPress, in particular we are looking for a Microsoft .NET based alternative. The WordPress Standard This website happens to use WordPress and I have been using it for several years, and have a good idea of what a good CMS ...
  3 weeks ago

• Elegant Random Number List in SQL Server

  
  — Authority:
  Coded using: Visual Studio Express 2012 for Web, .Net Framework 3.5, C#, SQL Server 2008 R2 SQL Server has limited functionality for generating random numbers. C# on the other hand has an elegant and easy-to-use function. Using SQLs Common Language Runtime (CLR)  makes it a snap to add this C# functionality to your ...
  3 weeks ago

• SELECT from PROCEDURE – Prozeduren in Abfragen verwenden

  
  — Authority:
   Prozeduren lassen sich nicht in SELECT Statements verwenden. Sie müssen ausgeführt werden. Im Prinzip eine sehr logische Sache, da Prozeduren einerseits mehrere Ergebnistabellen zurückgeben könnte bzw. – wenn nur INSERT, UPDATE oder DELETE Statements ausgeführt werden würden – auch gar nichts [...] ...
  4 weeks ago

• Straight Forward Random Numbers in SQL Server

  
  — Authority:
  Coded using: Visual Studio Express 2012 for Web, .Net Framework 3.5, C#, SQL Server 2008 R2 SQL Server has limited functionality for generating random numbers. C# on the other hand has an elegant and easy-to-use function. Using SQLs Common Language Runtime (CLR)  makes it a snap to add this C# functionality to your ...
  4 weeks ago

• Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !

  
  — Authority:
  The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP1.     Those who are facing severe issues with their environment, they ...
  4 weeks ago

• New SQL Server Cumulative Updates

  
  — Authority:
  Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012. The first one is SQL Server 2008 R2 SP1 CU12 , which is Build 10.50.2874. This CU has seven fixes in the public fix list. The second one is SQL Server 2008 R2 SP2 CU6 , which is Build ...
  4 weeks ago

Comments about sql server 2008