SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,653 questions
2 answers
One of the answers was accepted by the question author.
Assign active directory security group to server role
Hi Guys, I'm trying to assign Active Directory Security Group as a member in a server role that i created. but when i'm open my Object types, i don't have groups option available, only Logins and Server roles. maybe the solution is to create login…
asked 2021-03-07T15:50:45.357+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, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bababalush
21
Reputation points
accepted 2021-03-08T07:00:45.59+00:00
bababalush
21
Reputation points
2 answers
how to multiply the first matrix by itself but transposed in SSMS 17
I have matrix. Here this create table matr1 ( x1 num, x2 num, x3 num, x4 num, x5 num, x6 num, x7 num ) insert into comm values (1,0,0,0,0,0,0,0), (1,0,5,1,2,2,8,0,0,5,0,2), (1,0,5,0,0,0,1,2,0), …
asked 2021-03-07T08:24:25.54+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(176, 9%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
warlock
101
Reputation points
answered 2021-03-08T06:45:44.643+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(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
SSAS error the source database does not exist, the source table does not exist, or because you do not have access to the data source
Hello everyone, I'm hoping someone could help me resolving this error... The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source. More Details: OLE…
asked 2021-03-03T22:01:33.613+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(192, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Christie R
1
Reputation point
commented 2021-03-08T02:50:04.78+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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
1 answer
What are the features of SQL syntax?
Why is the execution order of SQL statements inconsistent with the syntactic order of their statements,What are the features of SQL syntax?
asked 2021-03-03T00:36:58.11+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(195.2, 74%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
7fw07bd6crhb
1
Reputation point
commented 2021-03-08T02:35:41.243+00:00
Lukas Yu -MSFT
5,816
Reputation points
3 answers
SSAS: How to solve column of table cannot be processed bcz it contains more than 2B distinct records
Hello All, We are using SSAS tabular models for our power bi reports. Our models are pulling data from SQL Server and the data is increasing rapidly in billions. One of facttable, which has more than 10Billions of records, when we are trying…
asked 2021-03-02T16:32:56.757+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(265.6, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MohanV
1
Reputation point
commented 2021-03-08T02:34:15.76+00:00
Lukas Yu -MSFT
5,816
Reputation points
3 answers
Upgrading a SQL failover cluster - OS and SQL versions
Hi I need to upgrade a 2 node SQL failover cluster currently running Windows 2016 Std and SQL 2016 Std to Windows 2019 and SQL 2019 Std. I understand I can do a rolling upgrade by essentially upgrading the passive node first then failing over to it. …
asked 2021-03-03T16:01:51.733+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(57.599999999999994, 51%, 15%)' 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)
Algon
1
Reputation point
answered 2021-03-08T02:31:15.667+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
1 answer
SSAS Measure -> Retrive the selected value from Measure
Hi, I have a hierarchy HL1 HL21 HL211 HL212 HL22 HL221 Users access this cube data in Excel. They place this hierarchy in the COLUMNS section of pivot. The result should be as below in the image. ![72489-capture.png][1] [1]:…
asked 2021-02-26T16:56:02.643+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(115.19999999999999, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Savitri Biju
1
Reputation point
commented 2021-03-08T02:26:48.237+00:00
Lukas Yu -MSFT
5,816
Reputation points
1 answer
Building a project fails, why?
SQL Server Data Tools for Visual Studio 2017. A solution of mixed SSAS and SSIS. Trying to see why a build fails. Not a single error or warning in the Error List. I do a Rebuild for solution: ========== Rebuild All: 4 succeeded, 1 failed, 0 skipped…
asked 2021-02-25T04:49:46.31+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(144, 16%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Arto Kilponen
1
Reputation point
commented 2021-03-08T02:23:13.227+00:00
Lukas Yu -MSFT
5,816
Reputation points
2 answers
SSAS Tabular model access to Always Encrypted data
Using: Visual Studio Professional 2019. SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Windows 10 Enterprise 10.0 <X64> (Build 17763: ) SQL Server SQL Server Management Studio 15.0.18369.0 SQL Server Management Objects (SMO)…
asked 2021-02-23T14:35:35.407+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(89.60000000000001, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
D Guthrie
21
Reputation points
commented 2021-03-08T02:21:44.03+00:00
Lukas Yu -MSFT
5,816
Reputation points
4 answers
SQL Server 2008 Express installation fails with error (provider SSL, Provider, errors 0 - No process is on the other end of the pipe).
I ran into an installation issue with SQLServer2008 Express SP3 on a Windows 10 build 1909 computer. The installation fails with the error 'A connection was successfully established with the server, but then an error occurred during the login process.…
asked 2021-03-02T21:04:32.31+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(307.2, 10%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Paul Tom
1
Reputation point
commented 2021-03-08T02:11:57.473+00:00
CathyJi-MSFT
21,081
Reputation points Microsoft Vendor
1 answer
DBCC CHeckdb and tempdb usage
May I know if there are enough memory , will it still use tempdb for dbcc check db ? May I know the tempdb estimated to be use for dbcc checkdb is roughly the max size of the table and its index in the database ? I know there are dbcc checkdb with…
asked 2021-02-27T04:55:36.417+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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,316
Reputation points
commented 2021-03-08T01:55:50.72+00:00
CarrinWu-MSFT
6,851
Reputation points
2 answers
SQL Server Standard Edition 2019 Software Assurance
Hi, activating a Server SQL Standard 2019 licence with Software Assurance package, is there a limitation on numbers of DB that i can put in HA or DR with passive replicas ? Or i can implement the always on with the whole instance without limitation…
asked 2021-03-02T11:38:14.7+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(54.400000000000006, 0%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gabri Romi
1
Reputation point
commented 2021-03-08T01:54:39.763+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
SSRS IIF Expression Question
=IIF((Fields!Description.Value Like "*Youth") and (Fields!Value.Value = "Yes"), (Fields!Description.Value Like "*Youth")) I'm trying to attempt to look for anything in the description *Youth and the value needs to equal…
asked 2021-03-04T23:19:40.18+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(300.8, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Suguha
96
Reputation points
commented 2021-03-08T01:38:54.753+00:00
ZoeHui-MSFT
32,426
Reputation points
2 answers
One of the answers was accepted by the question author.
Powershell output file in txt file don't have all columns
I was executing this Powershell command below to get DB backup history $SQLServer = Get-Content -Path "C:\shell\cdms.txt" Invoke-DbaQuery -sqlinstance $SQLServer -File "C:\shell\sqladmin.sql"| Out-File…
![](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(198.4, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
2 answers
Agent jobs for SSIS pkgs are not running with package define login
SSIS version 2016 SP2 runs in Server A database version: 2016 runs in Server B I deployed packages and configured connection manager Service user call "SRV_CRM_report"(AD user) login in under Server A SSIS Integration Service catalogs) .…
![](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(208, 42%, 30%)' 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)
1 answer
Not all FK's updating con savechanges
Afternoon, Hope someone can help me, I have the following model: The rough code (I know its a mess) at present while I am trying to workout what is going on is as follows to add a note and link it to the changelog: public async…
asked 2021-03-07T17:36:30.957+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, 93%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Liam C. Holmes
1
Reputation point
answered 2021-03-07T20:19:07.71+00:00
Liam C. Holmes
1
Reputation point
2 answers
Error occurs when using SQL Command From Variable in SSIS OLE Db Source
I am using a SQL SERVER 2008 database and creating an SSIS package in VS 2017. Here is pseudo-code of what I am doing: Execute SQL Task - Get list of dates Foreach Loop Container - For each date Expression Task - create query in a variable Script…
asked 2021-02-26T23:17:37.93+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(288, 31%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Ryan Rigby
1
Reputation point
answered 2021-03-07T17:41:21.98+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(192, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jeffrey Williams
1,886
Reputation points
1 answer
Get data from duplicate rows in new columns
Hi I need to set up an SSIS package to import data from experiments (excel files) that are run in duplicate and triplicate this will be done on a multitude of files so it needs to be fully automated. I only need help with the data flow task not the…
asked 2021-03-02T10:49:02.91+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(108.80000000000001, 94%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Turgor
1
Reputation point
commented 2021-03-07T09:25:48.427+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,891
Reputation points
1 answer
SSISDB and master db has different collation
Is it advisable to keep SSISDB and Master database on different collation? I have my SSISDB on SQL_Latin1_General_CP1_CI_AS and Master on Latin1_General_BIN2. Shall I also get my SSISDB's collation to Latin1_General_BIN2?
asked 2021-03-02T07:05:39.657+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(131.20000000000002, 45%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rahul Pathak
1
Reputation point
commented 2021-03-07T09:24:04.54+00:00
Monalv-MSFT
5,891
Reputation points
1 answer
Reccurent SSIS SQL Task with for loop
I want to loop through date said 2000-01-01 to 2000-12-31 and i put the date as variable (said start and stop). I want to recursively call insert query which structured like this: FOR date in range (start,stop): INSERT INTO TABLE A (SELECT ...) ON…
asked 2021-03-01T07:28:39.193+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(163.2, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
yosafat saragih
21
Reputation points
commented 2021-03-07T09:22:27.247+00:00
Monalv-MSFT
5,891
Reputation points