Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Neil P's user avatar
Neil P's user avatar
Neil P's user avatar
Neil P
  • Member for 9 years, 8 months
  • Last seen this week
13 votes
1 answer
7k views

How to index for inequality queries?

12 votes
1 answer
8k views

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

8 votes
5 answers
10k views

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

6 votes
4 answers
13k views

Delete into new table (like select into)

4 votes
1 answer
2k views

Is rowversion unique across the database? Or per table?

4 votes
3 answers
3k views

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

4 votes
1 answer
154 views

Does Azure SQL DW support partitioned views?

3 votes
1 answer
2k views

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

3 votes
1 answer
517 views

Do synonyms affect remote query performance

3 votes
1 answer
9k views

SSIS - insert system date variable as a execute sql task parameter

3 votes
5 answers
11k views

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

2 votes
1 answer
982 views

How to ignore columns in parquet/polybase import?

2 votes
1 answer
535 views

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

2 votes
1 answer
481 views

Row level security in SQL Server 2016 with a normalised schema

2 votes
2 answers
2k views

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

2 votes
1 answer
330 views

Why does my columnstore index not fill the entire rowgroup?

2 votes
3 answers
4k views

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

2 votes
1 answer
2k views

How to determine if an SSRS data driven subscription job has completed

2 votes
0 answers
122 views

Why does outer apply cause a broadcast move?

1 vote
0 answers
289 views

Output result of DBCC PDW_SHOWEXECUTIONPLAN into a variable

1 vote
1 answer
55 views

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

1 vote
1 answer
51 views

How to index cube style queries with changing aggrigations

1 vote
1 answer
199 views

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

1 vote
2 answers
803 views

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

1 vote
1 answer
1k views

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

1 vote
2 answers
3k views

How to force/require TLS connections on SQL Azure

1 vote
1 answer
929 views

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

1 vote
1 answer
1k views

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

1 vote
1 answer
531 views

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

1 vote
0 answers
812 views

SQL Server 2016 - row level security by AD group membership