Click here to Skip to main content
14,971,029 members
Home / Discussions / Database
   

Database

 
GeneralRe: MS SQL Database Bridge Pin
Richard Deeming14-Aug-20 5:38
mveRichard Deeming14-Aug-20 5:38 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:56
MemberOtekpo Emmanuel14-Aug-20 5:56 
QuestionAws lamda Pin
Member 1490095628-Jul-20 2:16
MemberMember 1490095628-Jul-20 2:16 
AnswerRe: Aws lamda Pin
CHill604-Aug-20 3:02
mveCHill604-Aug-20 3:02 
AnswerRe: Aws lamda Pin
MichaelFern15-Sep-20 2:19
MemberMichaelFern15-Sep-20 2:19 
QuestionNeed a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 9:45
Membersimpledeveloper21-Jul-20 9:45 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 10:28
mveRichard MacCutchan21-Jul-20 10:28 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 11:57
Membersimpledeveloper21-Jul-20 11:57 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 21:30
mveRichard MacCutchan21-Jul-20 21:30 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Eddy Vluggen21-Jul-20 10:35
professionalEddy Vluggen21-Jul-20 10:35 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
W Balboos, GHB21-Jul-20 11:01
mveW Balboos, GHB21-Jul-20 11:01 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard Deeming21-Jul-20 23:25
mveRichard Deeming21-Jul-20 23:25 
QuestionHow to optimize Hash Match aggregation in SQL Server execution plan Pin
kali siddhu17-Jul-20 0:38
Memberkali siddhu17-Jul-20 0:38 
AnswerRe: How to optimize Hash Match aggregation in SQL Server execution plan Pin
Eddy Vluggen21-Jul-20 10:44
professionalEddy Vluggen21-Jul-20 10:44 
QuestionDead lock issue with Update and delete statement on the same table Pin
kali siddhu14-Jul-20 23:37
Memberkali siddhu14-Jul-20 23:37 
AnswerRe: Dead lock issue with Update and delete statement on the same table Pin
David Mujica15-Jul-20 10:57
MemberDavid Mujica15-Jul-20 10:57 
GeneralRe: Dead lock issue with Update and delete statement on the same table Pin
kali siddhu15-Jul-20 23:33
Memberkali siddhu15-Jul-20 23:33 
QuestionIs there any alternative for Trigger After Insert Pin
simpledeveloper13-Jul-20 17:56
Membersimpledeveloper13-Jul-20 17:56 
Hi, I have two columns in a table, one is Auto Identity set, and other one should be created as a string value with Id as Pad right, I have created a trigger but my lead is saying Triggers impact the performance, and to not create, is there any alternate for Triggers that would not effect Database performance at the same time do what I am expecting it to be done.
My trigger is as follows:
CREATE TRIGGER AfterInsert
   ON  InspectionItems
   AFTER INSERT
AS 
BEGIN
	declare @InspectionItemNumber nvarchar(20), @InspectionItemId int

	select @InspectionItemId = ins.InspectionItemId FROM INSERTED ins;

	update InspectionItems set InspectionItemNumber = 'T' + RIGHT('00000'+CAST(InspectionItemId AS VARCHAR(5)),6)
	where InspectionItemId = @InspectionItemId
END
GO

Is there any alternate for trigger and doing the same and preserve the performance - thanks in advance.
AnswerRe: Is there any alternative for Trigger After Insert Pin
Richard Deeming13-Jul-20 22:35
mveRichard Deeming13-Jul-20 22:35 
GeneralRe: Is there any alternative for Trigger After Insert Pin
simpledeveloper14-Jul-20 10:41
Membersimpledeveloper14-Jul-20 10:41 
QuestionConnection Resources Pin
Richard Andrew x6411-Jul-20 13:50
professionalRichard Andrew x6411-Jul-20 13:50 
AnswerRe: Connection Resources Pin
Richard Deeming13-Jul-20 0:04
mveRichard Deeming13-Jul-20 0:04 
QuestionSql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu29-Jun-20 21:18
Memberkali siddhu29-Jun-20 21:18 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan29-Jun-20 21:54
mveRichard MacCutchan29-Jun-20 21:54 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu30-Jun-20 23:29
Memberkali siddhu30-Jun-20 23:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.