|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Concatenating Dynamic SQL | |
I execute this code on SQL Server 2019. Each of the tables has one row in it. What happens?
DECLARE @SQL NVARCHAR(4000); SET @SQL = ' SELECT mystring FROM TableA;'; SET @SQL += ' SELECT mystring FROM TableB;'; select @SQL | |
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) |
Minimum Point in Time Recovery for Azure SQL Databases There is a default period of time for point in time recovery (PITR) on Azure SQL databases for 7 days. However, this can be reduced to lower your storage costs. What is the minimum number of days you can configure for PITR for active and deleted databases? (as of Aug 2021) Answer: 1 day for active databases, and 0 days for deleted databases Explanation: As of Aug 2021, you can set your PITR to 1 day for active databases and 0 days for deleted databases. There are considerations in terms of recovery, so be aware of the implications of shrinking this window. Ref: Backup storage cost savings for Azure SQL Database and Managed Instance - https://azure.microsoft.com/en-us/updates/backup-storage-cost-savings-for-azure-sql-database-and-managed-instance/ |
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 - Development |
Inline Table - Please assist creating an inline Table Valued Function. Output https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=drivesdk Data https://drive.google.com/file/d/1mkBA8Uc8tZjhWdzqGaxLAPnNoqpBSfMZ/view?usp=drivesdk |
Inline Table - Please assist creating an inline Table Valued Function. Output should look like this: https://drive.google.com/file/d/1NlImnhE35Zattw4KKH7gVrQcGcMsSlRJ/view?usp=drivesdk Data https://drive.google.com/file/d/1mkBA8Uc8tZjhWdzqGaxLAPnNoqpBSfMZ/view?usp=drivesdk |
SQL Server 2016 - Administration |
Shrink never ends - Hello, Sorry for my English. I am aware of the problems and why we should never perform a shrink, however, in this case it is necessary. I have a database where the mdf file is about 1.6Tb, but the database only uses 800Gb and I need to reduce it. I tried to reduce only 10Gb […] |
SQL Server 2016 - Development and T-SQL |
Need help with calculating data between 6pm-6pm instead of 12am-12am - Hi, I am looking to calculate some data. We have orders dropping every day, and I need to calculate the number of orders that dropped between 6pm yesterday till 6pm today. I tried doing DATEADD(HOUR,-6,cast(CONVERT(VARCHAR,CREATE_DATE)+ ' '+ CONVERT(VARCHAR,CREATE_TIME) as datetime)) but that just changes every hour to go back 6 hours. I need to create […] |
Dynamic SQL? Inserting Sproc data into table variable - Hello, I have a bunch of stored procs that I'd like to execute all at once, insert their results into a table variable, and then insert those results into a physical table. I can get the code to run fine to actually execute all the sprocs one after the other using a cursor (there aren't […] |
SQL Server 2019 - Administration |
SQL 2016 to 2019 upgrade benefits - Can someone help me with good reasons / selling points to upgrade from 2016 to 2019? |
SQL Server recovery - Hi There! Question related to recovery of SQL Server....When an SQL server crashes, from where does SQL server know the recovery path, as the buffer (RAM)contents are lost during crash ? Thanks in advance. Best Regards Arshad |
How to start an Index Review Project - Dear Colleagues, I’m not sure this is the proper channel If you were in charge of review a group of databases and give index recommendations, and this is the particular point of interest. How could you start your session, I’m thinking in Current index inventory Current index usage New indexes recommendations What do you think […] |
Unable to uninstall sql 2005 on windows 2008R2 - Dear, unable to uninstall sql server 2005 on windows 2008R2 server, when i click on uninstall from control pannel, after a while the uninstall window will disappear and it is not uninstalling. Thanks |
SQL Server 2019 - Development |
Non-clustered Index - I have a blog. To log in, I request a User Name. Should I have a non-clustered index on that column? Also, in another table, I query on the email address, should I have a non-clustered index on that column? In both tables, I have an integer field as the primary key. |
View or Stored Procedure? - To create an output like this: Do i create a stored procedure or view that would allow this end result above? SQL: |
Extraction of mean, max, min and sd extraction inside 5-95 quantiles - I'd like to extraction the mean, max, min and sd extraction inside 5-95 quantiles for the variables B2, B3, B4, B8, NDVI, SAVI, SIPI, SR, RGI, TVI, MSR, PRI, GNDVI, PSRI, GCI aggregate by AGE and ESPAC variables inside CMPC table: CREATE TABLE CMPC( x NUMERIC(8,4) NOT NULL ,y NUMERIC(8,4) NOT NULL ,stand VARCHAR(11) NOT […] |
Azure Data Factory |
data flow "delete if" setting- sink Delta lake - Hello, I have the upsert if working for the .parquet files by selecting the upsert if setting to true() For example when the source is update ,then the parquet sink is updated accordingly. But if a row is deleted in source it is still shown in sink parquet even when check the Allow Delete. Any […] |
Connecting |
AZ Sql Database Cross Database Query Identity syntax - Attempting to follow directions from @SteveJones & MS documentation for setting up key for Azure Sql Server cross database queries. CREATE MASTER KEY ENCRYPTION BY PASSWORD = ''; CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH IDENTITY = '', SECRET = ''; We're receiving an error with the IDENTITY parameter. The examples look very straightforward but aren't […] |
General |
Is it possible to improve one's environment, by going rogue? - Today Steve Jones posted an excellent article on whether or not your company has a talent gap. I recommend you read it. While responding to Steve's article I had a thought. I felt my ideas were too far off Steve's article, so I didn't want to detract from his thread. So, I'm going to ask […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |