|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Migration Tool to Use | |
Which migration tool is suited to assess my SQL Server data estate and lift and shift my estate to SQL Server on Azure VMs? | |
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) |
EXCEPT Details What is the proper description for the EXCEPT operator? Answer: returns distinct rows from the left input query that aren't output by the right input query. Explanation: From BOL: EXCEPT returns distinct rows from the left input query that aren't output by the right input query. Ref: EXCEPT - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-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 |
Unable to Communicate to SQL 2005 via Linked Server - Hi all, I'm having issues communicating via a linked server from a Windows 2019 Standard server running SQL 2017 Standard to a Windows 2003 R2 Enterprise server running SQL 2005 Standard. The operating system on the source server was just upgraded from Windows 2012 R2. Error: OLE DB provider "SQLNCLI11" for linked server "server" returned […] |
SQL Server 2016 - Administration |
Extended Events: using ATTENTION Event to log external apps timeouts. - The purpose I created the attached Session and one of the queries to view data and periodically reload it to the table WAS BECAUSE once in a couple of weeks we have had this nasty bottleneck in our environment when instead of an average of 40 or 50 timeouts (from ASP web pages/IIS) per day […] |
Is it possible to purge Extended Events file (target) contents? - Is it possible to purge the Extended Events file's (target) contents WITHOUT deleting the file or dropping and recreating the session? |
SQL Server 2016 - Development and T-SQL |
SQL convert Rows to columns - I have seen several posts on this many of which suggest Pivot. I am trying to mimic a MS Access report that used VBA to format the columns. I have been working on this for awhile and I am still no closer to solving it, here is the Problem. Some of my attempts have involved […] |
Administration - SQL Server 2014 |
Upgrade 2014 Web Edition to Standard - Hello. I'm working with a client who currently has a SQL 2014 Web Instance which I am considering upgrading to SQL 2014 Stanard. Can this be achieved by installing a Standard edition SKU or will a reinstall or full upgrade be needed? I have no real knowledge of Web edition so am looking for some […] |
SQL 2012 - General |
Implementing TLS In sql server 2012 - Hi Experts, In my project we have 2 servers Webserver and one is database server . We are planning to Implement the TLS in the database server and our DBA can handle the the step to implement TLS on the database server. My query is what all changes we have to do on the Webserver […] |
SQL Server 2012 Stored procedure question - In the program I'm working with, I need to build a stored procedure just to create a field in the cms editor drop down. It is very basic, or so I thought. I just want to test the field for a value and if it is there, print a line of text. That's it. It […] |
SQL Server 2019 - Administration |
Azure SQL Server - consideration - There are a few options for Azure SQL Server Vanilla Azure SQL Server (SaaS) Azure SQL Server using VM image (IaaS) Azure SQL Server Alwayson I'm trying to understand what option replaces the best an on-premises SQL server accessed by multiple servers, that will become multiple "callers" in Azure. |
SQL Server 2019 - Development |
Flow Control Problem with multiple statements - I am creating a function that should retrieve a numerical value from notes. This can be represented a few different ways and I used a number of IF Statements to accomplish this. For some reason, it seems to be executing code in the Final IF Statement. The simplified code at the top works and produces […] |
SQL Azure - Administration |
Azure Data Studio - SQL Profiler - save or export results to table - I can launch SQL profiler (Alt P) using Azure Data Studio and can see the system logs on the screen. However, when I stop the trace session on the screen, and change the [Select View] option on the top right, all the data that was collected initially gets lost. How to save the results of […] |
General Cloud Computing Questions |
Gaining Practical Experience in Cloud - Hi All, I have worked in IT for a little over 10 years, starting in helpdesk, and working my way up to an enterprise systems administrator role, and finally ending up in Internal Audit as an IT Auditor. In my current role as an auditor I get to see a lot of different technology, but […] |
Reporting Services |
Ratio from Metrix - Hello Calculating ratio from metrix - or if you have other way of doing it please ratio is SUM of A for 2018 divided by SUM of B for 2018 multiplied by 100 for percentage purpose Please see attached file to see whats given and required 75 = ( 300/400)*100 Thanks |
ssrs calculation not working - I have a SSRS report that i need to calculate the Variance percent totals which the math logic goes Occupied Variance % - Vacant Potiental percent - Damaged Potiential percent Occupied Variance = 5% Cacant Potiental = -5% Damaged Potiential = -3% so it 5% -(-5%) -(-3%) How do i write this in a SSRS […] |
Continuous Integration, Deployment, and Delivery |
CI/CD to deploy database using Gitlab - Hello, I want to do CI/CD do deploy database (sql server) and ssis package using Gitlab , but the problem i don't know how can i start and also i didn't fount any tuto on the internet. Can someone help me how can i start to do that ? and also if possible to do […] |
Integration Services |
Transfer SQL Table Data into Excel - Hi everyone, I have designed a SSIS package that transfers SQL table data into an excel file. I am fetching data via this query: /****** Script for SelectTopNRows command from SSMS ******/ SELECT CONVERT(NVARCHAR(4000),[LIST_TYPE]) AS LIST_TYPE ,CONVERT(NVARCHAR(4000),[LIST_CATEGORY]) AS LIST_CATEGORY ,CONVERT(NVARCHAR(4000),[LIST_SUBCATEGORY]) AS LIST_SUBCATEGORY ,CONVERT(NVARCHAR(4000),[LIST_DESCRIPTION]) AS LIST_DESCRIPTION ,CONVERT(NVARCHAR(4000),[LIST_VERSION]) AS LIST_VERSION ,CONVERT(NVARCHAR(4000),[T2_CODE]) AS T2_CODE ,CONVERT(NVARCHAR(4000),[T2_TYPE]) AS T2_TYPE ,CONVERT(NVARCHAR(4000),[T2_NAME]) […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |