User MrVimes

7 votes

1 answer

6k views

Appending backups while overwriting expired sets

asked Dec 6, 2012 at 15:16

7 votes

3 answers

24k views

Storing NULL versus storing '' in a varchar column

asked Feb 17, 2017 at 14:58

4 votes

1 answer

596 views

Is it wise to drop fixed-length columns to free up space?

asked Sep 28, 2016 at 10:53

4 votes

1 answer

207 views

Reclaim space from dropped column when there isn't enough space for index rebuild

asked Nov 1, 2016 at 11:22

4 votes

1 answer

4k views

Do not have permission to use 'dbo' when creating a view

asked Oct 7, 2015 at 12:47

3 votes

1 answer

2k views

Unpivot with rows converted to columns as well as columns converted to rows

asked Dec 2, 2015 at 13:53

3 votes

4 answers

8k views

Index fragmentation increased significantly after rebuild

asked Mar 3, 2016 at 9:25

3 votes

1 answer

2k views

Impact of changing char(10) to varchar(12) on massive table

asked Jan 28, 2015 at 9:40

3 votes

2 answers

5k views

Trying to check if a string contains a number exclusively

asked Nov 2, 2018 at 13:43

2 votes

2 answers

121 views

Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?

asked May 1, 2013 at 12:58

2 votes

1 answer

87 views

Changing char(10) to char(3) grew table even after cleantable and shrinkfile

asked Nov 3, 2016 at 12:25

2 votes

3 answers

3k views

Moving data into an archive table and reducing the size of the original table

asked Feb 10, 2017 at 13:33

1 vote

1 answer

66 views

Is there a better way than this to split a string and get the first substring?

asked Feb 7, 2017 at 9:51

1 vote

3 answers

10k views

Is it possible to allow missing value inserts in mysql instead of requiring "NULL" in the query? [closed]

asked Mar 19, 2016 at 14:20

1 vote

1 answer

170 views

Run subquery once / optimize join with subquery without needing to use temporary table

asked Mar 2, 2016 at 13:22

1 vote

1 answer

4k views

Join a 'default' value only when there is no fully matching record

asked Jan 7, 2020 at 12:11

0 votes

3 answers

942 views

Mysql query that is very quick (but sometimes very slow) versus an alternative version of the same query that is consistently a bit slow

asked Mar 3, 2022 at 13:49

0 votes

0 answers

104 views

Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings

asked Jun 30, 2022 at 12:04

0 votes

1 answer

661 views

Anything but small ODBC queries failing over long distance VPN after SQL Server Swap

asked Jul 14, 2022 at 12:47

0 votes

1 answer

67 views

I created an index approx 5gb in size but the file system doesn't show any difference in free space

asked Jun 18, 2016 at 20:12

0 votes

1 answer

326 views

all rows from left table with sum of amount from right table

asked Aug 7, 2015 at 10:30

0 votes

1 answer

94 views

Second instance of query designer for a single table in SSMS (Express)?

asked May 19, 2012 at 9:25

0 votes

0 answers

363 views

Remove node from failover cluster without access to said cluster or domain

asked May 3, 2018 at 11:39

Stack Exchange Network

23 Questions

Appending backups while overwriting expired sets

Storing NULL versus storing '' in a varchar column

Is it wise to drop fixed-length columns to free up space?

Reclaim space from dropped column when there isn't enough space for index rebuild

Do not have permission to use 'dbo' when creating a view

Unpivot with rows converted to columns as well as columns converted to rows

Index fragmentation increased significantly after rebuild

Impact of changing char(10) to varchar(12) on massive table

Trying to check if a string contains a number exclusively

Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?

Changing char(10) to char(3) grew table even after cleantable and shrinkfile

Moving data into an archive table and reducing the size of the original table

Is there a better way than this to split a string and get the first substring?

Is it possible to allow missing value inserts in mysql instead of requiring "NULL" in the query? [closed]

Run subquery once / optimize join with subquery without needing to use temporary table

Join a 'default' value only when there is no fully matching record

Mysql query that is very quick (but sometimes very slow) versus an alternative version of the same query that is consistently a bit slow

Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings

Anything but small ODBC queries failing over long distance VPN after SQL Server Swap

I created an index approx 5gb in size but the file system doesn't show any difference in free space

all rows from left table with sum of amount from right table

Second instance of query designer for a single table in SSMS (Express)?

Remove node from failover cluster without access to said cluster or domain