October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and webinar style. The start time is 6:30 PM Pacific...
2014-10-08
11 reads
October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and...
2014-10-08
637 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,306 reads
Fill Factor vs Page Splits – Measure It..!!
I have been trying to solve the puzzle of “How to evaluate my current Fill Factor setting?”, and there have...
2014-10-08
1,359 reads
Invite for #TSQL2sday #59 – My Hero!
It is T-SQL Tuesday again, for the 59th month in a row. Next month marks FIVE YEARS of T-SQL Tuesday,...
2014-10-13 (first published: 2014-10-08)
5,220 reads
Non-obvious APS/PDW benefits
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,083 reads
Beware the defaults! (in windowing functions)
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,648 reads
The full text error and why I was happy to see it.
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,166 reads
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
849 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
728 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