User pacreely

10 votes

Accepted

Does restoring a full backup bring it to the backup START time or the backup FINISH time?

answered Jun 1, 2018 at 15:20

9 votes

Why is my query suddenly slower than it was yesterday?

answered Jun 5, 2018 at 11:11

5 votes

How is IF NOT EXISTS SELECT THEN INSERT faster than UNIQUE index?

answered Jun 1, 2018 at 9:37

4 votes

Accepted

Alter Index within a Script

answered Dec 29, 2016 at 18:50

3 votes

Accepted

How could i search between two string type date

answered Nov 29, 2016 at 8:48

3 votes

Accepted

Unpivot columns based on select

answered Dec 18, 2016 at 21:24

3 votes

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

answered Apr 11, 2022 at 14:17

3 votes

Why am I not getting minimal logging when inserting to indexed tables

answered May 25, 2018 at 10:32

2 votes

Accepted

Is it a parameter sniffing problem?

answered Jun 27, 2018 at 9:15

2 votes

Can @parameter IS NULL slow down the execution of query?

answered Jun 6, 2018 at 15:19

1 vote

Accepted

Query over text column takes ages to run

answered Jun 6, 2018 at 15:42

1 vote

How would you make this function work on any table?

answered Jun 1, 2018 at 16:02

1 vote

How to improve query performance?

answered Jun 8, 2018 at 9:00

1 vote

1000's of SQL Update Statements taking forever to complete

answered Aug 3, 2018 at 13:49

1 vote

UPDATE with JOIN: Incorrect syntax near the keyword 'RIGHT'

answered Sep 21, 2018 at 14:45

1 vote

Why don't I get Index Seek for my non-clustered index

answered Mar 22, 2023 at 9:50

1 vote

Constant Scan applying

answered Apr 12, 2022 at 12:11

1 vote

SQL Server: Cannot resolve collation conflict between "Latin1_General_CI_AS" and "[garbage]"

answered Jan 13, 2017 at 12:57

1 vote

Transactional Replication hangs when huge transactions flow

answered Jun 1, 2018 at 10:08

1 vote

Accepted

what does it mean if the last execution time of a stored procedure is empty

answered Sep 1, 2017 at 16:13

1 vote

Accepted

what columns to include in the index to improve the performance of the following update?

answered May 21, 2018 at 11:24

1 vote

How do you concatenate an entire column with a group by?

answered May 23, 2018 at 20:05

1 vote

Retrieving data from stored procedure's cursor

answered Nov 29, 2016 at 13:13

1 vote

How often to update SQL Server?

answered Jan 3, 2017 at 16:57

1 vote

Get count from SQL Server

answered Jan 5, 2017 at 12:56

0 votes

Best Way to Reduce the Size of 8 TB DB?

answered Jan 7, 2017 at 9:30

0 votes

Index solution for dynamic query

answered Jan 10, 2017 at 17:46

0 votes

Using column store indexes on table

answered Dec 12, 2016 at 8:44

0 votes

Accepted

DateTime Conversion works for string value but for calculated value throws "out-of-range" error

answered Dec 13, 2016 at 8:32

0 votes

Transaction log is full changing column type in a large table

answered Feb 6, 2017 at 23:18

Stack Exchange Network

37 Answers

Does restoring a full backup bring it to the backup START time or the backup FINISH time?

Why is my query suddenly slower than it was yesterday?

How is IF NOT EXISTS SELECT THEN INSERT faster than UNIQUE index?

Alter Index within a Script

How could i search between two string type date

Unpivot columns based on select

Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?

Why am I not getting minimal logging when inserting to indexed tables

Is it a parameter sniffing problem?

Can @parameter IS NULL slow down the execution of query?

Query over text column takes ages to run

How would you make this function work on any table?

How to improve query performance?

1000's of SQL Update Statements taking forever to complete

UPDATE with JOIN: Incorrect syntax near the keyword 'RIGHT'

Why don't I get Index Seek for my non-clustered index

Constant Scan applying

SQL Server: Cannot resolve collation conflict between "Latin1_General_CI_AS" and "[garbage]"

Transactional Replication hangs when huge transactions flow

what does it mean if the last execution time of a stored procedure is empty

what columns to include in the index to improve the performance of the following update?

How do you concatenate an entire column with a group by?

Retrieving data from stored procedure's cursor

How often to update SQL Server?

Get count from SQL Server

Best Way to Reduce the Size of 8 TB DB?

Index solution for dynamic query

Using column store indexes on table

DateTime Conversion works for string value but for calculated value throws "out-of-range" error

Transaction log is full changing column type in a large table