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,460 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...
I'm struggling setting relationships among tables. I understand the one-to-many, many-to-one, many-to-many, and self-referential...
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,...
What is the output of this code in SQL Server 2022?
select bit_count(0xEF)See possible answers