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
Date Difference
RE: Merge Replication Again
My experience in the past with the remote login is that you need to setup that user distributor_Admin on the server. I'm kind of new at this, so I am not sure which server to tell you. I just set it up on one and then other until it works.
2004-05-07
RE: Optimal Pivot Query
Hi Peter,Can you explain "With CUBE" clause?I don't have any idea about it...Plz bear with my ignorance...Thanks,Rockey
2004-05-06
RE: How to Compute Actual Space Used In Datafiles
This isn't really pretty - and I had to carve it out of a cursor that I use as part of my nightly processing - but it seems to be pretty accurate for calculating db space. Also, I can't claim to have come up with this. My inspiration came from a few MS-supplied stored procedures. I […]
2004-05-06
RE: serious problem
i dont think it will work, still i will try becoz for experimental purpose i tried dividing it directly by integer 1/2 like this. and it was throwing error
2004-04-27
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
Backup Log Init run again by mistake manually.
backup log to int run every hour. If a log init backup is run...
Speakers Are Normal People
Comments posted to this topic are about the item Speakers Are Normal People
Ask SSC