|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Enabling Change Tracking | |
If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022? | |
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) |
Getting the SQL If I run this code, what is returned? SELECT * FROM sys.fn_get_sql(0x0500FF7F149270E460F3E0ADD701000001000000000000000000000000000000000000000000000000000000) AS fgs Answer: This returns the SQL executed for the handle passed in as a binary value Explanation: This only returns the text of the SQL statement for the plan handle. Ref: sys.fn_get_sql - https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-sql-transact-sql?view=sql-server-ver16 |
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 - Development |
Replace with like join - I am trying to create and Update query based on a like join. Is that possible? This is what I have: UPDATE claim SET incident_desc = CASE WHEN incident_desc like '%' + NAC.Glyph + '%' THEN REPLACE(claim.incident_desc, NAC.Glyph, NAC.Replacement) ELSE incident_desc END FROM claim INNER JOIN NonASCIICharacters NAC ON claim.incident_desc LIKE '%' + NAC.Glyph + […] |
built in deadlock information capture - Hi, i cannot recall the object or even if it comes off the shelf but i once saw a tool in sql server where the competing tables etc involved in a deadlock are recorded. I think you had to know a bit about the complicated looking test it provided but it was sweet. my recollection […] |
why do my advanced i/o column lengths on city keep changing - hi , every time i go back to an ssis pkg that is under construction, at least one column in a tsv needs to be reset in the advanced properties of the oledb source from 50 bytes to 256. Even though last time i edited it, i saved the pkg. why is that happening? Today […] |
Anything that is NOT about SQL! |
NKTg Law on Varying Inertia – A Different Way to Think About Motion - Hi everyone, I’d like to share something from the science side of life rather than the SQL side. It’s called the NKTg Law on Varying Inertia. In classical mechanics, Newton’s laws describe how objects move under the influence of forces. But the NKTg Law takes a different angle: instead of focusing only on forces, it […] |
Editorials |
Carrots and Sticks - Comments posted to this topic are about the item Carrots and Sticks |
Storage Enhancements - Comments posted to this topic are about the item Storage Enhancements |
Everyone Wants a Piece of the AI Pie - Comments posted to this topic are about the item Everyone Wants a Piece of the AI Pie |
Article Discussions by Author |
How to create your custom GPT SQL Expert - Comments posted to this topic are about the item How to create your custom GPT SQL Expert |
MongoDB and NodeJS in action - Comments posted to this topic are about the item MongoDB and NodeJS in action |
SQL Server 2022 - Administration |
CDC job running for 17 days? - Good morning, I've noticed my CDC job running for 17 days. I've noticed it before, but wasn't sure it was an issue. I've checked sys.databases to check the log_reuse_wait_desc to see if it said "replication". It says nothing. The Database is 8 TB and the log file is 23 GB. I queried : SELECT job_id, […] |
Database growth events for unidentified databases - We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly reports have started showing regular growth events for the following database files (see attached). model_replicatedmaster (both the replicatedmaster and replicatedmasterlog files) model_msdb (both the MSDBData and MSDBLog files) Firstly, what databases are these? I'm familiar with model, master, msdb and tempdb […] |
distributed availability group query - Not sure if this is my misunderstanding or an error in my process: Create AG1 on server 1 & 2. (2019). Add DB1. Replica are joined, DB1 is synchronised. Create AG2 on server 3 & 4. (2022). Add DB2. Replica are joined, DB2 is synchronised. Remove DB2 from AG & drop on both. Create DAG […] |
Can a Database be in an AG and do log shipping at the same time? - Hello, I have a large database about 8 GB. It is in an AG. I have three replicas (Replica1, Replica2 and Replica3) Replica1 is Primary and healthy Replica2 is Secondary and heathy Replica3 is Secondary and not healthy. I need get Replica3 healthy again. My thought was to wait until after the normal backup […] |
SQL CAL based Licensing - Hi Folks, I am about to purchase SQL server licences and need your advice on the Device CAL model. I understand we have to pay for the server license and then as per device count. SO if we have 2 application servers , with each routing 5 client connections, do I have to pay for […] |
SQL Server 2022 - Development |
azure vm has to be rebooted more often than we'd like - Hi we're noticing this 2022 server gets into a funk now and then. Specifically, i notice when i script existing tables to the clipboard etc it just hangs with that circle continuing to spin. i notice that if i reboot, the problem goes away for a while. does the community have a similar experience? […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |