user avatar
user avatar
user avatar
Neil P
  • Member for 7 years, 9 months
  • Last seen more than a month ago
5 votes
Accepted

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

4 votes
Accepted

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

2 votes
Accepted

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

2 votes

Are nonclustered indexes used when joining tables?

1 vote
Accepted

The target principal name is incorrect. Cannot generate SSPI context

1 vote

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

1 vote
Accepted

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

1 vote
Accepted

SSIS - The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

1 vote

how can I ignore duplicate inserts?

0 votes

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

0 votes

Help with relational database design

0 votes
Accepted

Rank function creating duplicate partitions? (two rank 1's for the same key)

0 votes

Change Tracking across several Tables