Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 1237    Older >>
 

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,153 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2016/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,972 reads

The Bones of SQL - The Holiday Table

This second part to a previous article on Calendar table generation shows how to create a holiday table containing both fixed-date and variable-date holidays.  Read more...
By Bob Hovious 2016/09/19 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,829 reads

A Case FOR Cursors...

We've all heard that definitive statement: "Avoid using cursors." But, in my opinion, what really should be conveyed is: "Avoid using row-by-row operations when possible."  Read more...
By Chris Jones 2016/09/09 (first published: 2015/06/01) | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 12,567 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2016/08/26 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 14,030 reads

Using Microsoft R in Enterprise Environments

This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.  Read more...
By Tomaž Kaštrun 2016/08/25 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,663 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2016/08/23 | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 2,265 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2016/08/19 (first published: 2015/06/23) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,641 reads

Simple T-SQL Code Comparison With PowerShell

Tim Smith shows how you can use PowerShell to automate a simple comparison of objects such as stored procedures, views, and fucntions.  Read more...
By Additional Articles 2016/08/17 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,205 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice

One of the best ways in which you can build better applications is by learning to write better T-SQL. Mickey Stuewe begins a new series showing how you might start to think about writing queries.  Read more...
By Mickey Stuewe 2016/08/12 (first published: 2015/06/02) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 15,350 reads

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2016/07/29 (first published: 2014/07/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,533 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios.  Read more...
By Gregory Larsen 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,520 reads

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2016/07/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,207 reads

Configuring geo-replication for an Azure SQL Database

This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.  Read more...
By Arun Sirpal 2016/06/27 | Source: SQLServerCentral.com | Category: geo-replication
Rating: |  Discuss |   Briefcase | 512 reads

Nasty Fast N-Grams (Part 1): Character-Level Unigrams

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.  Read more...
By Alan Burstein 2016/06/23 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 1,962 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2016/06/10 (first published: 2015/04/02) | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 20,425 reads

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2016/06/07 | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 3,637 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,201 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2016/05/27 (first published: 2015/02/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 24,928 reads

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers.  Read more...
By Jason Brimhall 2016/05/13 (first published: 2014/03/04) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 12,895 reads
   Items 1 to 20 of 1237    Older >>