Viewing 15 posts - 1 through 15 (of 42 total)
Happy with SSMS - I've grown used to it over the years and know how to find the things I need. The only thing I miss is the TSQL debugger...
December 4, 2020 at 9:18 am
Do your applications have to change their connection strings to connect to the new 2019 instance?
November 12, 2020 at 10:25 am
There used to be a real annual Turing Test called the Loebner Prize (see https://en.wikipedia.org/wiki/Loebner_Prize or https://www.chatbots.org/awards/loebner_prize/loebner_prize/ ). This had 4 judges, 4 AI's and 4 "real people"....
October 15, 2020 at 8:43 am
I have been migrating TSQL code from SQL 2008 to later versions. The code consists of complex SPs that call more SPs that call functions, and my tests were based...
July 21, 2020 at 11:09 am
You could try importing it as a blob (use OPENROWSET with SINGLE_BLOB), this should always succeed. But you would then need to parse the string before putting it into your...
May 21, 2020 at 11:35 am
I have used TSQL and SSIS and my thoughts are:
October 31, 2019 at 11:02 am
It can be difficult to link Excel and SQL Server and many different obscure errors are possible. The issue here is likely because you are running multiple imports at the...
October 28, 2019 at 11:28 am
I think Microsoft could partly address this by increasing the max DB size of SQL Server express to say 50 GB
September 24, 2019 at 11:10 am
I think this is unfair for at least three reasons:
2....
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
Viewing 15 posts - 1 through 15 (of 42 total)