sql query

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

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

Latest blogosphere posts tagged “sql query”

 

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

• SQL SERVER – Adding Column Defaulting to Current Datetime in Table

  
  SQL Server Journey with SQL Authority — Authority: 548
  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 – A New Approach to Scale .NET Applications

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

• Squel.js: create a SQL query using javascript

  
  — Authority:
  Sometimes we just can not know how our SQL-query will look , because some requests should be created dynamically. Or you can look for a solution that would make your SQL-statements more understandable. Squel.js is a miniature javascript-library that helps you to create sql-queries through OO (object-oriented) API. ...
  1 week ago

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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 ...
  1 week ago

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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 ...
  1 week ago

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

• Functions and WHERE clause and suboptimal query plans

  
  — Authority:
  Using functions in WHERE clauses can cause query performance problems. The query optimizer attempts to create a cardinality estimate. If the Optimizer does not know the value to look up – it will base the cardinality estimate on the average per distinct value. It is more than likely using the average of every ...
  2 weeks ago

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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 ...
  2 weeks ago

• SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database

  
  SQL Server Journey with SQL Authority — Authority: 548
  Here is an email I received during the weekend. “Hi Pinal, I am a senior tester in the leading organization and we have two different environments 1) Testing 2) Production. As a part of the testing we want to insert garbage data into the database system and see how the application behaves in this scenario. ...
  2 weeks ago

• SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

  
  SQL Server Journey with SQL Authority — Authority: 548
  Earlier this week Microsoft have released two very interesting downloads which got my attention. Haddop , PowerPivot and PowerView all three are not directly related to traditional RDBMS but their important is growing in the industry as big data is taking over market . The Microsoft SQL Server SQOOP Connector for ...
  3 weeks ago

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

  
  SQL Server Journey with SQL Authority — Authority: 548
  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 ...
  3 weeks ago

• SQL SERVER – UNION ALL and UNION are Different Operation

  
  SQL Server Journey with SQL Authority — Authority: 548
  I have previously written about the difference between UNION ALL and UNION multiple times over this blog but it seems like this question never gets old and I keep on getting the question again and again. UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL Difference Between Union vs. ...
  3 weeks ago

• SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2

  
  SQL Server Journey with SQL Authority — Authority: 548
  “How do I return a  few of my resultset rows at the bottom of the entire resultset?” I was previously asked this question and my response was that we can do this by using the CASE statement in the ORDER BY clause and I wrote a blog post describing the same over here  SQL SERVER – Return Specific Row to at ...
  3 weeks ago

Comments about sql query