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
100 reads
- Interests: SQL Server!
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
1,453 reads
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
255 reads
SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
94 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
4,345 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
428 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
157 reads
SQL Server – Script to get Service Account for all local instances
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,270 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
229 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
122 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers