user avatar
user avatar
user avatar
Ollie
  • Member for 4 years, 11 months
  • Last seen this week
  • England, United Kingdom
6 votes
Accepted

Partition Switch - What is the benefit if staging has to be same as destination table

4 votes

SQL Server LaunchPad "The service did not respond in a timely fashion" + No Log in ExtensibilityLog

4 votes
Accepted

How to determine which tables use a sequence in SQL Server

3 votes

Using IS NULL in CASE Expression in WHERE Clause

2 votes
Accepted

Is there a server option which limits the amount of rows returned by a remote query?

2 votes

How to write sql statement for following scenario?

2 votes
Accepted

temp tables in tempdb are not cleaned up by the system

1 vote

Does SQL Server 2016 still contain sqlmaint.exe?

1 vote

Audit user activity in SQL Server

1 vote

Why is mixing column collations in a single database considered bad?

1 vote
Accepted

Get top SQL Queries that aren't stored procs/functions/triggers

1 vote

SQL Server Join not returning records

1 vote

Retrieve the triggering SQL statement as is

1 vote

SQL job using SSIS package takes a long time to run especially in the evenings

0 votes

SQL Server query with date range in WHERE - execution plan uses clustered PK instance not date column index

0 votes
Accepted

why is the Log File is 5 times the database overnight when deleting?

0 votes
Accepted

Subscription Initialization throws Error "The option "INLINE=ON" is not valid for this function" which is incorrect

0 votes

SQL Server query takes too long to execute. What could the problem be?