|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Minimum Change Tracking Retention | |
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by dbakevlar) |
Tables with a SPARSE Column and Consumption True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL. Answer: True Explanation: The answer is TRUE. SPARSE columns are space-saving only when the majority of values are NULL. If most values are NOT NULL, they can consume more space than standard columns due to additional overhead. Ref: Sparse Columns - https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?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 2012 - General |
SQL Server authentication vs. Trusted connection - I maintain an application written years ago, where the database is on a Windows 2012 R2 Server and the database is SQL Server 2012. The people who configured this application made it so that it used SQL Server Authentication. I've always taken it to be the case that SQL Authentication was the only way of […] |
SQL Server 2019 - Development |
is there a way to "detect" schema like changes on a server? - Hi, we have a few people who like to experiment on our prod sql server with new tables, schema changes, dependency chain breaks, maybe ssis, even ssrs etc etc without telling anyone till its too late. They hold high ranking positions so forget your first thought. I often end up with technical debt or sheer […] |
SQL Azure - Development |
How to resolve issue of custom Audit log table containing incorrect data? - We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. […] |
SSRS 2016 |
ssrs subscription file share - I am trying to create a subscription that posts to a one drive directory. I reset my password through microsoft and then copied that password when setting up the file share subscription. When the subscription executes I get 'a logon error occurred when attempting to access the file share. the user account or password is […] |
SSDT |
Visual Studio SSIS Package Showing Up Blank - Hi all, this is my first time posting on this forum, thank you all very much in advance. I have a .dtsx package open in Visual Studio, and one of the Script Tasks are erroring with "The binary code for the script is not found. Please open the script in the designer by clicking Edit […] |
Snowflake, DataBricks, Redshift, and other cloud warehouse platforms |
just finished a deep dive into snowflake - Hi, i know this is a sql forum but snowflake purports to interface with everything so i was hoping to get an opinion from some of the pundits in this forum. Does anyone in this community have an opinion either way of the snowflake product? One of the biggest areas of confusion is that they […] |
Editorials |
Guidelines and Requirements - Comments posted to this topic are about the item Guidelines and Requirements |
Concerns over AI Chat Privacy - Comments posted to this topic are about the item Concerns over AI Chat Privacy |
MySQL |
MySQL 5.6 not writing any logs - We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of errors. The below is a snippet from the ‘my.ini’ file: # Commented lines aren’t included [mysqld] […] |
Article Discussions by Author |
Copying Production Schema - Comments posted to this topic are about the item Copying Production Schema |
Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric - Comments posted to this topic are about the item Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric |
Database File Growth Report Script - Comments posted to this topic are about the item Database File Growth Report Script |
The Duplicate Cursor - Comments posted to this topic are about the item The Duplicate Cursor |
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1 - Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1 |
What is Delayed Durability in SQL Server — And Should You Turn It On? - Comments posted to this topic are about the item What is Delayed Durability in SQL Server — And Should You Turn It On? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |