t sql

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

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

Latest blogosphere posts tagged “t sql”

 

• SQL SERVER – Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards

  
  — Authority:
  Have you ever worked with CONCAT_NULL_YIELDS_NULL earlier in your career? If yes, you will find this post very interesting. If you have not worked with this function before I think this post will teach you something very interesting. Before we start please note that as per SQL Server official ...
  1 week ago

• SQL SERVER – Weekly Series – Memory Lane – #028

  
  — Authority:
  Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. 2007 ...
  1 week ago

• 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 – Adding Column Defaulting to Current Datetime in Table

  
  — Authority:
  Presenting a technical session is a greatest experience one can have and I enjoy doing the same. While I write this blog post, I am presenting at Great Indian Developer Summit in India. The event is a grand success and I am having a great time at this event. One of the questions which I often receive is how do one ...
  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 SERVER – A New Approach to Scale .NET Applications

  
  — Authority:
  In a previous article , I wrote about scale-up vs. scale -out architectures using SQL Server and NuoDB as examples.  NuoDB recently announced the general availability of their latest product release, 1.1, and it looks like they’ve made significant progress in improving their Microsoft support. NuoDB now ...
  1 week ago

• SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051

  
  — Authority:
  This is the 51th episode of SQL in Sixty Seconds Video and we will see in this episode how to RESEED identity of the table column. Identity column is every increasing (or decreasing) value based on the interval specified in its property. In today’s SQL in Sixty Seconds video we will see that how we can reseed the ...
  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
  2 weeks ago

• SQLAuthority News – Sharding or No Sharding of Database – Working on my Weekend Project

  
  — Authority:
  Recently I came across situation where database sharding was once again a suggested solution by architectures. Everytime I hear the word sharding I remember my earlier article about NuoDB on  Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database . Sharding requires developers to think ...
  2 weeks ago

• SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP

  
  — Authority:
  Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure  it became trivial. Here’s what you basically need to do: Once   SQLBackupAndFTP with Azure   is installed , click at “ Connect to SQL Server / Azure ” button and specify connection ...
  2 weeks ago

• SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation

  
  — Authority:
  Sometime I feel I know a lot about SQL Server and very next moment, I realize that honestly I do not know much about this product. Earlier today, I had similar moments. I was playing with few DMVs and suddenly I ended up on the DMV sys.dm_xe_map_values. There are only four columns and one of the columns is a GUID. ...
  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 / [...]
  2 weeks ago

• SQL SERVER – Weekly Series – Memory Lane – #027

  
  — Authority:
  Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. 2007 ...
  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 – DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement

  
  — Authority:
  This blog post is inspired from my earlier blog post of UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement . In the blog post I discussed about how we can use JOIN and multiple tables in the UPDATE statement. There were plenty of the emails after this blog post ...
  2 weeks ago

• SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore

  
  — Authority:
  I will be presenting once again 3 Technical Sessions on SQL Server and Performance Tuning at Great Indian Developer Summit on May 7, 2013. If you are going to attend the event, you do not want to miss the technical sessions at any cost. Here is the generic theme for every session I will be presenting at Great Indian ...
  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

• SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course

  
  — Authority:
  Here are few of the question I often receive - Do you know anything besides SQL Server? So how does it feel when the only thing which you know is SQL Server? Have you worked in the past with any other programming language? Actually, I find these questions very interesting as I do work with other technologies ...
  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

• SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement

  
  — Authority:
  This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table. When asked the reason was he had no idea how to use multiple tables with the help of the JOIN clause in the UPDATE ...
  3 weeks ago

Comments about t sql