Click here to Skip to main content
15,115,261 members
Home / Discussions / Database
   

Database

 
AnswerRe: Aws lamda Pin
CHill604-Aug-20 4:02
mveCHill604-Aug-20 4:02 
AnswerRe: Aws lamda Pin
MichaelFern15-Sep-20 3:19
MemberMichaelFern15-Sep-20 3: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 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 
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 
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 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 

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.