Click here to Skip to main content
14,662,005 members
Home » Discussions » Database
   

Database

 
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 
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 
It's the recommended approach - create the connection as close as possible to where it's needed, and wrap it in a "using" block to make sure it's disposed of as soon as you're done with it.

Connection pooling will automatically keep a pool of the low-level connections alive to speed up reconnecting. So long as you're using the same connection string each time, and you dispose of the connection when you're done with it, you shouldn't have any performance issues caused by connecting to SQL.

SQL Server Connection Pooling - ADO.NET | Microsoft Docs[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

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 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan30-Jun-20 23:31
mveRichard MacCutchan30-Jun-20 23:31 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
David Mujica1-Jul-20 5:36
MemberDavid Mujica1-Jul-20 5:36 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu15-Jul-20 23:44
Memberkali siddhu15-Jul-20 23:44 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
ZurdoDev1-Jul-20 7:03
mveZurdoDev1-Jul-20 7:03 
QuestionHttp 500 error with register page Pin
and180y29-Jun-20 4:31
Memberand180y29-Jun-20 4:31 
AnswerRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:33
mveZurdoDev29-Jun-20 4:33 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 4:45
Memberand180y29-Jun-20 4:45 
GeneralRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:49
mveZurdoDev29-Jun-20 4:49 
AnswerRe: Http 500 error with register page Pin
Richard Deeming29-Jun-20 5:15
mveRichard Deeming29-Jun-20 5:15 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 5:21
Memberand180y29-Jun-20 5:21 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 7:40
Memberand180y29-Jun-20 7:40 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 9:36
mveRichard MacCutchan29-Jun-20 9:36 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 12:37
Memberand180y29-Jun-20 12:37 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 21:44
mveRichard MacCutchan29-Jun-20 21:44 

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.