Viewing 15 posts - 121 through 135 (of 819 total)
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
September 8, 2017 at 12:48 am
August 30, 2017 at 2:08 am
July 17, 2017 at 3:28 am
July 12, 2017 at 1:01 am
Confused question!
If the author intended the primary key is clustered, this apply (from BOL):
When a constraint that created a clustered index is deleted, the data rows that...
July 11, 2017 at 1:56 am
June 21, 2017 at 6:43 am
Viewing 15 posts - 121 through 135 (of 819 total)