Viewing 15 posts - 91 through 105 (of 819 total)
October 31, 2018 at 2:47 am
Interesting!
Also, you don't need to drop the entire table, you can drop sparse columns and re-add them with the ALTER TABLE command
CREATE TABLE UserConfig
(...
September 18, 2018 at 12:53 am
September 11, 2018 at 2:55 am
September 11, 2018 at 1:14 am
I did not know that I could drop more than one...
July 31, 2018 at 12:54 pm
July 24, 2018 at 4:02 am
June 29, 2018 at 1:42 am
June 26, 2018 at 10:11 am
From BOL:
To enable backup checksums in a BACKUP statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option. This is the...
June 25, 2018 at 4:45 am
May 22, 2018 at 3:01 am
From BOL:
Remarks
When you drop an event session, all configuration information, such as targets and session parameters, is completely removed.
May 7, 2018 at 1:55 am
But from my experience and test on SQL2017... In the end of the...
May 2, 2018 at 6:29 am
Japie Botma - Tuesday, April 10, 2018 12:59 AMSo TRY_CAST is a new function. Maybe you should specify the version. 🙂
No, it's...
April 10, 2018 at 1:10 am
This applies only to uniqueidentifier. For variables of type char, varchar, etc. not.
I created the table 'aaa' in tempdb which has a binary collation.
I created a db...
April 5, 2018 at 2:39 am
March 27, 2018 at 2:06 am
Viewing 15 posts - 91 through 105 (of 819 total)