SQLServerCentral: Articles tagged T-SQL

The OUTPUT Clause for INSERT & DELETE Statements

In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements. Read more...

By Amarendra Reddy Thummeti 2017/05/25 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 4,545 reads

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL. Read more...

By Mark Wojciechowicz 2017/05/19 (first published: 2010/02/09) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 17,148 reads

Some of my greatest mistakes

You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game. Read more...

By David Poole 2017/05/18 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,842 reads

OUTPUT Clause Basics (For Inserts and Deletes)

When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how. Read more...

By Mat Richardson 2017/05/02 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,074 reads

Should I Type * or 1 With the EXISTS Logical Operator

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best. Read more...

By Viacheslav Maliutin 2017/04/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 3,343 reads

Nuance of datetime data type in SQL Server

One of the most confusing data types in SQL Server is the datetime datatype. Read more...

By Leo Peysakhovich 2017/04/13 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,938 reads

Performaing a Right and Comprehensive Age Calculation Part 2

Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted. Read more...

By Sergiy Floka 2017/03/30 | Source: SQLServerCentral.com | Category: age calculation

Rating:

|

Discuss |

Briefcase | 952 reads

Performing a Right and Comprehensive Age Calculation

Age calculation based on the right method used in real life. Read more...

By Sergiy Floka 2017/03/28 | Source: SQLServerCentral.com | Category: datetime conversions

Rating:

|

Discuss |

Briefcase | 1,780 reads

Adding Years, Months and Days

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation. Read more...

By Pete Revell 2017/03/14 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,257 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article. Read more...

By Brandie Tarvin 2017/03/07 | Source: SQLServerCentral.com | Category: database dependencies

Rating:

|

Discuss |

Briefcase | 962 reads

Detective Stories - Tracking Down the Database's Dependents Part I

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article. Read more...

By Brandie Tarvin 2017/03/06 | Source: SQLServerCentral.com | Category: database dependencies

Rating:

|

Discuss |

Briefcase | 1,250 reads

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences. Read more...

By M. Douglas Bowan II 2017/02/17 (first published: 2014/03/25) | Source: SQLServerCentral.com | Category: except

Rating:

|

Discuss |

Briefcase | 33,908 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them. Read more...

By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell

Rating:

Rate this |

Briefcase | 4,747 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions. Read more...

By Luis Cazares 2017/02/10 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 13,127 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 2017/02/10 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning

Rating:

|

Discuss |

Briefcase | 15,847 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods? Read more...

By Dwain Camps 2017/02/03 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge

Rating:

|

Discuss |

Briefcase | 37,233 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL? Read more...

By John Hick 2017/01/27 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 37,446 reads

Simpson's Paradox

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox. Read more...

By Mala Mahadevan 2017/01/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 3,319 reads