SQL Server 2005 – Failed Maintenance Job
I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...
2017-08-27
303 reads
I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...
2017-08-27
303 reads
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
930 reads
Great week this week as I’ve been selected to speak at 4 of the SQL Relay events in October! Really...
2017-08-25
331 reads
Which better way could I have to launch my blog if not with great news ?!
I am so happy and excited to announce that I will be speaking at PowerShell...
2017-08-25
8 reads
In this blog we will discuss about how to check the details about Azure VM tiers and sizes. Microsoft Azure...
2017-08-25
522 reads
Hello all,In today's post I want to share a tip that helped me troubleshoot an issue I was facing and couldn't find much documentation about it. To my friends...
2017-08-25
8 reads
Hello all,
In today's post I want to share a tip that helped me troubleshoot an issue I was facing and...
2017-08-25
4,212 reads
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-24 (first published: 2017-08-15)
2,359 reads
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
909 reads
We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...
2017-08-24 (first published: 2017-08-14)
1,421 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means 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
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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 EurosSee possible answers