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
96 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,444 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
250 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
87 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,321 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
422 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
145 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,264 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
224 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
116 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Managing unused indexes
While doing some housekeeping activity on several old but large production databases, I come...
Cloud Performance Considerations
How important to SQL Server is the speed of the SSD and network latency?...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers