Laden...
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Local Storage Options | |
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this? | |
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) |
The Backup Space Needed How do I calculate the amount of space needed for I/O buffers during a backup operation? Answer: This is the buffercount * the MaxTransferSize parameter values Explanation: This is the buffercount * the MaxTransferSize parameter values. Ref: BACKUP - https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-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 2017 - Administration |
Log Shipping Not Able to Restore Log Files in Secondary - I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I have restored the database in the follow storage layout on the SQL Server 2017 machine: D:\Data\.mdf L:\Logs\.ldf When I execute the restore job and it skips all log backups. I ran restore verifyonly for the log backups […] |
SQL Server 2016 - Development and T-SQL |
SSIS - ADO Source Datetime Issue - I'm using an ADO Net Source to extract data and running into an issue with timestamps changing before reaching the destination. I can log directly into the source system and see a value should be 2025-03-01 00:03:14 but SSIS is brining it back as 2025-03-01 01:03:14. I put a data viewer on it so this […] |
Where to see how a Partition schema and function is defined - Please see the below. The dependencies of a table(the table depends on) shows Partition function and partition scheme. However I cant seem to find how and where this function is defined? I can see only user defined functions? Please guide on this |
SQL 2012 - General |
DbaTools With Powershell - Omit The Id Column on CSV Export? - I am learning DbaTools in Powershell, and my current project is exporting a CSV file. I've managed to get the code to work; however, there are situations in which I will need to omit the Identity column when exporting. Is there a way to do this programmatically in DbaTools, so that the CSV file won't […] |
SQL Server 2019 - Administration |
ExecutionLog3 table in Reportserver Database - I have a SSRS report for which users are complaining to be slow, but from querystore, I can see that the SP (Report only has this SP execution) is taking less than 15sec. In ExecutionLog3 table, timedataretrieval for the same report is showing up to be for more than 20 mins. Could anyone tell me […] |
SQL Server 2019 - Development |
String or Binary Truncation Error Strange Behavior (SQL 2019) - Forgot I posted a similar issue back in 2020, String or Binary Truncation Error Strange Behavior, but here we are again, 5 years later with a somewhat similar issue. Here is the message from SQL Server: String or binary data would be truncated in table 'dbo.BAT_Test', column 'NewCode'. Truncated value: ''. Basically, a stored procedure […] |
Cummulative Total - Hi I have below query and i want Cummulative Total . Total should be reset on change of Account SELECT ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "Row No", A."Account" AS "Account",(A."Debit") AS "Debit", (A."Credit") AS "Credit" From Master A Thanks |
SQL Azure - Administration |
Migrating mission critical database from SQL on Prem to Azure SQL - We are migrating our environments to Azure, it will be a mix of SQL managed instances and Azure SQL instances depending on the different system requirements. We offer realtime service to out clients and need to have minimal downtime hen we make the shift. The first database will be migrated to AzureSQL. Our on prem […] |
Transactional Replication from Read replica - If I have Read replica (in Azure SQL MI), can it be used as a Publisher in transactional replication setup. I understand that Replication creates objects some objects in Publisher db, can we use listener name with applicationintent setting anywhere for it use Secondary instead of Primary. AWS DMS works similar to how transactional replication […] |
Azure Data Factory |
Is there a way to determine an Azure Data Factory Trigger's "next run time"? - Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a scheduled trigger will run next. Is similar functionality available in ADF? |
Anything that is NOT about SQL! |
Fantasy Football 2025 - The thread for the league in 2025. Players from last year have priority. |
SQLServerCentral.com Website Issues |
Everyone is a Newbie? - Everyone seems to be a Newbie with zero points today! Browser = Chrome |
SQL Server 2022 - Administration |
SQL availability group and file server role answering from the same name - Hello, I'm tasked with setting up a 2 node server cluster that will host a MS SQL availability group. I have the servers setup and the AG looks to be working well. However, there is also a requirement to hang a share off of one of the drives. I'm not crazy about this requirement, but […] |
Installing SQL FCI Instance certificates - SQL FCI Instance certificates I have a client who has a requirement for certificates bound to the instance in a FCI environment. I have create the certificate and installed on both nodes, but I get a cluster error when failing over. The environment setup Node1 Node2 FCI Instance name\SQLInstance Have set the FCI and […] |
SQL Server 2022 - Development |
SSIS how to manage source control with multiple packages / projects - We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams. I thought this was the proper way to go. The problem is managing this when I am in the middle of developing one of those solutions. What I usually do is just make a copy of the folder the solution […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2025