SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

13,113 reads

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,926 reads

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,312 reads

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,897 reads

Even preparing for a class or seminar with set materials takes a lot of...

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

This image is from 2010, and it goes along with my last post of...

Hi I have an overnight process that moves allot of claims records Been working...

Comments posted to this topic are about the item Unlocking Data Transformation: My journey...

Comments posted to this topic are about the item Putting the Player with the...

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num