Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
6,153 reads
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
6,153 reads
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible...
2011-06-14
916 reads
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I...
2011-06-10
696 reads
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
647 reads
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
439 reads
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
524 reads
There will come a day, if it has not already come and gone, when you will want to search through...
2011-04-26
1,093 reads
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,127 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
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...
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