SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,060 questions
3 answers
Transaction Log noticeable used space after restoring the database from a .bak full backup
Dear everybody! I have an isolated server and a database on it with no running transactions. First, I performed a full backup of this database, then deleted it and then restored it from the created full backup. When I check for log file’s used space…
1 answer
Reporting services disk icon to export doesnt work at production
Hi. I am stucked with error on production when opening a report ( I have some reports working - which has parameters. The one which doesn't work does not have any parameter). Also in console (at production only, locally all is fine now) i see error …
asked 2021-02-24T11:06:14.647+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 56.00000000000001%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEW%3C/text%3E%3C/svg%3E)
Emanuel Wiaderek
1
Reputation point
answered 2021-02-25T02:55:32.353+00:00
ZoeHui-MSFT
34,576
Reputation points
1 answer
Power BI Report Server - January 2021 update- Cascading parameters is not updating
Hello dear Community, I need your help. We have many reports (.rdl) in PowerBI Report Server. Most of these reports are using Cascading parameters. For example, we have a ClientNo parameter, it is a dropdown menu. When the user is selecting it, the…
asked 2021-02-24T10:39:32.303+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 55.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Meydani, Elahe
1
Reputation point
answered 2021-02-25T02:05:48.277+00:00
Joyzhao-MSFT
15,566
Reputation points
3 answers
One of the answers was accepted by the question author.
Microsoft SQL Server 2014 -Restaurar Respaldo de 2 TB es muy lento
Hola a todos: Tengo instalado Microsoft SQL Server 2014 Ent, maquina de 8vCPU's y 46 GB Memoria RAM configurado para la instancia, dejando libre el 20% para el sistema operativo (IaaS). El problema que tengo es que tarda en restaurar 24 hrs el…
asked 2021-02-23T18:57:46.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 15%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Adrian Bautista
21
Reputation points
commented 2021-02-24T22:33:24.17+00:00
Erland Sommarskog
103.2K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Report Builder 3.0 - difference between one row and next where value is an aggregate
I have a table like the following Where the total count is a sum of values for the month/year, so the row groups are Year, Month I would like to include another column that shows the running difference in count from one month to the next,…
asked 2021-02-24T17:52:33.583+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 51%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Natalie LLoyd
21
Reputation points
accepted 2021-02-24T21:38:44.06+00:00
Natalie LLoyd
21
Reputation points
1 answer
One of the answers was accepted by the question author.
“Create Catalog” is greyed out in SSIS
I'm try to create catalog in SSIS but when right clicking on Integration Services Catalogs, the Create Catalog is greyed out. It is a SQL server 2017 Developer edition. How can this be fixed?
asked 2021-02-24T19:58:38.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 57.99999999999999%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kamalpreet Singh
81
Reputation points
accepted 2021-02-24T21:28:40.413+00:00
Kamalpreet Singh
81
Reputation points
3 answers
One of the answers was accepted by the question author.
Windows Error Reporting
Fault bucket 1251951692396285858, type 5 Event Name: SQLException64 Response: Not available Cab Id: 0 Problem signature: P1: sqlservr.exe P2: 0.0.0.0 P3: 0000000000000000 P4: sqllang.dll P5: 2015.130.4259.0 P6: 000000005D05A26A P7:…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 55.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How do I upgrade SQL server running in Azure to latest version?
Hello, I have a SQL server running in Azure. When creating the SQL server, there is no version selection. After creation, I see that it is running version 12, which I believe is 2014. This version is not compatible with my use case of the server (running…
asked 2021-02-22T22:34:22.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 62%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gabby Chuchro
21
Reputation points Microsoft Employee
accepted 2021-02-24T16:42:14.31+00:00
Gabby Chuchro
21
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Matrix Sum
I have a matrix and this matrix is grouped by 'Naam, Reg nr, Locatie'. The colom headers are 'YYYYMM' en subheader 'Uitvoercode'. Now at the end i want a sum of all rows together. If I ad a total, I now get the sum of each group 'Naam, Reg nr, Locatie',…
asked 2021-02-24T07:21:06.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Knuif, MBG (Martin)
41
Reputation points
answered 2021-02-24T16:30:18.743+00:00
Knuif, MBG (Martin)
41
Reputation points
4 answers
SharePoint Online-Reading/Access Lists-Using SSIS -OData Connection- Error 401 Unauthorized
Hi I am trying to connect with Lists data on Sharepoint online. I am working in SSIS -Visual Studio 2017 Odata Connector I have installed SDK-2013 as well and followed all the instruction on blogs on this topic. But I am getting error , TITLE:…
asked 2021-02-20T21:47:22.763+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU7%3C/text%3E%3C/svg%3E)
Uzi 7117
1
Reputation point
answered 2021-02-24T16:13:06.517+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 92%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Steve Rely
1
Reputation point
1 answer
SCOM SQL Server 100% CPU Utilization after MP Import
Hi everyone I imported the new SQL MPs into our old SCOM 2012 env last week. Since the night after the import, the CPU Utilization on our SCOM SQL Server is pretty much at 100% every day between 3/3:30 AM to 12 AM. After 12 it drops down to a normal…
asked 2021-02-23T11:02:08.697+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 85%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Simon Jäggi
96
Reputation points
commented 2021-02-24T16:11:23.053+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CyrAz
5,181
Reputation points
2 answers
SQL Server - Assigning values to "Always Encrypted"(=AE) textual columns fails while informing "Operand type clash"
My application shares table definitions across databases for replicating data between them thereafter. Following table definition stands for an example of a table where that "Operand type clash" fault occurs. --drop TABLE…
asked 2021-02-23T09:37:43.007+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 28.999999999999996%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHE%3C/text%3E%3C/svg%3E)
Hillel Eilat
1
Reputation point
commented 2021-02-24T11:41:30.697+00:00
Hillel Eilat
1
Reputation point
2 answers
One of the answers was accepted by the question author.
is any product competing with tabular?
Hi, i've been away from multidimensional and tabular technologies for at least a year. so i'm wondering if any ms or partnered product has begun competing with those technologies recently? i'm thinking more in the space that caters to non big data…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
HDFS modify row delimiter
Hi, for maintain the standard in my HDFS i need to modify the row delimiter. I use SSIS to get data from a DB and put in HDFS with the tool "Destination HDFS" , i need to replace the row delimiter from {CR}{LR} to {LR}. The tool…
asked 2021-02-19T16:23:02.103+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 74%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Silipigni Marco
1
Reputation point
commented 2021-02-24T10:01:43.217+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
2 answers
Database Configuration for DR SharePoint Server 2019
SharePoint 2019 Farm consists of two SharePoint Servers using Always On High Availability. Now DR Farm needs to be configured in another location. Is it possible to use another replica of Always On High availability Group ? Or Stand Alone SQL Server ?…
asked 2021-02-18T10:00:19.647+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sajith Gopalakrishnan Hema
1,226
Reputation points
commented 2021-02-24T09:30:33.807+00:00
Li Zhang_MSFT
1,566
Reputation points
5 answers
One of the answers was accepted by the question author.
Trans_Date is not coming ascending wise ?
In ledger trans_Date is not coming ascending wise ,as i am doing Back Date entries,, Create table #tbl_Account_L_Four (Level_Four_ID int,Level_Four_Name varchar(50),Opening decimal(10,2),Opening_Date date) Create table…
asked 2021-02-23T13:53:24.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Analyst_SQL
3,551
Reputation points
accepted 2021-02-24T07:54:04.767+00:00
Analyst_SQL
3,551
Reputation points
2 answers
One of the answers was accepted by the question author.
Issue to SQL server 2012
Hi, There was no change to SQL server 2012 but why did the issue below arise? TITLE: Connect to Server > Cannot connect to WIN-429I3QNHOQT\EXPR2012. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred…
asked 2021-02-22T07:16:39.973+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,586
Reputation points
accepted 2021-02-24T07:37:57.107+00:00
Peter_1985
2,586
Reputation points
1 answer
SSIS package Error - VS_Newmetadata
I have been using SSIS package to get data from SQL server Database . One of the queries being used is Select Ora_database_name as Database, to_char(SYSDATE,'YYYY-MM-HH24:MI:SS') as SCRIPT_RUN_DATE FROM Dual. Whenever there is a change in the environment…
asked 2021-02-11T21:29:53.237+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Brijesh S Patel
1
Reputation point
commented 2021-02-24T07:09:15.157+00:00
Monalv-MSFT
5,896
Reputation points
5 answers
How to obtain and download for older MSSQL CU version?
Dear All, We would like to update our Database services Cumulative Patches from "CU2" to "CU7" based on MSSQL Server 2012 SP1, but we cannot find the download link. We already went through MS KB2894115. In the section 'How to…
asked 2021-02-19T07:36:27.363+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 64%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roong C
1
Reputation point
commented 2021-02-24T07:06:48.81+00:00
CarrinWu-MSFT
6,866
Reputation points
1 answer
SQL Query help needed
Hi All, Could you help me to get the expected output using SQL Query? Table Records Product Version Status P1 QV1.1 In progress P1 QV1.2 Expired P1 QV1.3 Expired P1 QV1.4 Expired P1 QV1.5 Cancelled P2 QV2.1 - Valdiated (Inactive) …
asked 2021-02-20T04:54:51.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 6%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Srikanth Kota
1
Reputation point
commented 2021-02-24T07:06:14.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,576
Reputation points