Viewing 15 posts - 16 through 30 (of 50 total)
I think this is unfair for at least three reasons:
2. In principle...
June 24, 2019 at 1:31 pm
"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
May 30, 2019 at 8:33 am
In theory you could do the following:
May 29, 2019 at 12:16 pm
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...
May 20, 2019 at 8:19 am
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...
April 17, 2019 at 2:14 pm
I will check it out. Actually the spreadsheet is useful as I can archive them and check them historically if jobs start clashing.
February 22, 2019 at 3:19 am
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...
February 19, 2019 at 4:15 am
Dr Strangelove (it's black and white, and is kind of dark humour)
February 1, 2019 at 3:52 am
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...
December 17, 2018 at 3:49 am
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...
November 3, 2018 at 12:12 pm
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...
October 3, 2018 at 2:27 am
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...
August 14, 2018 at 3:31 am
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...
May 18, 2018 at 9:14 am
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...
March 13, 2018 at 7:16 am
Looks like a useful unit of measure for discussing UK property prices 🙂
March 13, 2018 at 6:45 am
Viewing 15 posts - 16 through 30 (of 50 total)