Skip to main content
pacreely's user avatar
pacreely's user avatar
pacreely's user avatar
pacreely
  • Member for 7 years, 7 months
  • Last seen this week
  • Manchester, United Kingdom
10 votes
Accepted

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

9 votes

Why is my query suddenly slower than it was yesterday?

5 votes

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

4 votes
Accepted

Alter Index within a Script

3 votes
Accepted

How could i search between two string type date

3 votes
Accepted

Unpivot columns based on select

3 votes

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

3 votes

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

2 votes
Accepted

Is it a parameter sniffing problem?

2 votes

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

1 vote
Accepted

Query over text column takes ages to run

1 vote

How would you make this function work on any table?

1 vote

How to improve query performance?

1 vote

1000's of SQL Update Statements taking forever to complete

1 vote

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

1 vote

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

1 vote

Constant Scan applying

1 vote

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

1 vote

Transactional Replication hangs when huge transactions flow

1 vote
Accepted

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

1 vote
Accepted

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

1 vote

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

1 vote

Retrieving data from stored procedure's cursor

1 vote

How often to update SQL Server?

1 vote

Get count from SQL Server

0 votes

Best Way to Reduce the Size of 8 TB DB?

0 votes

Index solution for dynamic query

0 votes

Using column store indexes on table

0 votes
Accepted

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

0 votes

Transaction log is full changing column type in a large table