Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

T-SQL

Table Valued Parameters in Stored Procedures
Posted in
  • T-SQL

Table Valued Parameters in Stored Procedures

In most cases stored procedures are developed so that it accepts a number of input parameters … Table Valued Parameters in Stored ProceduresRead more

by Tomas Lind•2014/05/012014/04/28•0
Posted in
  • T-SQL

NULL and aggregates

An aggregate in SQL Server will ignore NULL values. Check out this simple demonstration to learn … NULL and aggregatesRead more

by Tomas Lind•2014/03/182014/03/14•2
Posted in
  • T-SQL
  • Windows OS

Add and edit Windows environment variables

Windows environment variables are a great way to store server specific information that may be accessed … Add and edit Windows environment variablesRead more

by Tomas Lind•2014/01/082014/01/08•0
Posted in
  • Dynamic Management Objects
  • T-SQL

sp_describe_first_result_set

The system stored procedure sp_describe_first_result_set was introduced in SQL Server 2012 and it returns meta data … sp_describe_first_result_setRead more

by Tomas Lind•2013/11/282013/11/29•0
Posted in
  • T-SQL
  • Technical Analysis (TA)
  • Window function

Bollinger Bands in T-SQL

Bollinger Bands® is a technical analysis tool trademarked by its inventor, John Bollinger. The basis for … Bollinger Bands in T-SQLRead more

by Tomas Lind•2013/11/122013/11/12•0
Posted in
  • T-SQL
  • Technical Analysis (TA)

Relative Strength Index RSI in T-SQL

The relative strength index (RSI) is a calculation in TA (Technical Analysis) which measures the strength … Relative Strength Index RSI in T-SQLRead more

by Tomas Lind•2013/11/072013/11/07•16
Posted in
  • T-SQL
  • Technical Analysis (TA)

MACD in T-SQL

The MACD (Moving Average Converenge Divergence) is a calculation in technical analysis used as a indicator … MACD in T-SQLRead more

by Tomas Lind•2013/11/052014/10/27•11
Posted in
  • T-SQL
  • Technical Analysis (TA)

Exponential moving average in T-SQL

Exponential moving averages are similar to weighted moving averages in that they assign less weight to … Exponential moving average in T-SQLRead more

by Tomas Lind•2013/10/302013/12/20•4
Posted in
  • Execution Plan
  • Index
  • T-SQL
  • Tips & Tricks

Large Inserts and count(*)

If you insert lots of rows into a table with a clustered index, a SELECT COUNT(*) … Large Inserts and count(*)Read more

by Tomas Lind•2013/10/172015/10/26•0
Posted in
  • Management Studio
  • T-SQL
  • Tips & Tricks
  • Uncategorized

Line numbers in t-sql error messages

When you run scripts in SSMS and get an error, the error references a line number … Line numbers in t-sql error messagesRead more

by Tomas Lind•2013/10/152013/10/30•0

Posts pagination

Previous 1 2 3 Next

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • CDC Capture job
  • How to align columns in Notepad++
  • Export data from Excel to SQL Server
  • Manual failover in a SQL Server cluster

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software