Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
SQL Server Wait Type: PREEMPTIVE_OS_QUERYREGISTRY Read more »
In SQL Server, the fill factor is a configuration option that determines how much space is left on each page of an index when it is created or reorganized. The fill factor specifies the percentage of space that will be filled on each page, with the remaining space left as free space. The fill factor is specified as a percentage …
You call us in the middle of the night, and within 2 hours we’re on the issue with our Highly Available Support Managed Service! Just another perk of this service. This service also includes the following: Contact us today to capitalize on our current Sale going on through the month of January! You get your first 12 months of our …
Synonyms in SQL Server are a useful feature that allow developers to create an alias or alternate name for an object in the database. This can be especially helpful when working with complex or large databases, as it allows developers to use more descriptive or intuitive names for objects instead of the default names assigned by the system. There are …
To find the most used data files on SQL Server, you can use the sys.dm_io_virtual_file_stats dynamic management view. This view contains statistics about the I/O activity of all the data files in the database. To use this view, you can run the following query: This query returns the following columns: The query orders the results by the num_of_bytes_written column in …
Query to find the most used data files on SQL Server Read more »
SQL Server is a popular database management system that is widely used to store and manage data in a variety of applications. As with any system that manages sensitive data, security is a critical concern for SQL Server. SQL Server provides a range of security features and technologies that help to protect the data and ensure its confidentiality, integrity, and …
Sometimes it’s hard to explain the value of something through written word so we filmed Steve to explain our Managed Services. Don’t be shy, contact us with any questions. Capitalize on our monthly special get your first 12 months for the price of 10! This month only! Video Transcription: Hi, I’m Steve Stedman and welcome to this short video on …
The SA (System Administrator) account is a predefined account in SQL Server that has full control over the database server. By default, the SA account is disabled and is not associated with a login. However, if the SA account is enabled and given a password, it can be used to connect to the database server and perform any task. There …
Securing SQL Server: Renaming and Disabling the SA Account Read more »
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS CXPACKET OLEDB LCK_M_IS ASYNC_NETWORK_IO XE_LIVE_TARGET_TVF SP_SERVER_DIAGNOSTICS_SLEEP LCK_M_SCH_M LCK_M_IX LCK_M_SCH_S Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
In SQL, a LEFT OUTER JOIN is a type of JOIN operation that combines data from two tables, based on a JOIN condition. This type of JOIN is called an outer JOIN because it includes not only the matching rows from the tables, but also the rows from the left (or first) table that do not have a matching row …