SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
76 reads
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
76 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
1,434 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
238 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
78 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
4,310 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
402 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
132 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
1,249 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
217 reads
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
103 reads
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Comments posted to this topic are about the item The World of Data Science
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...