User GWR

34 votes

1 answer

93k views

Decode Base64 String Natively in SQL Server

asked Nov 20, 2017 at 1:10

33 votes

3 answers

79k views

Efficient INSERT INTO a Table With Clustered Index

asked Oct 28, 2011 at 13:05

21 votes

3 answers

151k views

SQL Server Restore a SINGLE table from a backup [duplicate]

asked Feb 8, 2013 at 1:07

20 votes

3 answers

14k views

Comparing Columns that can contain NULLS - is there a more elegant way?

asked Mar 16, 2012 at 20:12

9 votes

1 answer

21k views

Best Data Type to Store Result of HASHBYTES('MD5', ...)

asked Nov 29, 2017 at 12:32

6 votes

1 answer

2k views

Best Way to Index an INT Column Used for BitWise Queries

asked Dec 8, 2016 at 11:59

6 votes

4 answers

11k views

SQL Server Debugger Permissions without Granting sysadmin to Devs

asked Oct 12, 2017 at 18:50

5 votes

0 answers

87 views

Why Does the SQL Server Debugger Require Sysadmin Privileges [duplicate]

asked Oct 16, 2017 at 19:31

5 votes

2 answers

8k views

Standard Meaning of "Bounce the Database" [closed]

asked Jan 10, 2018 at 15:14

5 votes

2 answers

77k views

Exporting 30 million rows to CSV

asked May 3, 2013 at 18:30

5 votes

4 answers

13k views

Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc

asked May 2, 2016 at 12:12

5 votes

1 answer

1k views

Concatenation, with separators, where any combo of input fields might be null

asked May 4, 2016 at 18:29

5 votes

4 answers

359 views

Weird WHERE Clause Behavior. Why does this return a row?

asked May 17, 2016 at 20:42

4 votes

3 answers

4k views

SQLCMD Exporting 16.5 Million Rows

asked Jul 11, 2013 at 13:25

4 votes

2 answers

8k views

WHERE Clause with pattern matching to find rows with any characters NOT in a list

asked Nov 28, 2016 at 14:13

4 votes

1 answer

5k views

Getting the Date of Some Day of Last Week

asked Jun 7, 2017 at 12:39

4 votes

2 answers

395 views

Optimizing Negative Comparison in SQL

asked Jul 20, 2017 at 14:23

3 votes

2 answers

397 views

Grouping Subsets of Rows with Null Values within an Ordered Set

asked Nov 15, 2017 at 17:39

3 votes

3 answers

4k views

Only return recordset(s) from Stored Procedure if it has rows

asked Nov 22, 2019 at 13:22

3 votes

3 answers

12k views

SQL Error [1292] "Truncated incorrect INTEGER value" - with Varchar columns and CASE. Why?

asked Jan 26, 2021 at 20:09

3 votes

0 answers

1k views

Determine Which Parameters Passed Into Stored Procedure [duplicate]

asked Nov 17, 2015 at 10:59

3 votes

0 answers

2k views

Logic to convert a UTC date-time to a specific time zone

asked May 14, 2012 at 12:59

3 votes

1 answer

1k views

Convert SQL Server UPDATE Statement for Use in Oracle

asked Apr 4, 2013 at 18:06

2 votes

1 answer

287 views

Search for X at the beginning of a line within a multi-line string

asked Apr 28, 2016 at 20:25

2 votes

1 answer

2k views

MySQL Case Sensitive Join on Varchar

asked May 31, 2019 at 10:11

2 votes

1 answer

177 views

Grouping Sessions using a DATETIME stamp which can Span across a DAY

asked Dec 17, 2017 at 16:37

1 vote

1 answer

567 views

Table Valued UDF vs Stored Proc for passing values to a SELECT statement

asked Apr 10, 2018 at 16:04

1 vote

0 answers

4k views

Why Turning ANSI_WARNINGS Off Causes Error Updating Col Used as a Source of a Computed Col?

asked Dec 8, 2017 at 14:58

1 vote

2 answers

6k views

Convert a DATETIME value using string Timezone Info?

asked Nov 26, 2017 at 2:35

1 vote

2 answers

135 views

Optimizing UDF - Is Using DUAL Expensive

asked Sep 26, 2013 at 12:27

Stack Exchange Network

38 Questions

Decode Base64 String Natively in SQL Server

Efficient INSERT INTO a Table With Clustered Index

SQL Server Restore a SINGLE table from a backup [duplicate]

Comparing Columns that can contain NULLS - is there a more elegant way?

Best Data Type to Store Result of HASHBYTES('MD5', ...)

Best Way to Index an INT Column Used for BitWise Queries

SQL Server Debugger Permissions without Granting sysadmin to Devs

Why Does the SQL Server Debugger Require Sysadmin Privileges [duplicate]

Standard Meaning of "Bounce the Database" [closed]

Exporting 30 million rows to CSV

Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc

Concatenation, with separators, where any combo of input fields might be null

Weird WHERE Clause Behavior. Why does this return a row?

SQLCMD Exporting 16.5 Million Rows

WHERE Clause with pattern matching to find rows with any characters NOT in a list

Getting the Date of Some Day of Last Week

Optimizing Negative Comparison in SQL

Grouping Subsets of Rows with Null Values within an Ordered Set

Only return recordset(s) from Stored Procedure if it has rows

SQL Error [1292] "Truncated incorrect INTEGER value" - with Varchar columns and CASE. Why?

Determine Which Parameters Passed Into Stored Procedure [duplicate]

Logic to convert a UTC date-time to a specific time zone

Convert SQL Server UPDATE Statement for Use in Oracle

Search for X at the beginning of a line within a multi-line string

MySQL Case Sensitive Join on Varchar

Grouping Sessions using a DATETIME stamp which can Span across a DAY

Table Valued UDF vs Stored Proc for passing values to a SELECT statement

Why Turning ANSI_WARNINGS Off Causes Error Updating Col Used as a Source of a Computed Col?

Convert a DATETIME value using string Timezone Info?

Optimizing UDF - Is Using DUAL Expensive