Viewing 15 posts - 91 through 105 (of 812 total)
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
DTUs provide a way to describe the relative capacity of a performance level based on a blended measure of CPU, memory, and read and...
March 22, 2018 at 2:32 am
bevanward - Saturday, March 17, 2018 11:21 AMComments posted to this topic are about the item Set-Based String Splitting table function
You ...
March 19, 2018 at 3:28 am
March 15, 2018 at 10:43 am
"The // operator is an integer division operator" that's false (-20). It's a FLOOR division (-21).
Learn the Syntax
March 14, 2018 at 2:21 am
Jeff Moden - Thursday, March 1, 2018 3:42 PMRIGHT(SomeIntZip+100000,5)
It's my favorite
March 2, 2018 at 1:24 am
SELECT FORMAT(COUNT(*),'#')
FROM HolydaysToDo
WHERE HolydaysToDo.Name = 'Steve Jones'
The result:
Arithmetic overflow error...
March 1, 2018 at 12:52 am
Viewing 15 posts - 91 through 105 (of 812 total)