SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files....
2017-09-01
573 reads
Blog Posts
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
412 reads
Automatic Seeding & Compression
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-31
997 reads
Azure Archive Blob Storage
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,032 reads
Bulk Inserting Build Data–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-31
680 reads
Information Measurement with SQL Server, Part 2.1: The Uses and Abuses of Shannon’s Entropy
By Steve Bolton
…………In the first installment of this wide-ranging series of amateur tutorials, I noted that the Hartley function indeed...
2017-08-31
925 reads
New in SQL Server 2017: Graph Databases
David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you...
2017-08-31 (first published: 2017-08-21)
2,668 reads
SQL Server: SARGability
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....
2017-08-31
4,215 reads
Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...
2017-08-31 (first published: 2017-08-18)
3,793 reads
Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
698 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU JEMBER Telp/Wa:0817.839.777
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
BCA KCU INDRAPURA Telp/Wa:0817839777
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Displaying Money
Comments posted to this topic are about the item Displaying Money
Question of the Day
Displaying Money
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