• Sergiy wrote:

  The important points are these:

  • DISTINCT is pretty nasty beast. There is no excuse for lazy programming using it, even if "everyone does it".

I don't see...

• Sergiy wrote:

  The important points are these:

  • DISTINCT is pretty nasty beast. There is no excuse for lazy programming using it, even if "everyone does it".

I don't see why/how GROUP...

I would attempt to speed the query up with the use of temporary tables, try this for starters:

IF OBJECT_ID('tempdb..#BCMasterydaily', 'U') IS NOT NULL 
   ...

You will get better performance if you write 2 statements, an update followed by an insert (where not exists)

Performance Tip: The conditional behavior described for the MERGE statement works best when...

If you look at the message on the INSERT it says:

"The query had to wait 1164 seconds for MemoryGrant during execution"

That's nearly 20 minutes.

https://techcommunity.microsoft.com/t5/sql-server/understanding-sql-server-memory-grant/ba-p/383595

Try adding this to the end...

The most obvious thing you can do is to add the missing indexes to see what difference they make.

I can't see why doing a SELECT * FROM dbo.MyMultilinedTableValuedFunction(@Parm) could be much...

Try this.

1. In VS create a new SSIS project/solution.
2. Add the existing .dtsx to the new solution
3. Then try opening the package by double clicking it in Solution Explorer.

You also...

250 is a lot for a fact table. I had a dimension table that had 573 columns. The problems encountered were during updates due to page splits. So much of...

Error 50000 is a user-defined error. You need to provide the code from your stored procedure [I3_CMS].[dbo].[spPackageHistory_Tblu].

Also, you should just have a THROW in the catch instead of setting those...

Hello trying to find unique values on the following table

First temporary table  query (Master Data)

insert into #tempCOO select sk.CountryOfOrigin,im.partnumber,sk.Quantity,sol.id,lp.id,lpl.id,so.id,p.SerialNumber FROM  sk join  lpl on sk.LoadPlanLineId = lpl.id join ...

I would create a job that runs every 5 minutes with code in it something like this:

DECLARE @CurrentDateTime as datetime = GETDATE()
IF NOT EXISTS(SELECT * 
 ...

How long does

SELECT DATALENGTH(varbinmax_col1)
FROM dbo.base_table

take to run?

IF OBJECT_ID('tempdb..#lab') IS NOT NULL DROP TABLE #lab
SELECT * INTO #lab FROM (VALUES 
( '07/09/2018','Dave', 'Jones', '07/09/2018 09:56',  2301 ),
( '08/09/2018','Jim', 'Jones', '08/09/2018 09:56',  23561...

I for the index that's used in the seek ([IX_game_box...] full name unknown) you need to INCLUDE all the columns from table [game_boxscore_players] that are in the query.

It then won't...

The execution plans are identical. For some reason SQL Server hasn't identified the missing index in the second query.

Have you tried creating the index to check that both queries will use...