Viewing 15 posts - 841 through 855 (of 6,678 total)
What event are you capturing in your profiler trace?
July 29, 2021 at 4:28 pm
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...
July 29, 2021 at 3:58 pm
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...
July 29, 2021 at 3:49 pm
Thanks Jeffrey, I've corrected my sample code.
BTW - I like this solution and think it works much better than a traditional UPSERT. I need to *remember* that we can...
July 29, 2021 at 3:42 pm
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...
July 29, 2021 at 3:31 pm
Multiple outer joins:
Select s1.PK
, Col1 = coalesce(c1.[Value], s1.Col1)
, Col2 = coalesce(c2.[Value], s1.Col2)
...
July 28, 2021 at 6:56 pm
The pattern we use for a similar process is this.
MERGE INTO final_table
USING (SELECT key_column_1
,...
July 28, 2021 at 4:04 pm
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
July 27, 2021 at 8:17 pm
@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...
July 27, 2021 at 7:41 pm
You don't need to use the fnTally function - it can be done inline.
Declare @startDate date = '2015-04-15'
, @endDate date =...
July 27, 2021 at 7:24 pm
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...
July 26, 2021 at 5:49 pm
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...
July 26, 2021 at 5:42 pm
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...
July 26, 2021 at 5:39 pm
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...
July 26, 2021 at 4:04 pm
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...
July 26, 2021 at 3:53 pm
Viewing 15 posts - 841 through 855 (of 6,678 total)