Click here to Skip to main content
14,694,110 members
Home » Discussions » Database
   

Database

 
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 10:45
Membersimpledeveloper21-Jul-20 10: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 11:28
mveRichard MacCutchan21-Jul-20 11: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 12:57
Membersimpledeveloper21-Jul-20 12: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 22:30
mveRichard MacCutchan21-Jul-20 22: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 11:35
professionalEddy Vluggen21-Jul-20 11: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 12:01
mveW Balboos, GHB21-Jul-20 12: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 Deeming22-Jul-20 0:25
mveRichard Deeming22-Jul-20 0:25 
QuestionHow to optimize Hash Match aggregation in SQL Server execution plan Pin
kali siddhu17-Jul-20 1:38
Memberkali siddhu17-Jul-20 1:38 
How to optimize Hash Match aggregation in SQL Server execution plan for the below


SELECT ServicePointID, MAX(SP1.StartDayID) as StartDayID
FROM SP sp1
JOIN Transfr tr1 ON sp1.TransformerID = tr1.TransformerID --Hash Match
JOIN SP_Met spm1 ON spm1.ServicePointKey = sp1.ServicePointKey
JOIN Met dm1 ON dm1.MeterKey = spm1.MeterKey
WHERE sp1.StartDayID <= 20200715 AND sp1.EndDayID >= 20200616 AND sp1.CommodityType ='Electric'AND (tr1.Division = null OR NULL is null )
AND (tr1.Region = null OR NULL is null )AND MeterID IS NOT NULL
GROUP BY ServicePointID

Hash Match Aggregation 34%
AnswerRe: How to optimize Hash Match aggregation in SQL Server execution plan Pin
Eddy Vluggen21-Jul-20 11:44
professionalEddy Vluggen21-Jul-20 11:44 
QuestionDead lock issue with Update and delete statement on the same table Pin
kali siddhu15-Jul-20 0:37
Memberkali siddhu15-Jul-20 0:37 
AnswerRe: Dead lock issue with Update and delete statement on the same table Pin
David Mujica15-Jul-20 11:57
MemberDavid Mujica15-Jul-20 11:57 
GeneralRe: Dead lock issue with Update and delete statement on the same table Pin
kali siddhu16-Jul-20 0:33
Memberkali siddhu16-Jul-20 0:33 
QuestionIs there any alternative for Trigger After Insert Pin
simpledeveloper13-Jul-20 18:56
Membersimpledeveloper13-Jul-20 18:56 
AnswerRe: Is there any alternative for Trigger After Insert Pin
Richard Deeming13-Jul-20 23:35
mveRichard Deeming13-Jul-20 23:35 
GeneralRe: Is there any alternative for Trigger After Insert Pin
simpledeveloper14-Jul-20 11:41
Membersimpledeveloper14-Jul-20 11:41 
QuestionConnection Resources Pin
Richard Andrew x6411-Jul-20 14:50
professionalRichard Andrew x6411-Jul-20 14:50 
AnswerRe: Connection Resources Pin
Richard Deeming13-Jul-20 1:04
mveRichard Deeming13-Jul-20 1:04 
QuestionSql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu29-Jun-20 22:18
Memberkali siddhu29-Jun-20 22:18 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan29-Jun-20 22:54
mveRichard MacCutchan29-Jun-20 22:54 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu1-Jul-20 0:29
Memberkali siddhu1-Jul-20 0:29 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan1-Jul-20 0:31
mveRichard MacCutchan1-Jul-20 0:31 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
David Mujica1-Jul-20 6:36
MemberDavid Mujica1-Jul-20 6:36 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu16-Jul-20 0:44
Memberkali siddhu16-Jul-20 0:44 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
ZurdoDev1-Jul-20 8:03
mveZurdoDev1-Jul-20 8:03 
QuestionHttp 500 error with register page Pin
and180y29-Jun-20 5:31
Memberand180y29-Jun-20 5:31 

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.