Profile Activity

Neil P

Meta user

Network profile

Reputation

1,062

1.1k
615
169

2016
2017
2018
2019

Top tag

sql-server

Next privilege

2,000 Rep.

Edit questions and answers

Badges

Newest

Notable Question

Next badge

32/100

Impact

0 posts edited

0 helpful flags

63 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

42 Questions

Views Newest Activity Votes

votes

answer

views

SQL Server - why are window functions not permitted in update statements?

sql-server sql-server-2014

Jan 4 '17 at 16:58 Doug Lane 598

votes

answer

views

How to index for inequality queries?

sql-server sql-server-2008-r2 index

Mar 31 '16 at 12:39 Paul White says GoFundMonica♦ 50.1k

votes

answers

views

sys.partitions row count is badly wrong - how to correct this?

sql-server partitioning azure-sql-data-warehouse

May 9 at 19:45 Alex KeySmith 255

votes

answers

views

Delete into new table (like select into)

sql-server t-sql

Feb 8 '16 at 13:40 Community♦ 1

votes

answer

108

views

Does Azure SQL DW support partitioned views?

azure-sql-data-warehouse

Jul 24 at 11:41 wBob 9,762

votes

answers

views

Are implicit transactions per batch or per session in SQL Server?

sql-server t-sql transaction

Jul 2 '17 at 17:31 Solomon Rutzky 55.8k

votes

answers

views

The column 'Date Offset' in table 'Date' has invalid bindings specified

ssas tabular-model ssas-2016

Aug 20 at 15:04 Laurenz Albe 7,766

votes

answer

954

views

Is rowversion unique across the database? Or per table?

sql-server

Sep 23 '16 at 9:25 Scott Hodgin 21.5k

votes

answer

647

views

Why does a table of varchar(255) columns take up less space than an identical table using the correct data types

sql-server sql-server-2014 datatypes

Aug 10 '16 at 15:35 Neil P 1,062

votes

answer

405

views

Do synonyms affect remote query performance

sql-server sql-server-2014

Dec 4 '15 at 2:41 Aaron Bertrand♦ 163k

votes

answers

views

Why does outer apply cause a broadcast move?

azure azure-sql-data-warehouse

Jan 19 '18 at 17:11 Neil P 1,062

votes

answer

379

views

Azure Sql data warehouse - is there any way to see the true query plan?

azure azure-sql-data-warehouse

Jul 26 '17 at 11:59 SqlWorldWide 9,128

votes

answers

views

How to add a check constraint in sql azure data warehouse?

azure-sql-data-warehouse

Jun 26 '17 at 17:16 ypercubeᵀᴹ 83.3k

votes

answer

355

views

Row level security in SQL Server 2016 with a normalised schema

sql-server sql-server-2016

Oct 9 '15 at 12:58 Aaron Bertrand♦ 163k

vote

answer

282

views

How to see what's using TempDb space in Azure SQL DW?

azure-sql-data-warehouse

Sep 23 at 9:01 Community♦ 1

vote

answers

946

views

How to force/require TLS connections on SQL Azure

azure-sql-database

Jun 12 '18 at 12:55 Alberto Morillo 1,262

vote

answer

353

views

Why is a round robin distribution better for a skewed dataset?

azure-sql-data-warehouse

May 18 '18 at 11:42 wBob 9,762

vote

answers

153

views

Why does a many to one merge join change the sort order of the data set?

sql-server query-performance optimization execution-plan azure-sql-data-warehouse

Apr 10 '18 at 6:51 KumarHarsh 1,320

vote

answer

139

views

How to achive a many to one merge join in Azure Data Warehouse

optimization execution-plan azure-sql-data-warehouse

Apr 4 '18 at 22:21 wBob 9,762

vote

answer

views

How to index cube style queries with changing aggrigations

query-performance execution-plan azure-sql-data-warehouse

Mar 11 '18 at 6:41 ArtBajji 191

vote

answer

views

select runs in batch mode, but CTAS runs in row mode

columnstore azure-sql-data-warehouse

Mar 5 '18 at 11:32 Neil P 1,062

vote

answers

101

views

Output result of DBCC PDW_SHOWEXECUTIONPLAN into a variable

azure-sql-data-warehouse sql-server-pdw

Feb 5 '18 at 17:58 McNets 19k

vote

answers

290

views

How make an SSAS Tabular model case sensitive?

ssas tabular-model ssas-2016

Aug 10 '17 at 9:30 Neil P 1,062

vote

answer

133

views

Clustered columnstore indexes - Do I need to create a non clustered index on a column that's used in a join? [closed]

columnstore azure-sql-data-warehouse

Jul 28 '17 at 17:07 Chad Cahill 124

vote

answer

588

views

SQL Data Warehouse - Is it possible to switch a whole table to a partition?

azure-sql-data-warehouse

Jul 7 '17 at 11:20 wBob 9,762

vote

answer

180

views

Why does my columnstore index not fill the entire rowgroup?

index columnstore azure-sql-data-warehouse

Jun 19 '17 at 15:22 Remus Rusanu 48.5k

vote

answer

570

views

Find all instances where a user has been explicitly granted permissions on an object

sql-server sql-server-2014 permissions

Mar 15 '17 at 4:21 Paul White says GoFundMonica♦ 50.1k

vote

answers

622

views

How to index a composite primary key with non-sequential inserts?

sql-server sql-server-2008-r2 index clustered-index

Jan 12 '17 at 20:05 paparazzo 4,755

vote

answers

568

views

SQL Server 2016 - row level security by AD group membership

sql-server sql-server-2016 row-level-security

Jun 10 '16 at 12:24 Max Vernon 59.6k

vote

answer

395

views

Configuring SQL Replication subscriber to a publisher in a different DNS zone

sql-server replication

Apr 14 '16 at 10:55 Neil P 1,062

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

42 Questions

SQL Server - why are window functions not permitted in update statements?

How to index for inequality queries?

sys.partitions row count is badly wrong - how to correct this?

Delete into new table (like select into)

Does Azure SQL DW support partitioned views?

Are implicit transactions per batch or per session in SQL Server?

The column 'Date Offset' in table 'Date' has invalid bindings specified

Is rowversion unique across the database? Or per table?

Why does a table of varchar(255) columns take up less space than an identical table using the correct data types

Do synonyms affect remote query performance

Why does outer apply cause a broadcast move?

Azure Sql data warehouse - is there any way to see the true query plan?

How to add a check constraint in sql azure data warehouse?

Row level security in SQL Server 2016 with a normalised schema

How to see what's using TempDb space in Azure SQL DW?

How to force/require TLS connections on SQL Azure

Why is a round robin distribution better for a skewed dataset?

Why does a many to one merge join change the sort order of the data set?

How to achive a many to one merge join in Azure Data Warehouse

How to index cube style queries with changing aggrigations

select runs in batch mode, but CTAS runs in row mode

Output result of DBCC PDW_SHOWEXECUTIONPLAN into a variable

How make an SSAS Tabular model case sensitive?

Clustered columnstore indexes - Do I need to create a non clustered index on a column that's used in a join? [closed]

SQL Data Warehouse - Is it possible to switch a whole table to a partition?

Why does my columnstore index not fill the entire rowgroup?

Find all instances where a user has been explicitly granted permissions on an object

How to index a composite primary key with non-sequential inserts?

SQL Server 2016 - row level security by AD group membership

Configuring SQL Replication subscriber to a publisher in a different DNS zone