Crosstabs over Pivots
I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data...
2014-09-02
2,067 reads
Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,613 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,370 reads
The Nine SQL Server Careers
Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post...
2014-09-02
1,536 reads
Celebrating One Year of Heraflux Technologies
Our company, Heraflux Technologies, celebrated its first birthday today on September 1st. A very sincere thank you goes to all...
2014-09-02
526 reads
Last Weeks Top “Reading” Links #99
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-09-01
360 reads
September 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. As with anything, just because it appears...
2014-09-01
513 reads
Business Intelligence Strategy – Beginning Steps
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...
2014-09-01
756 reads
Parameterization Part 3: Parameter Sniffing
This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...
2014-09-01
1,416 reads
Reblog: August 22 to August 28
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-08-29
1,373 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