Pinal Dave Helps Me Fix My Performance Tuning Problems
Be sure to check out this week’s video on YouTube.
This week I was fortunate enough to film a video in...
2018-07-24
329 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
13 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
13 reads
AlwaysOn Dashboard uses System Policies
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
679 reads
Power BI Monthly Digest – July 2018
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...
2018-07-23
882 reads
Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
830 reads
Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
565 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
676 reads
Off on Holiday
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
846 reads
Processes can dramatically improve your work until they don’t.
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
181 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