|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Multiple Sequence Values | |
| How do I easily get the next 12 sequence values from a sequence object? | |
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) |
Detecting Deadlocks By default, how often is the SQL Server Database Engine checking for deadlocks? Answer: 5 seconds Explanation: By default, the engine is checking every 5 seconds. Ref: Deadlock Detection - https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-deadlocks-guide?view=sql-server-ver17#deadlock-detection |
| 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 |