Throwback Thursday #2: Get Your Speak On!
I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I...
2013-11-28
1,108 reads
John Sterrett
I’m A SQL Server Rockstar Blogger!
SQL Server Rockstar Blogger
I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server...
2013-11-27
1,180 reads
Throwback Thursday #1: SQL Inspire
What Is Throwback Thursday?
One of my hobbies is being a turntablist. In high school I took a job just so...
2013-11-14
828 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,105 reads
Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find...
2013-10-14
1,391 reads
What Queries are Causing My Waits?
In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once...
2013-10-15 (first published: 2013-10-10)
4,260 reads
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
1,980 reads
Learn SQL Server Performance Tuning Basics in a Single Day
Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction...
2013-09-04 (first published: 2013-08-28)
2,619 reads
Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...
2013-08-15 (first published: 2013-08-07)
2,573 reads
First Look: Microsoft SQL Server 2014
Last week at TechEd 2013 in New Orleans Microsoft publicly released details about the SQL Server 2014 CTP 1. Here...
2013-06-11
1,809 reads
Blogs
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
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