|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
How Long is a Long I/O? | |
| In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log? | |
Think you know the answer? Click here, and find out if you are right. | |
| Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Multiple Sequence Values How do I easily get the next 12 sequence values from a sequence object? Answer: Use sp_sequence_get_range Explanation: The proc sp_sequence_get_range is used to get a range of sequence values from a SEQUENCE object. Ref: sp_sequence_get_range - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-sequence-get-range-transact-sql?view=sql-server-ver17 |
| Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2019 - Administration |
| Troubleshooting WQL in custom PBM conditions? - Hi, I'm currently trying to implement policy based mgmt with a condition to query event viewer using 'ExecuteWql'. However, WMI uses a different time format, so in addition to my WQL query, I'm nesting concatenating DATEPART() segments to build WMI-time for my WHERE clause. I'm aware of the differences with the GETDATE() syntax ('Day' vs […] |
| SQL Server 2019 - Development |
| setting an ssis param dynamicaly when the sql agent job runs - hi i was hoping for a more elegant way of setting a pkg level param from the sql agent job that runs that pkg. is this as good as it gets? |
| Editorials |
| Local Agents - Comments posted to this topic are about the item Local Agents |
| Every Database Has Problems - Comments posted to this topic are about the item Every Database Has Problems |
| Job Postings |
| Hiring: Financial SQL Systems Administrator - Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial systems environment across a multi-office international law firm. Locations: Atlanta, Irvine, or Los Angeles (Full-time, Hybrid) This role is ideal for someone who enjoys working with SQL, troubleshooting financial systems, and improving platforms used daily by accounting and billing teams. You’ll work […] |
| Job Opening for ERP Systems Administrator - Hybrid - Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific Time Zone or Mountain ERP Systems Administrator in Long Beach, California | Careers at Long Beach What we are looking for We are looking for an ERP Systems Administrator who will be the primary technical expert responsible for the configuration, maintenance, and […] |
| Article Discussions by Author |
| Detecting Deadlocks - Comments posted to this topic are about the item Detecting Deadlocks |
| Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server - Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server |
| Creating a JSON Document II - Comments posted to this topic are about the item Creating a JSON Document II |
| Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6 - Comments posted to this topic are about the item Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6 |
| The Vector Data Type - Comments posted to this topic are about the item The Vector Data Type |
| What Power BI DirectQuery does to your SQL Server (and how to fix it) - Comments posted to this topic are about the item What Power BI DirectQuery does to your SQL Server (and how to fix it) |
| SQL Server 2022 - Administration |
| Query compile/runtime issue - I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time of 2026-04-23 00:30:18.7770000 +00:00 Last_compile_duration of 17105 Sys.query_store_runtime_stats for the plan, between 2026-04-23 00:00:00 and 2026-04-23 01:00:00, show an avg_duration of 74429 and execution_count of 1 sys.query_store_wait_stats shows a CPU and Buffer IO waits totalling 33ms So if […] |
| Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups - We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode (cluster) and two in asynchronous commit mode. On the primary replica, we run SSIS workloads. The secondary replicas are used for reporting, with read-only operations routed through ApplicationIntent = ReadOnly. We also enabled AG load balancing to distribute the reporting workload […] |
| SQL Server 2022 - Development |
| data compare between 2 tables with same structure for any changes after etl run - i have huge table with lot of data and is also wide. i took a backup of it before procedure is run in test environment. now i am trying to see only using SQL what changed and finally what i am expecting is how many inserts, updates or deletes are there. i have some idea […] |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |