Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
717 reads
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
717 reads
I've been going back and forth with this question for a few days now.
If one instance in a multiserver query presents an...
2014-09-01 (first published: 2014-08-26)
6,268 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...
2014-08-25
39 reads
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,125 reads
Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...
2014-08-28 (first published: 2014-08-25)
7,624 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-25
685 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,571 reads
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However...
2014-08-25
626 reads
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...
2014-08-29 (first published: 2014-08-25)
6,951 reads
Now that I’ve finally started a new job (explains why I haven’t blogged for a while) I can discuss my...
2014-08-25
394 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