2023-02-03 (first published: 2023-02-02)
8 reads
Age
Performing a Right and Comprehensive Age Calculation Part 2
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
2017-03-30
1,409 reads
Function to calculate and return age in text to closest minute between
Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes
2016-08-12 (first published: 2012-05-17)
1,726 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
RE: Best Practices for Database Design
I, for one don't care what the iso standard says, they are wrong. A table does not represent a set of entities. Tables represent a single predicate function. So the Employee table with the following attributes:EmpNo, FirstName, LastName, DeptNo, Address,...MEANS literally "Employee (EmpNo) has a first name of (FirstName), a last name of (LastName), works […]
2005-04-06
RE: Applying Password to SA Account
Brian,Don't forget to turn on your pager after that.People who install SQL server with a blank password tend to use it in the applications for connection strings. Those applications will not be able to connect to the database after you change the password. Be prepared to explain things to them.Another thing: Some (me included) have their Enterprise […]
2005-01-05
RE: 20 % records
Ah! Thought so when I looked at the code as it did not look like traditional sql server. Unfortunately I have not used Oracle and cannot help you, maybe someone else on the forum can. Sorry I cannot be of more help
2003-12-19
RE: What is starting this backup
Got to some job that is running it. Could be a job running from somenoe's desk as well (scheduled tasks). Run a trace (profile ) for that time and see what you get. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-10
RE: Finding & removing a space from a string
Now why did the multiple spaces get removed? 'Have___a__Nice_day!' to 'Have_a_nice_day!' When I wrote this originally I was scrubbing some data that had a ton of problems like this. It had been converted by several someone elses before me and they had concatinated a bunch of fields with little to no regard for spacing.
2003-08-21
RE: Finding & removing a space from a string
That's to complicated. This works beautifuly. declare @String varchar(255) set @String = 'Have a nice day' While 1 = 1 begin set @String = replace(@String, ' ', '') IF charindex(' ', @String) = 0 Break end select @String
2003-08-21
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers