Friday Followup For October 31, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-31
872 reads
Lightning Talks at SQL Saturday?
We’re already in the early stages of preparing for our 2015 SQL Saturday. One thing that was missing from this year’s event was local speakers; we just didn’t have...
2014-10-31
21 reads
How to take Transaction Log backup ? TIP# 68
As we discussed in earlier tips how to take full backup and differential backup now in this tip we will...
2014-10-30
924 reads
How to Configure Search in SharePoint 2013 || Configure Search Topology in SharePoint 2013
Hello Friends,
I was getting lot of responses on blogs and mails. It will be difficult to cover all at once...
2014-10-30
2,006 reads
SQL Pass Summit 2014
Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...
2014-10-30
1,171 reads
Sort – Is it Really a Blocking Iterator?
SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.
A non-blocking iterator gets rows in and sends rows...
2014-10-30
1,333 reads
PASS Summit: Things to Do, People to See
PASS Summit is nearly upon us. I’m excited to be attending my second Summit in Seattle and cannot wait to get there to see everyone. With one Summit and...
2014-10-30
20 reads
Quick Schema Auditing
I was working on a demo recently and needed to show that a little monitoring can help you catch schema...
2014-10-29
1,138 reads
SQLSaturday Tampa Announced For February 28, 2015
SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at...
2014-10-29
1,275 reads
Headed to the PASS Summit 2014
I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the...
2014-10-29
1,054 reads
Blogs
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...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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