for huge data insertion and deletion by avoiding locking you can use partition tables.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-10-28

788 reads

How to get list of Stored Procedure

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2008-08-11

1,073 reads

Blogs

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

I had an idea for an animated view of a sales tool, and started...

Comments posted to this topic are about the item Optimism Without Illusion or Why...

Hi all, I'm trying to do classic scenario for loading multiple Excel files into...

Hi So the case statement is slowing this down - but for the life...

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.