User Peter PitLock

18 votes

2 answers

21k views

Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'

asked Aug 20, 2013 at 10:15

14 votes

2 answers

29k views

Understanding varchar(max) 8000 column and why I can store more than 8000 characters in it

asked May 18, 2017 at 5:17

8 votes

1 answer

4k views

SQLPackage : Import or Export SQL Azure BACPAC without users

asked Apr 18, 2017 at 14:00

7 votes

3 answers

8k views

Running Total which Resets when Customer changes (keeping existing RowNumbers)- attempt included

asked Jun 26, 2013 at 14:43

7 votes

3 answers

381 views

Everyone warns against shrinking a database, but will it work in my case? 1 GB db with tables removed now 100 MB

asked Feb 18, 2013 at 12:57

6 votes

1 answer

23k views

Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS

asked Sep 5, 2014 at 7:47

5 votes

1 answer

982 views

After 5 years of working, SQL Server 2k5 Table now locking without any changes made to DB

asked Jun 11, 2013 at 14:09

4 votes

2 answers

7k views

Update row based on match to previous row

asked Feb 6, 2013 at 15:50

4 votes

1 answer

294 views

Advice on setting up a Reporting server

asked Nov 6, 2013 at 14:18

4 votes

1 answer

3k views

Why do I have to backup a transaction log twice for it to shrink?

asked Apr 7, 2017 at 6:42

3 votes

0 answers

366 views

VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping

asked Dec 3, 2015 at 11:02

3 votes

2 answers

295 views

Query has where (a = a) or (b = b) - the 2nd part causing index scan. Full example included

asked Oct 23, 2013 at 7:31

3 votes

2 answers

2k views

Can 2 tables lock each other if concurrent read/update do not affect same rows? pagelocks off

asked Jan 29, 2013 at 15:09

2 votes

1 answer

179 views

Can one assign a performance score to a stored proc to compare performance of 2 procs

asked Feb 7, 2013 at 13:39

2 votes

1 answer

945 views

Does rowlocks on index cause keylocks? : Transaction (Process ID xy) was deadlocked, example included

asked Feb 6, 2013 at 12:17

2 votes

1 answer

17k views

View all 32 possible Binary combinations for 5 digits

asked Sep 12, 2013 at 15:24

2 votes

1 answer

2k views

Inside stored procedure, set column names of returned query according to variable

asked Mar 31, 2014 at 7:58

2 votes

1 answer

601 views

Databases created with different collations - why?

asked May 17, 2016 at 6:42

2 votes

1 answer

597 views

SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS

asked Sep 15, 2014 at 14:59

2 votes

3 answers

758 views

Compare each day of year with DATEFIRST = 1 and DATEFIRST = 7

asked Mar 24, 2017 at 13:25

2 votes

2 answers

1k views

Possible to intercept and alter SQL Queries in the engine before it gets executed?

asked Apr 16, 2017 at 18:39

2 votes

1 answer

4k views

SQL Server Availability Group does not update DB owner automatically

asked Nov 15, 2016 at 10:10

1 vote

0 answers

2k views

"The server principal is not able to access the database under the current security context" - Availability Group

asked Feb 6, 2017 at 10:51

1 vote

1 answer

497 views

View history of preferred replica in Availability Group - when

asked Mar 7, 2017 at 11:28

1 vote

2 answers

670 views

Local SSMS connected to VPN SQL Instance - update fails when VPN disconnects

asked Mar 24, 2017 at 6:14

1 vote

1 answer

114 views

Security per database in SQL Azure Pool

asked Apr 8, 2017 at 6:39

1 vote

3 answers

4k views

Matching 3 columns in row - if one column is null then exclude it from comparison

asked Jul 4, 2014 at 7:03

1 vote

1 answer

144 views

SQL 2014 Availability group of Same DB produces different size Backup from Node A to Node B

asked Aug 17, 2016 at 7:24

1 vote

1 answer

1k views

Log Shipping - Monitor Server Down - Copying happening but not restoring on secondary

asked Apr 13, 2015 at 12:24

1 vote

2 answers

780 views

Read GPS Coordinates into LineString from Table

asked Aug 6, 2015 at 12:29

Stack Exchange Network

41 Questions

Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'

Understanding varchar(max) 8000 column and why I can store more than 8000 characters in it

SQLPackage : Import or Export SQL Azure BACPAC without users

Running Total which Resets when Customer changes (keeping existing RowNumbers)- attempt included

Everyone warns against shrinking a database, but will it work in my case? 1 GB db with tables removed now 100 MB

Operand type clash: my first User Defined Type with list of Integers, how to test via SSMS

After 5 years of working, SQL Server 2k5 Table now locking without any changes made to DB

Update row based on match to previous row

Advice on setting up a Reporting server

Why do I have to backup a transaction log twice for it to shrink?

VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping

Query has where (a = a) or (b = b) - the 2nd part causing index scan. Full example included

Can 2 tables lock each other if concurrent read/update do not affect same rows? pagelocks off

Can one assign a performance score to a stored proc to compare performance of 2 procs

Does rowlocks on index cause keylocks? : Transaction (Process ID xy) was deadlocked, example included

View all 32 possible Binary combinations for 5 digits

Inside stored procedure, set column names of returned query according to variable

Databases created with different collations - why?

SQL Server 2008 R2 - remove line below heading (which has ----,----) - dont have SSIS

Compare each day of year with DATEFIRST = 1 and DATEFIRST = 7

Possible to intercept and alter SQL Queries in the engine before it gets executed?

SQL Server Availability Group does not update DB owner automatically

"The server principal is not able to access the database under the current security context" - Availability Group

View history of preferred replica in Availability Group - when

Local SSMS connected to VPN SQL Instance - update fails when VPN disconnects

Security per database in SQL Azure Pool

Matching 3 columns in row - if one column is null then exclude it from comparison

SQL 2014 Availability group of Same DB produces different size Backup from Node A to Node B

Log Shipping - Monitor Server Down - Copying happening but not restoring on secondary

Read GPS Coordinates into LineString from Table