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
77 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
77 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,436 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
239 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
80 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,311 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
403 reads
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
133 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,251 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
219 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
106 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello all, I would like to create an INSERT statement and use a UDF...
Comments posted to this topic are about the item Initial Config of tempdb
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers