SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
62 reads
Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...
2017-11-28
237 reads
If there's one keyboard shortcut I use more than any other (with the exception of copy and paste) it would be the ALT + highlight multi-line edit/block selection shortcut.
Let's...
2017-11-28
14 reads
Photo by pan xiaozhen on UnsplashI had a great question submitted to me (thank you Brandman!) that I thought would make for a...
2017-11-21
428 reads
I had a great question submitted to me (thank you Brandman!) that I thought would make for a good blog post:
...I've been wondering if it really matters from a...
2017-11-21
15 reads
Photo by Louis Blythe on UnsplashHave you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you...
2017-11-14
307 reads
Have you ever wanted to find something that was referenced in the body of a SQL query?
Maybe you need to know what queries you will have to modify for...
2017-11-14
13 reads
Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on...
2017-11-07
335 reads
Photo by Jaanus Jagomägi on Unsplash
Interested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on Tuesday November 14, 2017 at 1PM Eastern at the...
2017-11-07
7 reads
Formula One …. F1 …. Photo by Jp Valery on UnsplashEvery once in a while I discover a SQL Server Management Studio trick that’s apparently...
2017-10-31
395 reads
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers