Viewing 15 posts - 106 through 120 (of 812 total)
set CONTEXT_INFO 55
SELECT cast(substring(CONTEXT_INFO(),1,4) as int)
February 27, 2018 at 12:59 am
February 1, 2018 at 10:15 am
Steve Jones - SSC Editor - Thursday, February 1, 2018 7:46 AMCorrected the answers. Not sure what I was thinking while typing.
......
February 1, 2018 at 7:58 am
GRANT VIEW SHOWPLAN to JoeDevMsg 102, Level 15, State 1, Line 1
Incorrect syntax near 'VIEW'.
February 1, 2018 at 1:30 am
January 8, 2018 at 3:31 am
January 3, 2018 at 1:29 am
December 29, 2017 at 1:59 am
Good to know!
I would add a where clause to avoid empty stringDECLARE @a VARCHAR(6) = 'ABCDEF'
SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY)...
December 11, 2017 at 1:00 am
October 5, 2017 at 1:10 am
Rune Bivrin - Friday, September 29, 2017 12:04 AMBzzzt!
Tht's true! I agree.
September 29, 2017 at 1:44 am
Just to add:
There is different behavior on SQL-Server 2012....
September 26, 2017 at 8:41 am
Here the script:
CREATE TABLE dbo.LotsofIntegers1 (ID INT) WITH (DATA_COMPRESSION = PAGE);
CREATE TABLE dbo.LotsofIntegers2 (ID BIGINT) WITH (DATA_COMPRESSION = ROW);
CREATE TABLE dbo.LotsofIntegers3 (ID BIGINT) WITH...
September 26, 2017 at 2:07 am
Another "bug" is when you rename a stored procedure and run sp_helptext.
It returns the create of stored proc with the old name:
create procedure A
as
select 1 as...
September 25, 2017 at 1:48 am
Viewing 15 posts - 106 through 120 (of 812 total)