The Quickest Way To Get SQL Command Help
Every once in a while I discover a SQL Server Management Studio trick that's apparently been around forever but is completely new to me.
Today I want to point out...
2017-10-31
11 reads
Bert Wagner
10 Questions To Spark Conversation At Your Next SQL Event
Photo by rawpixel.com on UnsplashHere’s a word for word transcription of a conversation I’ve had a hundred times over:
“Hi I’m Bert. What do...
2017-10-24
178 reads
10 Questions To Spark Conversation At Your Next SQL Event
Photo by rawpixel.com on Unsplash
Here's a word for word transcription of a conversation I've had a hundred times over:
"Hi I'm Bert. What do you do?"
"I'm ____ and I'm a SQL developer."
"That's cool,...
2017-10-24
12 reads
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...
2017-10-17
199 reads
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...
2017-10-17
11 reads
How NOLOCK Will Block Your Queries
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
389 reads
How NOLOCK Will Block Your Queries
Photo by James Sutton on Unsplash
Note: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK hints. The fact that it applies to NOLOCK queries...
2017-10-10
15 reads
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
146 reads
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...
2017-10-03
9 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,723 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCU TARAKAN Tlp/Wa_Cs:0817-866-887
Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan, Kalimantan Utara...
Alamat kontak resmi BCA KCP Fatmawati Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota Jakarta Selatan,...
Alamat kontak resmi BCA KCU SUNTER Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18, Sunter Agung, Kec....
Question of the Day
QUOTENAME Quote Parameters
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