@sizal0234 - It is also important how you read the execution plan. Usually, you read a graphical execution plan from right to left and top to bottom.

Read the...

Solution for Stored Procedures/View/Trigger/Function :

You can leverage the Synonyms. Instead of hard-coding the database name you can create the synonyms in each database and refer the synonyms instead of referring...

I tried similar thing with simple POC. Refer the attached screenshot with both "Sub Total" and "Grand Total"

You can refer the below URL for the steps to be followed  :

@ sqlenthu 89358 - Solution suggested by @sumathi shall work. You can use it along with CTE and Ranking function to accomplish your desired goal.

SET XACT_ABORT ON; will always help but It is advisable to have Rollback with specific Transaction name in respective Catch block.

Try below tips and see if it works ?

Check once if in Production DB (Old Server) there exists Partition on the tables you are using in your query and similar...

True

Primary Key can have Clustered Index or Non Clustered Index.

If you just wanted to have Primary Key with Non Clustered Index then it hardly matters whether you choose Surrogate Key...

You can create your own road-map. However, I propose following considering your past experience :

1. Tabular Model, C# (This will also help you in SSIS Script Task), Azure,
2. Power BI,...

Please also share the screenshot of the Task Manager processes (Sort by CPU usage Descending).

That's indeed a different perspective to solve the same problem. Much appreciated !

• This reply was modified 4 years, 11 months ago by  Brahmanand Shukla.

Here you go. Mark it as answer if it serves your purpose.

First of all create the below user defined scalar function

CREATE FUNCTION [ufn_SPLIT_STRING_BY_DELIMITER](@String nvarchar(4000), @Delimiter char(1))
RETURNS @Results...

All the version are best and ever evolving with new releases 🙂 Even SQL 2000 is used by many organizations but why to use almost 20 year old SQL 2000...

 /*
EXEC #usp_Get_City
@No_Of_Rows_To_Group = 1

EXEC #usp_Get_City
@No_Of_Rows_To_Group = 2

EXEC #usp_Get_City
@No_Of_Rows_To_Group = 3

EXEC #usp_Get_City
@No_Of_Rows_To_Group = 4

EXEC #usp_Get_City
@No_Of_Rows_To_Group = 5

EXEC #usp_Get_City
@No_Of_Rows_To_Group = 6
*/
CREATE PROCEDURE #usp_Get_City
(
@No_Of_Rows_To_Group TINYINT
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @Partition TINYINT

DECLARE...

Replication task and Integration Services package job step logging is handled by their respective subsystem. You cannot use SQL Server Agent to configure jog step logging for these types of...