Parameterization Part 2: Seven Ways to Execute Your Query
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,149 reads
Speaking at SQLSaturday #336 Holland
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
717 reads
Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model
On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server,...
2014-08-22
2,036 reads
Reblog: August 15 to August 21
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-08-22
1,029 reads
SQLSaturday Orlando Marketing Plan-Part 38
I just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still...
2014-08-22
494 reads
The ALS Ice Bucket Challenge
A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver...
2014-08-22
1,318 reads
Odds and Ends To Think About
Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but...
2014-08-22
588 reads
Friday Followup For August 22, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-22
385 reads
Silliness for an Important Cause
I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease...
2014-08-21
1,242 reads
SQLSat Birmingham: SQL Server Permissions and Security Principals
Thanks for attending my session today, SQL Server Permissions and Security Principals at 9:15AM!
Here's the link to a .zip file to...
2014-08-21
553 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers