tsql

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

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

Latest blogosphere posts tagged “tsql”

 

• 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

• How to Administer a SQL Azure Database?

  
  — Authority:
  As Microsoft continues to develop and promote their cloud-based SQL services, database administrators will have to become adept at administering their company’s Azure-based assets. If you’re a “reluctant DBA” – someone tasked with managing databases just because you’re “the Microsoft … Continue Reading
  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

• Atlanta SQL Saturday PreCon

  
  — Authority:
  At the upcoming SQL Saturday in Atlanta, GA I have the honor of delivering a precon on database security which has several seats still available. This precon is a full day session where we will be talking about all the security best practices. Signing up for the precon is pretty simple, just do to the URL for the ...
  2 weeks ago

• SQL Server NTILE Function

  
  — Authority:
  The SQL Server NTILE() function divides the result set into a specified number of even sized group (approximate division) and assigns a ranking value to these groups. The NTILE() function is similar to other ranking functions like the RANK() and DENSE_RANK() , except that NTILE takes one parameter of type ...
  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

• Pro T-SQL 2012 Programmer’s Guide, 3rd Edition

  
  — Authority:
  Pro T-SQL 2012 Programmer’s Guide, 3rd Edition Pro T–SQL 2012 Programmer’s Guide  is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL ...
  3 weeks ago

• Why We Write #4 - An Interview With Doug Lane

  
  — Authority:
  My next guest is Doug Lane , who has been blogging for the past few years on his website: http://www.douglane.net/ . Doug is also a speaker who has spoken at SQL Saturdays as well as the SQL PASS Summit , and as I write these interview questions was on his way to speak at the SQL PASS Business Analytics conference in ...
  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

• SQL Server Management Objects 2008 (SMO) New Features

  
  — Authority:
  MSDN defines SMO as - SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server . In this article we will practically explore some features of SQL Server Management Objects . To start with, let’s create a ‘Windows ...
  5 weeks ago

• DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

  
  MSSQLFUN — Authority: 119
  sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx Returns information about the queries that have acquired a memory grant or that still require a memory grant to execute. Queries that do not have to wait on a memory ...
  5 weeks ago

Comments about tsql