Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
3,044 reads
Manvendra
- Skills: SQL Server, Cloud, Azure,
How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
9,443 reads
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,008 reads
Understanding the Metadata Function DATABASEPROPERTYEX()
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
2,150 reads
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,568 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
DeepSeek: What is new with this AI technology?
Comments posted to this topic are about the item DeepSeek: What is new with...
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers