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,302 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,951 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,344 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,959 reads

One of the first things I review when I inherit a new SQL Server...

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

I’ve had a Dropbox account for years. Like a lot of people, I started...

hi a peer of mine who ive never known to be wrong says a...

Comments posted to this topic are about the item Displaying Money

Comments posted to this topic are about the item The Slow Growing Problems

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros