|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Deprecated Features | |
I am running SQL Server 2019, and I have an old codebase. I am worried that I might be using features that are deprecated and don't want to add new code using them. How can I easily check what features are deprecated on my version when writing code? | |
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 Managed Instance Features Which of these are allowed in an Azure SQL Managed Instance? (choose 2) Answer: Copy only backups, OPENDATASOURCE Explanation: You are allowed to use OPENDATASOURCE (with some limitations) and perform COPY ONLY backups. You cannot attach database files or create database snapshots. Ref: Features of SQL Managed Instance- https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison |
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 |
SSIS guidance - hi all Looking for a general directional pointer on something I am trying to achieve in SSIS I want to pull a number of column values from a table in a DB , store these in a variable and then use that variable in an outbound API call which will use those values as parameters […] |
SQL Server 2016 - Administration |
xp_cmdshell - how to check which job or stored procedure using xp_cmdshell in sql server ? |
consolidate error logs - i need to configure job to consolidate sql error log sizes from multiple servers , iam not proficient in developing scripts nor packages , any one help in doing this task . |
User unable to see Logins after recreation of permissions in new instance - Hello All I was tasked with setting up a new instance on the same server, but with a higher version (from 2012 to 2016). User would like to test higher version before moving dbs there. After installation I recreated all the logins using these guidelines - https://www.sqlshack.com/move-or-copy-sql-logins-with-assigning-roles-and-permissions/ User confirmed successful login, but one thing that's […] |
SQL Server 2016 - Development and T-SQL |
? on Count specific value on XML data - Hi How do I find a count of a specific value in XML? data.value('count(/SampleXML/Colors/*)', 'int') finds all so say Black in [1] and Red in [2] and Black in [3] How do I get Black 2. Red 1 Thanks |
SQL 2012 - General |
How to write update query to check exist column by value 1 where it exist on tab - How to update check exist column by value 1 where partid exist on table FeaturesvalueA or FeaturesvalueB ? I work on sql server 2012 I face issue I need to update column checkexist on table temp where partid exist at least one time on table #FeaturesvalueA or table #FeaturesvalueB But if partid exist on both […] |
How to Update field updatedStuffDiff when i have different values for parts exis - I work on sql server 2012 I face issue I can't update column name updatedStuffDiff with different feature value for every feature based on partid so when i have two part have same feature but different values then display it as result on column updatedStuffDiff based on partidc and partidx on table #temp so result i […] |
SQL Server 2012 - T-SQL |
update query problem - Is there a way to take these two records and update the NULL values in one to match the filled in values for another? e.g. Record One in CallTable: ID# 5263 CallID = 563522 Fname = Ben Lname = Foster Record Two in […] |
SQL Server 2019 - Administration |
Estimating compute cost per type of transaction - Hello, I am creating a program that calculates the Read, Insert, Update, Delete statements that exist in code. Since we know: The type of transaction, the number of parameters passed, the size of the table, I thought good to provide a calculation cost for each program/function. That is to say, A read operation in a […] |
Name of the remote server in a query - Hi, I want to retrieve the name of the remote server in my SQL server query: exec ('CREATE OR ALTER PROCEDURE ins_tmp_proc AS BEGIN INSERT INTO dbo.tmp (job_id, name, ..., server) SELECT job_id, name, .., @@SERVERNAME from msdb.dbo.sysjobs UNION SELECT job_id, name, .., @@SERVERNAME from .msdb.dbo.sysjobs END') I tried executing just the SELECT statement by […] |
SQL Server 2019 - Development |
Stored Procedure "Caching" - I'm having an issue with a database that I recently moved from SQL 2014 to SQL 2019 (Standard in both cases). The users get data from the database using stored procedures either through the UI or linked to Excel (using an ODBC). The users will execute the same procedure multiple times with different parameters expecting […] |
Logic is not wokring - hi, I have 3 types of invoices , INNU,INN1, INN2 I am trying to filter out invoices that are "INN1" and "Unpaid" ( I dont want INN1 Unpaid invoices ) I tried to use the following condition but Its taking out all the "Unpaid" invoice. where [Invoice Class] IN (@invoice) and ( invoice_cl <> 'INN1' […] |
Integration Services |
[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. F - I am trying to get data from myslq into mssql with ssis. I am getting these errors: [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ADO NET Source returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by […] |
The Future of Community |
SQLSaturday Foundation - We are setting up this thread to welcome questions and comments about the latest announcement where Redgate has announced plans to establish a community-run SQLSaturday foundation and donate the SQLSaturday brand and assets. The foundation would support the data platform community to run your own regional SQLSaturday events, which are vital in helping communities across […] |
MySQL |
Longblob to varbinary(max) - hi , I am having issue with SqlMigrationTool migarting mysql data to MSSQL server. During the migration , i have no issues , but when i pulled data with longblob datatype , data is converted to varbinart(max) which is right . But user mentioned data is null for most of the records where she is […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |