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...

Make sure all the columns on Object8 that your query references are either in the index key or the included columns, this will stop it doing a key lookup for...

Hi Scott.... revisiting your code above.... I'm getting a "Msg 8120, Level 16, State 1, Line 24 Column 'alias1.CALL_TIME_SECS' is invalid in the select list because it is not...

 FROM a2wh.dbo.CallLogCommon com with (NOLOCK)
 JOIN a2wh.dbo.Campaigns ud with (NOLOCK)
   ON com.[campaign] = ud.[campaign]
CROSS APPLY dbo.itvfGetSeconds(Call_Time) ctsec
CROSS APPLY dbo.itvfGetSeconds(Talk_Time) ttsec

Same as Scott's but can use BETWEEN instead of two ANDs and can perform the subtraction in another CROSS APPLY.

Also, it is good practice to always have an ELSE in...

although going through the route of linked server best practices would mean that the linked server would not be named as the server name but rather as a logical...

Linked servers will be the easiest way. Then you just add the server name as a prefix:

SELECT *
  FROM [ServerName].[DatabaseName].[SchemaName].[TableName]

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver15

These are your subqueries

           ,(SELECT RS.LIB_SERVICE 
          ...