SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. As with most technologies, the best way of learning them is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.
Need to understand new data? This article explains why - and how you can profile it efficiently
Is there a sound technical reason why SQL Azure can't support extended properties?
Steve Jones talks a little about Oracle after speaking at an event devoted to that technology.
So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.
This week Steve Jones reminisces about the first software he used. He asks you what inspired you to start working with computers.
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
The buzz around NoSQL solutions has reached stratospheric heights. This buzz has led many Microsoft SQL Server development shops to start looking at how and where a NoSQL solution can fit into their business.
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed. Today's editorial was originally published on Nov 11, 2008. It is being re-run as Steve is out of town.
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers