Deleting Rows from jExcel and Synchronizing with SQL Server
if (confirm("Are you sure you want to delete this record?")) {
$.ajax({
url: "DataHandler.ashx",
type: "POST",
data: {
action: "removeRecord",
id: recordId
},
dataType: "json",
success: function(response) {
/ ...
Posted on Fri, 14 Aug 2026 16:19:48 +0000 by nariman
Deadlock in High-Concurrency Scenario: Missing Index on Lookup Column
A stored procedure designed to generate sequential identifiers encountered deadlocks under concurrent load.
CREATE PROCEDURE [dbo].[GetNextSequence]
@sequenceKey varchar(50),
@result int OUTPUT
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION
SELECT @result = CurrentVal
FROM sequence_table WITH (XLOCK, ROWLOCK) ...
Posted on Thu, 06 Aug 2026 16:29:09 +0000 by Kyrst
Managing SQL Server Databases and Tables
Data Types
Various data types serve specific purposes within SQL Server. Each type has defined ranges and applications for optimal use.
Server Configuration
Server Properties via SERVERPROPERTY
Retrieve server information using the SERVERPROPERTY function:
SELECT CONVERT(sysname, SERVERPROPERTY('servername'));
System Views for Server Details
Q ...
Posted on Mon, 18 May 2026 11:42:14 +0000 by ManicMax