|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Removing Deleted Pages | |
I delete a lot of rows from a large table. This appears to happen quickly, but I find the space is not able to be re-used right away. What background process in SQL Server actually removes the records? | |
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) |
Azure SQL Database Purchasing Models What purchasing models are available for Azure SQL Database (as of Jan 2022)? Answer: vCore and DTU Explanation: The purchasing models are vCore and DTU. In the vCore model, there are different tiers, such as business critical or hyperscale. Ref: Azure SQL Database Cost Management - https://docs.microsoft.com/en-us/azure/azure-sql/database/cost-management#prerequisites |
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 |
Saving changes is not permitted - I would like to create a data model a excel . I have no problem moving the data from source to target and also apply appropriate data types. I am having this problem as seen below. Even when i just import the table and leave data types as is, i am getting this problem. Also, […] |
SQL Server 2016 - Development and T-SQL |
Comparing nvarchar with string has started generating weird conversion error - Hi, We are running SQLSERVER 2016. We have a process that has been running fine for years that this month has run into an issue. There is a simple select statement that links 3 tables. SELECT count(*) FROM TABLE_A A INNER JOIN TABLE_B A ON A.X = B.X INNER JOIN TABLE_C ON B.Y = C.Y […] |
SQL Server 2012 - T-SQL |
Is there any better optimised way for insert in multiple tables using JSON - Hello Everyone, I just started a developing a new application for hospitals (for maintaining hospital staff, patient, appointments etc.). I started with the database part first. I will use APIs as back-end. So I just thought why not I should take all data in one go in JSON and try to insert it. So here […] |
SQL Server 2019 - Administration |
Connection to the different domain from SSMS - Hi , I installed SSMS in my local machine. In the company they do create admin account to connect to the sql server instances. My local windows login (normal windows account) is different from admin account. How to connect to SQL server from your local installed ssms. Thanks, Ramana |
AlwaysON Availability Group Wizrd Replica empty - Anyone seen this when setting up an AlwaysON. Going thru the Wizard and the replicas are missing. I've done this multiple times but somehow this seems to be an issue now. 2012, 2014, 2016 don't seem to have a problem. This is on 2019 only. Cluster is good. The screenshot from this is from a […] |
SQL Server 2019 - Development |
Refactoring an Entity Attribute Value schema - Apologies in advance, as I know this has been discussed a million times already but I think our requirement is slightly different from the norm in that we have a well-defined, static set of attributes up front and our values are rows in a table. But feel free to ignore if you've had enough of […] |
SSIS package to select a button on a windows app - Hi everyone I am creating an SSIS package where I run an windows program to download data. The data provider doesn't allow people to make direct connections to their DB so the only way to get the data is from their windows app. I am writing a script that accesses that program and downloads the […] |
Does a while loop read all the records in a table? - I hope this isn't too long, but I wanted you to understand why I am doing what I am doing/ I have a group of oil tanks numbered 1 through 30 that are linked to a master tank via hoses. When 10 tanks fill up, their valves open and send the oil to the master […] |
SQL Azure - Development |
Receive email from Azure - Is there a way to receive email from Azure, I would like to catch and receive failed error via powershell runbook. for example process SSAS model. |
General Cloud Computing Questions |
Career advancement in cloud - I am a SQL server administrator with 5 years of pure DBA experience. I am planning to get trained into cloud like Azure or AWS or any other cloud technology where there is a future growth. Can someone guide me which patch to take, is it Azure or AWS. Since i am an administrator i […] |
Azure Data Factory |
Copy empty folders in ADF - I am using ADF to copy folders from On-premise to Azure Blob storage. All the folders are getting copied except the ones which don't have any files, but customer requirement is to copy the empty folders as well . Microsoft documentation says that if we select 'recursive' option in Copy activity , empty folders are […] |
Powershell |
Store invoke-sqlcmd result in PowerShell variable and use it for comparison - Hello, I was trying to store invoke-sqlcmd result in a PowerShell variable but it seems that I am doing something wrong because $dbsize variable in the below code does not store the value from the invoke-sqlcmd. I would appreciate if I can get some help with it. param ( [string]$ServerName, [string[]]$databaseName ) $date = Get-Date […] |
Integration Services |
Upgraded DLL reference - I have an SSIS package which uses dotConnect for MySQL - currently using the 130 DLL. We're migrating our packages to SQL2019 and that requires the 150 DLL. However I cannot find (remember?) a way to change the reference to the DLL in my package. Can anyone advise? I tried changing it manually in the […] |
Accessing variables dynamically - I have an SSIS package which updates a number of tables and sets a variable upon success. I'd need to review these variables and set an error message accordingly. I'd like to avoid having to change the Script Task every time I add a new table, so is there a way to step through the […] |
Design Ideas and Questions |
Conceptual design and When to define schemas - we are in the conceptual phase of our project. UI design just finished and front and backend development is just starting. We are defining entities and attributes. And trying to get more specifications from the design and development groups so that we can most accurately define all the entities. I was thinking to propose […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |