Transaction replication info
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
744 reads
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
744 reads
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
683 reads
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
605 reads
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,214 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,679 reads
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
982 reads
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
622 reads
Labor Day, which marks the unoffical end of Summer in the U.S., is particularly poignant in light of the news...
2009-09-08
866 reads
I’m going to Disney World! At least that’s what my kids will think when I tell them that I’m heading...
2009-09-08
324 reads
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
1,009 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