2016-10-21 (first published: 2015-05-12)
2,275 reads
2016-05-25 (first published: 2014-03-06)
2,203 reads
Code For Truncating Table with foreign Key Constraints
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,605 reads
Accurate Time between Two Dates in Year, Month,Day Format
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,065 reads
Detach & Attach Procedure
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
997 reads
Find only characters or only integer from alphanumeric value
Extract only integers or characters from alphanumeric :
2014-10-07 (first published: 2014-09-05)
1,489 reads
Blogs
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
Using SQL Data Compare from the Command Line with a Project
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Forums
SQL Table Issue
Hi everyone, In below code I am creating a table and inserting some english...
Backup Log Init run again by mistake manually.
backup log to int run every hour. If a log init backup is run...
Ask SSC