What event are you capturing in your profiler trace?

But, if you can't filter the query in any way, yeah, it's going to use a ton of memory and that will absolutely affect the plans in cache. No...

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its logical...

BTW - I like this solution and think it works much better than a traditional UPSERT.  I need to *remember* that we can...

Using SHRINKDATABASE attempts to shrink all of the files associated with the database - to their initial size.  This is very important to consider for transaction log files.  If the...

Multiple outer joins:

 Select s1.PK
      , Col1 = coalesce(c1.[Value], s1.Col1)
      , Col2 = coalesce(c2.[Value], s1.Col2)
  ...

The pattern we use for a similar process is this.

MERGE INTO final_table
USING (SELECT key_column_1
            ,...

• This reply was modified 4 years, 3 months ago by Jeffrey Williams. Reason: Added FROM clause to be consistent with Chris's post

Are you looking for:

 Select datediff(minute, '2021-07-01 01:15:00', '2021-07-01 01:30:00') / 60.0
 Select datediff(second, '2021-07-01 01:15:00', '2021-07-01 01:30:00') / 60.0 / 60.0

@andrea - your issues were not actually related to importing CSV files into SQL Server.  This all goes back to the sender and how the files are generated.  If the...

You don't need to use the fnTally function - it can be done inline.

Declare @startDate date = '2015-04-15'
      , @endDate date =...

Ola's stuff works on the 5/30 methodology for index maintenance.  The maintenance plan rebuild task uses the 5/30 methodology - the code the article links to (Adaptive...

Too bad you couldn't get a bit further south to Texas - which has no state income tax 🙂

The real question you need to answer is, are...

Ah, I should have been clearer. It is dropped and re-created monthly, populated with 1.8m rows, and then create the index. Within 2 days, the dm tables are showing...

When I have had these types of issues in the past - I broke the files out by a date.  If you have any data available in that table that...

Thanks for the support on the move. A couple of notes. First, I'm not changing jobs. I love Redgate and you'll have to pry this job from my dead...