Configure Read only routing for an always on availability group
One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...
2018-03-05
668 reads
SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
295 reads
Using the Analysis Services Execute DDL Task
My grandfather used to say, “There’s more than one way to skin a cat.” I always thought it was a...
2018-03-08 (first published: 2018-03-02)
4,822 reads
YouTube Channel Update
Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...
2018-03-02
325 reads
Reporting services error: User XXXX does not have required permissions
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
283 reads
Data Masker for SQL Server–Syncing Values Across Rows
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-12 (first published: 2018-03-02)
2,287 reads
What is the CXPACKET Wait Type?
This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...
2018-03-02
864 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
162 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-12 (first published: 2018-03-02)
5,298 reads
Use Filtered Statistics to Improve Performance on Very Large Tables
Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...
2018-03-02
414 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