Insertion and Deletion by using Partition
for huge data insertion and deletion by avoiding locking you can use partition tables.
2008-10-28
661 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
880 reads
Blogs
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
Forums
Common schema in different Databases
Hi, I need to include a very simple schema in all of my database...
Permissions to Run CLR Assembly
This is my first time dealing with CLR assemblies and we have setup some...
Convert date value
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC