Measuring Query Execution Time: What Is Most Accurate
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,729 reads
Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you...
2018-08-28 (first published: 2018-08-13)
2,729 reads
There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that...
2018-08-27
359 reads
One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze...
2018-08-22 (first published: 2018-08-06)
2,627 reads
Why don’t “actual execution plans” have “actual execution plan costs”? This is a question and a myth I have to...
2018-08-20
314 reads
Working for a company based in the UK (still currently a part of the EU) I had a lot of...
2018-08-15 (first published: 2018-07-30)
2,680 reads
Over the last 18 months or so, I’ve spent a lot of time reading about the General Data Protection Regulation or GDPR. If you don’t know about it, you live under a rock, are a very old school dba, here’s a reference to the law itself. If you’re working as a data professional, I’d strongly […]
2018-08-06
89 reads
I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data...
2018-08-03
396 reads
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,066 reads
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
822 reads
I schedule many of my blog posts at least 2-3 weeks out, so I have time to adjust them, change,...
2018-07-16 (first published: 2018-07-09)
3,805 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