Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,695 reads
DateDiff
2016-12-22
1,528 reads
Cursor-Killing: Accessing Data in the Next Row
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.
2015-12-18 (first published: 2014-05-27)
22,536 reads
Work around for calculating age using the SQL Server DateDiff function
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
2012-05-23
4,752 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
2011-10-03 (first published: 2011-08-30)
1,010 reads
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
31,530 reads
How long has passed since SQL Server service started?
Days, hours and minutes since SQL Server service was started
2010-11-05 (first published: 2010-01-15)
2,477 reads
RE: trace
Okay. Just went through this several weeks ago. This ended up being my solution. Because of the amount of events that I'm tracking I had to create a stored procedure because the set events went beyond the length of the Jobs window. Here is the header for the stored procedure. First step is to output […]
2005-03-30
RE: Using DTS to FTP data to mainframe
"As per my experience, uploading file by natual DTS is so flexible. For example, the file name is not allowed to changed. "The name of the file can be changed by using the Visual Basic Active X Script functionality within DTS. Just send the output of the text file destination icon to the active x icon and […]
2005-03-30
RE: Assigning a select to 1 view to a user make him see all my objects?!!
HelloSQL Authentication, its normal user not belong to any group its a son of SQL server only I've just create it in Logins in EM and assigened it to 1 view only, Acctually he can read the data from that view, but also he can browse the whole other views design, even all DTS logic […]
2005-03-25
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