Does a Primary Key always have stats_id 1?
Back to the SQL Server Basics with Wayne
The Myth
I recently was attending a presentation where the presenter stated that the...
2018-07-09 (first published: 2018-06-28)
2,454 reads
Mastering Index Tuning–Day 1
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-05 (first published: 2018-06-28)
2,722 reads
Use SSMS with a Different Windows Account – Back to Basics
Runas should be a very common tool in the toolbox of all IT professionals - not just Data Professionals. Learning how to test different accounts is essential to being...
2018-06-28
311 reads
Use SSMS with a Different Windows Account – Back to Basics
One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...
2018-07-06 (first published: 2018-06-28)
2,697 reads
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,676 reads
Notes From SQLSaturday Houston 2018
Various and possibly amazing notes:
Because I waited too long the best flight I could get was into George Bush instead...
2018-06-28
411 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning,...
2018-06-28
795 reads
Power BI Custom Visuals Class (Module 109 – as Timeline)
In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart...
2018-07-03 (first published: 2018-06-28)
2,878 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...
2018-06-27
1,742 reads
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
379 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