PASS Book List
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
559 reads
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
559 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
570 reads
I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things...
2009-09-22
757 reads
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
653 reads
Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the...
2009-09-22
849 reads
I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into....
2009-09-22
1,304 reads
OPASS met last Tuesday, September 14th, with a mini (15 minute) presentation by Todd Holmes on Backup Basics and Jorge...
2009-09-22
441 reads
It’s often said that a major discrepancy between estimated and actual row counts in a query’s execution plan is a...
2009-09-22
2,341 reads
I tried out Bing’s new visual search after seeing a few people note it on Twitter. I was a little...
2009-09-22
1,068 reads
SQL Server security expert, John Magnabosco, has just authored the new book, Protecting SQL Server Data, the first book of...
2009-09-22
721 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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