18,252 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-26T00:17:15.28+00:00
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、执行结果成功； 疑问： 为什么修改密码后创建的自动备份执行失败？而改回初始密码就能执行成功？

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-24T08:55:48.163+00:00
存高 范 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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-28T10:17:44.43+00:00
Vasilina Balashevich 21 Reputation points
commented 2020-08-30T20:33:28.16+00:00
Erland Sommarskog 102.8K Reputation points
2 answers

How to change MS SQL services password (without locking an account out..?)

Hello ALL We have a very strange situation and I need your advice. We have AG of two servers and...somebody have missed an SQL Server service account password. Nothing critical, test envirounment. We have changed user's password in AD Users and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-25T23:23:14.197+00:00
Roman King 21 Reputation points
commented 2020-08-30T18:11:48.48+00:00
Roman King 21 Reputation points
1 answer One of the answers was accepted by the question author.

CDC for Oracle by Attunity - license/support

Hi. We need help on questions regarding CDC for Oracle by Attunity (Service/Designer) from Microsoft Do we need to get a license from Microsoft in order to use this product? (we are currently testing the product with the Service/Designer clients) …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-28T01:28:39.077+00:00
Carlos Salgar 21 Reputation points
accepted 2020-08-30T11:03:55.173+00:00
Carlos Salgar 21 Reputation points
4 answers One of the answers was accepted by the question author.

Begin tran and row lock

Hi, I'm using begin tran in my code and with this command - I update a row, it locks the whole table, but i want to lock only the updated rows. any idea?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-18T07:29:38.557+00:00
Kodeeswaran Duraisamy 161 Reputation points
commented 2020-08-30T10:50:55.743+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points
11 answers

Parallelism when execution cost lower than Cost of parallelism

why is that.? my cost of parallelism is default 5

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-19T08:37:11.897+00:00
sakuraime 2,321 Reputation points
commented 2020-08-30T10:39:34.51+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points
2 answers

Trancate table and LOB data

where there are still LOB allocation unit after the table is truncated ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-28T02:54:57.383+00:00
sakuraime 2,321 Reputation points
commented 2020-08-30T10:36:41.977+00:00
tibor_karaszi@hotmail.com 4,306 Reputation points
2 answers One of the answers was accepted by the question author.

How to upgrade SQL 2017 Evaluation to Developer

How do I upgrade SQL 2017 Evaluation to Developer? I have installed SQL 2017 evaluation edition and been using it for 188 days while I waited for approval to purchase the developer edition. There is not a SQL product key available to insert.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-28T20:26:56.627+00:00
kescott 21 Reputation points
answered 2020-08-29T15:47:35.043+00:00
kescott 21 Reputation points
2 answers One of the answers was accepted by the question author.

Rebuild index on a 5TB database

We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild index on first chunk, then on the next chunk and so on. Please let me know

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-27T00:56:02.557+00:00
Chaitanya Kiran 101 Reputation points
accepted 2020-08-29T09:44:48.577+00:00
Chaitanya Kiran 101 Reputation points
2 answers

sys.dm_tran_version_store how to check which row from the table

How to check sys.dm_tran_version_store how to check which row from the table the records are originate from which row from the original table ? and from which transaction ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-26T03:19:05.527+00:00
sakuraime 2,321 Reputation points
commented 2020-08-29T06:37:21.53+00:00
sakuraime 2,321 Reputation points
3 answers One of the answers was accepted by the question author.

Containment (Simple) vs Containment (base):

Containment (Simple) vs Containment (base): Containment (Simple): Users query for data that exists. For example, for an equality join between two tables, factor in the predicates selectivity1 in each input histogram, before joining histograms to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-26T07:49:22.277+00:00
sakuraime 2,321 Reputation points
answered 2020-08-28T17:19:37.053+00:00
sakuraime 2,321 Reputation points
2 answers One of the answers was accepted by the question author.

Online rebuild index ABORT_AFTER_WAIT = NONE

ALTER INDEX clidx ON parttable REBUILD WITH (ONLINE=ON (WAIT_AT_LOW_PRIORITY ( MAX_DURATION = 5 minutes ,ABORT_AFTER_WAIT = NONE))) So in this case, the rebuild index will wait for another 5 minutes, if it was first blocked already by…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-27T10:07:41.16+00:00
sakuraime 2,321 Reputation points
accepted 2020-08-28T16:42:15.727+00:00
sakuraime 2,321 Reputation points
2 answers One of the answers was accepted by the question author.

Select between GDR and CU

I have Sql server 2014 in always-on , When i did Microsoft security upgrade primary shows as (SP2-CU18) and secondary shows as (SP2-GDR). Why there is a difference as primary is CU and secondary GDR.? historically primary was upgrading only CU and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-27T20:44:45.89+00:00
DBA 21 Reputation points
accepted 2020-08-28T12:59:54.37+00:00
DBA 21 Reputation points
10 answers One of the answers was accepted by the question author.

Improve the execution time for a complex SQL Query from 25 seconds to be under 1 second in SQL Server Enterprise 2019

How can I improve the execution time for a query where the initial Rows in the view were: 16000 and the query worked resonable ( under 1 second ), but now there are : 42487 rows in the View and the execution time is over 25 seconds ... which is not…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,570 questions
asked 2020-08-24T15:44:09.817+00:00
Lucian Parvu 21 Reputation points
accepted 2020-08-28T11:22:09.907+00:00
Lucian Parvu 21 Reputation points
5 answers

pkg goes down because a connection cant be found

hi we run 2014 standard and develop in vs 2013. i deployed a pkg that has no connector called xxxxxxxx.yyyyyyyyyyy but i get the error the connction xxxxxxxx.yyyyyyyyyyy is not found...oxc001000e...this error is thrown by connections collection when…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,477 questions
asked 2020-08-26T22:22:34.637+00:00
db042190 1,516 Reputation points
commented 2020-08-28T09:46:43.12+00:00
Monalv-MSFT 5,896 Reputation points
4 answers One of the answers was accepted by the question author.

SCCM 2019 - Installation of WSUS - SQL

Dear all, I am trying to install SCCM as we aquired the licences. Now what I am trying to do is to install the WSUS role in the "SCCM Server". I can successfully connect to the sqlserver\sccm (the instance) but then when I launch…

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
211 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,365 questions
asked 2020-08-26T16:05:33.823+00:00
Lucas Vorms 251 Reputation points
answered 2020-08-28T09:09:37.467+00:00
Lucas Vorms 251 Reputation points
1 answer

SQLExpress 2017 upgrade to SQLExpress 2019 fails with message "Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available"

20573-summary.txtI am trying to upgrade my SQLExpress 2017 to SQLExpress 2019. It failed due to Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: More data is available. It looks like failed to open, create and copy registry between…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
asked 2020-08-25T16:51:08.59+00:00
Kevin Wang 1 Reputation point
commented 2020-08-28T09:09:25.077+00:00
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
2 answers

Criar um cursor que atualiza um campo char na tabela ESCOLA

Olá, estou tentando criar um CURSOR para fins didáticos que atualiza um campo Char na minha tabela ESCOLA conforme a quantidade de níveis de ensino na tabela ESCOLA_NIVELENSINO. Qualquer ajuda é bem vinda pois a ideia é eu fixar bem o conhecimento,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,570 questions
asked 2020-08-25T12:04:49.62+00:00
jonathas moura 21 Reputation points
commented 2020-08-28T07:53:54.05+00:00
EchoLiu-MSFT 14,576 Reputation points
1 answer

SQL Server Backup Encryption Details

Hello, The Backup Encryption page mentions AES 256 can be used for encrypting backups. However, it does not go into IV generation, Cipher block mode, or Authentication of backups.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,987 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,570 questions
asked 2020-08-25T17:16:34.307+00:00
justin 1 Reputation point
commented 2020-08-28T07:38:16.317+00:00
CathyJi-MSFT 21,101 Reputation points Microsoft Vendor