How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
7,804 reads
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
7,804 reads
This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
2023-05-05
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
998 reads
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,459 reads
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
3,890 reads
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
6,639 reads
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,472 reads
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
9,798 reads
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...
The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...
Hi All, need help with an SQL query. We have an existing table that's...
I connect to this clustered instance and run : begin distributed transaction Msg 8501,...
Several times in the last couple of days I've had submissions time out with...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers