Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
2,677 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
5,207 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
3,071 reads
Understanding the Metadata Function DATABASEPROPERTYEX()
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
1,845 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
1,752 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
How to Check previous data loaded records vs current day in a table
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...
Permissions Changes Not Doing Anything
Hi friends, So I have a Login to a server that is a windows...
Ask SSC