I think Microsoft could partly address this by increasing the max DB size of SQL Server express to say 50 GB

I think this is unfair for at least three reasons:

1. Microsoft added Semantic Search to SQL Server 2012, this adds a lot of new functionality (see https://docs.microsoft.com/en-us/sql/relational-databases/search/semantic-search-sql-server?view=sql-server-2017 )

2....

• This reply was modified 5 years, 5 months ago by  William Rayer.

"Also, there is a 900 byte max key length that you have to stay within"

In SQL Server 2016 this has been increased to 1700 bytes for non-clustered indexes, see

• This reply was modified 5 years, 6 months ago by  William Rayer.
• This reply was modified 5 years, 6 months ago by  William Rayer.

In theory you could do the following:

1. Set up a FILESTREAM column to contain the DOCX files. This column could be in the existing table or you could create a...

• This reply was modified 5 years, 6 months ago by  William Rayer.

I would like to see an increase in the capacity of SQL Server Express (the free version). I suggest to increase the maximum amount of memory from 1GB to 2GB...

• This reply was modified 5 years, 6 months ago by  William Rayer.

I have come across this with complex SELECT statements using views that call other views that use scalar functions. One example I experienced during an upgrade was code that ran...

I will check it out. Actually the spreadsheet is useful as I can archive them and check them historically if jobs start clashing.

Just to say I have run this several times and copied the results into your template spreadsheet. It's extremely useful as it would be difficult to detect 'overlapping' jobs otherwise. Well done...

Dr Strangelove (it's black and white, and is kind of dark humour)

Are you sure SQL Server supports regexes in XQuery and XPath? From your link http://www.w3.org/TR/xpath-functions I realize the XQuery standards include regexes, but Microsoft left many things out from their...

I have struggled with this on-and-off over a number of years. Even though SQL Server and Excel are best-of-breed products that have been around for 20 years or more, it...

Putting aside for now the (important) issue of whether end-users should carry out index maintenance, this question is a good one. I understand it is asking: what's the easiest way...

I have worked with SQL Server for about 12 years. I like it and I'm not very familiar with NoSQL.

There is one exception: I have been playing with...

Why not run each TVF separately, capture the output to temporary tables, then join the temporary tables? You can optimize the performance of the final large join by adding suitable...

I think it would be a mistake to exclude SQLCMD. It's pretty small and if you don't have SSMS installed and you need to run some SQL commands, it could...