|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Restoring the Deleted Azure Database | |
I have configured long term retention for the Sales database in Azure, setting this to retain backups for 6 months. This is an Azure SQL Database. After this has been running for 3 months, we have a major issue and need to restore from a previous backup. We do this, restoring the backup as Sales_New, then deleting the Sales database and renaming Sales_New back to Sales. I then realize that the retention period for this new database (Sales_New)was reset to 7 days. What has happened to the other backups from the original Sales database? | |
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) |
Container Memory What is the default max memory for a Linux container running SQL Server? Answer: 80% of physical memory in the container Explanation: The default is 80% of container physical memory. This can be altered with the MSSQL_MEMORY_LIMIT_MB environment variable. Ref: Linux Container Environment Variables - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-ver15 |
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 |
Profiler and Tuning Advisor Stats Recommendation - I ran SQL Profiler and did a trace, and after handing the file off to the Tuning Advisor, it had some Index recommendations which is understandable. However, there are a ton of statistics recommendations. The capture I did was only for about 20 seconds. The recommendations were very numerous, but the main thing is that […] |
display cluster alwayson in windows - hello , I need your help please in my server SQL on ssms I can display my avaibility group always on and the nodes and the listen so if I connect through failover cluster manager I have nothing thanks |
SQL Server 2017 - Development |
Email CSV file - We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV filename. Here is the line we are using now for the filename: @query_attachment_filename = 'test.csv' We are thinking of 3 different formatting options: MMDDYYYY.csv Wynne-MMDDYYYY.csv MMDDYYYY-Wynne.csv […] |
SQL Server 2016 - Administration |
Rebuliding a WSFC with availability groups - We have been having issues with nodes loosing communication on a underlying WSFC that we have our Production Always on Availability Groups on. The Server provisioning team seem to reckon that the cluster, that they built, is not in the best of shape and are talking about rebuilding all the cluster servers. Being a DBA […] |
SQL Server 2016 - Development and T-SQL |
SSRS Int64 Multi Select Report Parmeter error - I have a SSRS report in VS2017 that pulls Int64 values into a Report Parameter named "pCampusEquipment" but fails at runtime with a "The property "ValidValues" of report parameter "pCampusEquipment" doesnt have the expected type" error. The parameter works fine if I changed parameter Data Type to "Text" instead of "Integer" but the SQL Call […] |
Pivot with Ranges - This is my table BSEG_ID DST_ID BILL_SQ AUDIT_CALC_AMT Remarks 12334 REV-WSC 62 6.40667 For 0 - 60 (Next 62.000 cubic meter) @US0.10 per cubic meter 12334 REV-WSC 62 64.06667 For 60 - 120 (Next 62.000 cubic meter) @US1.00 per cubic meter 12334 REV-WSC 3.6 11.16 For 120 - 180 (Next 3.600 cubic meter) […] |
Development - SQL Server 2014 |
How to get all the column name and data type a table variable - there is a parameter in stored procedure, and this parameter is table variable, How to get all the column name and data type for a table variable? thanks! |
SQL 2012 - General |
How to select data based dynamically based on start and end of AffectedProduct ? - I work on SQL server 2012 I need to get data from #partsdata table where part number matches Affected Product both start and End as Example where I have Affected Product as APAMS-***G then I will get Parts That have start APAMS- and End by G start must be end with dash (-) this roles […] |
SQL Server 2019 - Development |
Create string from broken hierarchy - Hi I have a broken hierarchy where I need, for each row, to create a string that contains all possibæe combination ordered by creationdate (id column) So for the 1st row it would be: |96811577|2959885|5825374| as row 3 and 5 contains the same values then the result here should be the same as above. I […] |
Issue with Foreign Keys - So recently I began to start a personal project to push my limits and try to gain an edge on database work. I have been using MySQL and I am using IonnDB to make use of the Foreign Key relational system. I wrote a long document of tables that I could copy and paste to […] |
Reporting Services |
Report acting Differently in SSRS Report Editor and on the Server - Having a really interesting problem. I've added a subreport to an existing report, by adding a second detail row, merging the columns and putting the subreport there. Originally I had the subreport set to hidden and visible by toggling a group button (in y case, Division). Works, but when I run the report the row […] |
Integration Services |
SSIS : How to export data into Excel from Stored Procedure - I might be barking up a wrong tree, but hope someone can advise on the forum. I have an established stored procedure, which returns a list of records, e.g. EXEC my_stored_procedure returns idColumn (INT) and descColumn (VARCHAR(50)). Now I have a new task to write SSIS to export same result set into an Excel file […] |
Error running simple SSIS package - I have a simple package that loads a small staging table from a CSV file. I create the table (succeeds), truncate it, then reload it via OLE DB. It fails on truncate table SQL task. [Execute SQL Task] Error: Failed to acquire connection "WIN-3SVP8BUQIEM_SQL_2016.AdventureWorksDW.sa". Connection may not be configured correctly or you may not have […] |
PowerPivot |
Default values for power bi slicer - In most any data analysis tools a fundamental function is the ability to set a default value for a slicer or report parameter. Power BI being the exception. I know there are dozens of semi effective results in a simple google search to circumvent this glaring deficiency in Power BI. I realize that this post […] |
SQLServerCentral.com Website Issues |
Changing my username email - Apologies if this has been posted but I did a search on email and profile and didn't find anything similar. I have changed jobs and consequently need to change the my email username. When I go to "Edit Profile" under "Profile" on my user account, I am able to do the changes and it says […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |