SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,985 questions
3 answers
Querying SQL Server 2012 Training Kit
Apologies in advance, this is very new to me. My boss wants me to start learning SQL queries to assist with reports at work, and the company uses SQL Server 2012. I've been given the Querying Microsoft SQL Server 2012 Training Kit book (textbook and…
asked 2020-08-27T12:18:13.17+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(134.4, 69%, 23%)' 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)
AmyKernow
1
Reputation point
commented 2020-08-31T09:03:40.997+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
4 answers
One of the answers was accepted by the question author.
Move on-prem SQL server VM to azure SQL VM
I am moving a clients servers to azure. We have been using ASR for past migration and plan to do the same. We dont have SA on SQL server licensing. The issue is when you move all the servers with ASR i do not see an option to make the migrated server…
asked 2020-08-26T21:22:26.727+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(60.8, 23%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Brice Milla
31
Reputation points
commented 2020-08-31T08:56:24.05+00:00
Ronen Ariely
15,096
Reputation points
2 answers
sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE
for full mode database, I did some transaction , and then backup the transaction log . and then I will see sys.dm_db_log_stats :log_truncate_holdup_reason : OLDEST_PAGE there is some definition on the following but I am still a bit confused of this…
asked 2020-08-24T11:01:20.317+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,321
Reputation points
commented 2020-08-31T07:40:17.047+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
3 answers
Move data file to another drive in AG
What are the steps to move data file to another drive in AG with minimal downtime
asked 2020-08-29T11:59:20.153+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(128, 32%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
101
Reputation points
answered 2020-08-31T07:37:55.803+00:00
m
4,271
Reputation points
2 answers
SQL AG restoring the tlog stuck
Hello I have 2 SQL servers, both are: Microsoft SQL Server 2014 (SP3-CU4) (KB4500181) - 12.0.6329.1 (X64) Jul 20 2019 21:42:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) …
asked 2020-08-29T21:23:32.013+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, 48%, 38%)' 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)
Steven Balderrama
21
Reputation points
answered 2020-08-31T07:35:28.91+00:00
Shashank Singh
6,246
Reputation points
2 answers
Reporting URL not working
All, Reporting URL is not working. How to troubleshoot the issue. However http://localhost/Reports is working, and 'http://Servername/Reports' is not working. Please assist to troubleshoot the issue.
asked 2020-08-24T12:49:20.033+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, 17%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vinay Kumar Gandla
1
Reputation point
commented 2020-08-31T06:21:20.943+00:00
ZoeHui-MSFT
34,106
Reputation points
1 answer
SSRS report when run manually in Reporting Services never finishes. Same report when run via a report subscription runs in less than a minute.
I created a report subscription for a SSRS report and it runs and is delivered within one minute. The same report when run manually in Reporting Services never finishes. The report simply calls a stored procedure which selects from a SQL view. …
asked 2020-08-29T14:23:28.77+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(147.20000000000002, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tom Stone
521
Reputation points
answered 2020-08-31T06:19:21.87+00:00
ZoeHui-MSFT
34,106
Reputation points
1 answer
SSRS report in Visual Studio takes 2 minutes to run, the deployed report when run from Reporting Services takes forever. Why?
I have a report that runs in 2 minutes in Visual Studio connected to the production database (16k rows, 50 columns), but it takes more than 16 minutes when run by Reporting Services in production after deployment (I have to cancel each time). Both…
asked 2020-08-27T17:11:38.327+00:00
Tom Stone
521
Reputation points
commented 2020-08-31T05:48:11.037+00:00
ZoeHui-MSFT
34,106
Reputation points
2 answers
How to decide SQL server 2017 License ? What is user means ? If I use only sa user from application user access then shall I need to purchase that SQL user license ?
How to decide SQL server 2017 License ? What is user means ? If I use only sa user from application user access then shall I need to purchase that SQL user license ?
asked 2020-08-29T13:03:57.127+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, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Goutam Kumar Das
1
Reputation point
answered 2020-08-31T05:45:22.817+00:00
m
4,271
Reputation points
3 answers
How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
How to upgrade SQL Server 2012 to SQL Server 2017, shall I need to purchase 2017 License.
asked 2020-08-29T13:01:15.377+00:00
Goutam Kumar Das
1
Reputation point
answered 2020-08-31T05:18:28.68+00:00
m
4,271
Reputation points
1 answer
How to show #ERROR as Zero or as Nothing in matrix cell when groups and calculated field are based on switch-function in SSRS?
Imagine simple BI task: We have two grouping columns and one calculated field. like select group1, group2, sum(sales) Sum_of_sales from dbo.table1 group by group1, group2 When for some combination of grouping columns there's no ROW in dataset -…
asked 2020-08-28T17:31:47.12+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, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPI%3C/text%3E%3C/svg%3E)
Petr Ilin
1
Reputation point
answered 2020-08-31T04:10:49.113+00:00
ZoeHui-MSFT
34,106
Reputation points
1 answer
Exclude empty rows in Report
I have a table in an RDL file. Empty rows create due to the (Finish) field contains in sql query, (Finish) field not used in the main report. Field (Finish) is used as a parameter to go to the subreport, I cannot delete it. How to exclude…
asked 2020-08-29T14:27:28.963+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(211.20000000000002, 20%, 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)
Илья Листратенко
21
Reputation points
answered 2020-08-31T03:08:14.347+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
Is there a stored procedure in SQL server that allows you do perform clustering/kmeans clustering?
My boss is giving me a bunch of data to analyze by using clustering/kmeans methods. Is there a stored procedure in SQL server that allows me to do that?? Thanks
asked 2020-08-24T18:22:42.983+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(105.60000000000001, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
Tianqi Luo
1
Reputation point
commented 2020-08-31T02:38:29.297+00:00
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
which licence MS SQL for a 4 core machine?
Dear, We are a Microsoft ISV partner who deliver a software for the construction industry (.NET solution). In order to ship our solution we use Microsoft SQL Calls which we can buy under out ISV contract at Ingram Micro (see below); However now we…
asked 2020-08-27T15:22:09.52+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(188.79999999999998, 35%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIV%3C/text%3E%3C/svg%3E)
Ines Van Roie
1
Reputation point
commented 2020-08-31T01:40:06.24+00:00
CathyJi-MSFT
21,101
Reputation points Microsoft Vendor
1 answer
Azure guest user authentications issues - Excel and PowerBI asking for authentications all the time
Hello, I have an Analysis Service instance running on Azure. Based on this AAS, my users are invited as guest users in my AD tenant. And they are allowed to read the data in AAS through Excel or PowerBI. They have accepted the invitations and created…
asked 2020-08-25T15:35:56.437+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, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
ZDUAN
1
Reputation point
commented 2020-08-31T01:24:34+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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
3 answers
Rebuilding indexes on 5TB database
We have a 5TB database. Rebuild index job is taking days to complete. Is there any way to rebuild chunk of indexes?
asked 2020-08-25T18:58:25.03+00:00
Chaitanya Kiran
101
Reputation points
commented 2020-08-31T01:23:07.85+00:00
Cris Zhan-MSFT
6,611
Reputation points
1 answer
Sql server 2019
Wanted to migrate SQL 2012 databse of size 60 gb to SQL server 2019 Wanted to know what is the memory required for 60gb database .db server is standalone. As there are more than 20000 users will acces the application daily basis. Db Server is on…
asked 2020-08-27T19:16:48.993+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(211.20000000000002, 14.000000000000002%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ravi Shah
1
Reputation point
commented 2020-08-31T01:12:38.083+00:00
Cris Zhan-MSFT
6,611
Reputation points
1 answer
Users that have run a specific metered software program report is blank
Hello This issue is for the Microsoft Endpoint Configuration Manager Software Metering Report Microsoft Endpoint Configuration Manager Version: 1910 Details: I find myself in a unique situation where this software metering report is…
asked 2020-08-26T00:17:15.28+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(201.6, 8%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Giovanny Jimenez
1
Reputation point
commented 2020-08-31T01:11:21.06+00:00
Cris Zhan-MSFT
6,611
Reputation points
2 answers
sql server 2016自动备份失败问题
操作步骤： 1、创建用户a，初始密码b； 2、修改密码为c； 3、重新登录用户a，密码c成功； 4、创建自动备份维护计划成功； 5、右键维护计划-执行； 6、执行结果失败：用户名与密码不匹配，账户被锁定； 7、修改用户属性，密码改成初始密码b，并登录验证成功； 8、重新创建自动备份维护计划成功； 9、右键维护计划-执行； 10、执行结果成功； 疑问： 为什么修改密码后创建的自动备份执行失败？而改回初始密码就能执行成功？
asked 2020-08-24T08:55:48.163+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(96, 35%, 19%)' 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
Reputation point
commented 2020-08-31T01:09:25.29+00:00
Cris Zhan-MSFT
6,611
Reputation points
3 answers
One of the answers was accepted by the question author.
What SUBSTR() or IN is faster in Oracle?
Would WHERE SUBSTR(my_field,1,6) = 'search' or WHERE my_field IN ('a','b','c','d','f') be faster in Oracle, or would there be no difference? I cannot create temp tables and haven't got the execution plan. Thank you in advance!
asked 2020-08-28T10:17:44.43+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(19.2, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vasilina Balashevich
21
Reputation points
commented 2020-08-30T20:33:28.16+00:00
Erland Sommarskog
102.7K
Reputation points