Register Log in

TSQL

Articles tagged TSQL

Blogs
in Blogs

What’s new in T-SQL in SQL Server 2022

There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well and they usually are left...

8 min read
in Blogs

Count Distinct and Window Functions

Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t work with Window Partition Preparing...

7 min read

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as...

31 min read

TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask

SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It...

31 min read

Producing JSON Documents from SQL Server queries via TSQL

Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe,...

24 min read

On Handling Dates in SQL

The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical conventions. The handling of dates...

16 min read

Generating Test Data in TSQL

To test SQL, you need test data. There are usually many reasons why you can't use production data. Although it is usually enough to use...

30 min read

Preparing to Upgrade your SQL Server

It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to a server with a newer...

17 min read

Getting Started Testing Databases with tSQLt

There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is...

22 min read

TSQL Pivot Rotations using only REPLACE

Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the job done without GROUP BY...

8 min read

Some Books on Programming SQL Server 2012

It is a measure of the range of facilities that are available to the database developer nowadays that three different books on the same general...

12 min read

Registered Servers and Central Management Server Stores

SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered Servers are typical: poorly documented,...

14 min read

The Seven Sins against TSQL Performance

There are seven common antipatterns in TSQL coding that make code perform badly, and three good habits which will generally ensure that your code runs...

15 min read

SQL Scripts Manager and IronPython

As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities...

10 min read

The TSQL of CSV: Comma-Delimited of Errors

Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files;...

20 min read

Exploring SSIS Architecture and Execution History Through Scripting

When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for...

12 min read

Automated Script-generation with Powershell and SMO

In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases, Phil Factor demonstrates how one...

24 min read

Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting

DBAs are usually charged with the administration of Reporting Services, but are often short on guidance on how to go about such tasks as planning,...

17 min read

SQL Server Functions: The Basics

SQL Server's functions are a valuable addition to TSQL when used wisely. Jeremiah provides a complete and comprehensive guide to scalar functions and table-valued functions,...

41 min read
T-SQL Programming
in T-SQL Programming

CLR Performance Testing

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go about testing the relative performance...

19 min read