You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
This article explores the place of emotion among knowledge workers doing team-based design activities.
The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.
SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.
Cloud services need to have a much higher quality of work than their in-house equivalents if corporations are to take them seriously according to Steve Jones.
Bulk Insert statement has an important feature of error logging which is rarely used.
SQL Saturday is coming to Chicago, IL on April 13, 2013. Join us for a day of free SQL Server training and networking.
For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.
The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned
Data could be the way that more decisions are made, separating the competent from the incompetent in the future. Steve Jones isn't sure this is the best way to make decisions if we don't include a human element in the decision process.
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
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