Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
666 reads
2008-09-17
3,091 reads
2008-08-29
4,436 reads
2008-08-28
3,851 reads
2008-08-26
4,200 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.
2008-08-11
887 reads
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
Pintable into cache
Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Ask SSC