17,950 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
5 answers

Linked Server. Dont show ip or dynamic dns

Hello, I want to make a link between two sql servers 2019. My server is a local machine, the other server is a virtual machine in cloud. I can connect the virtual to the local very easily but the ip shows up. Can i make the link and have my own…

SQL Server on Azure Virtual Machines
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
462 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,731 questions
asked 2020-08-23T08:24:12.737+00:00
Giorgos 21 Reputation points
answered 2020-08-28T01:33:17.58+00:00
m 4,271 Reputation points
4 answers

Hyper-V 2019 SQL 2016 Std on Windows 2012R2 slowdowns

Hello, Environment: Hyper-V 2019 256GB RAM, SQL 2016 fixed memory not dynamic 128GB on Server 2012R2. Only 2 VM's on the host, 10Gb nics (Broadcom), FC storage.CSV's. After several days, 4-5 SQL slows-down to a crawl, queries and writes. SQL 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,731 questions
asked 2020-08-22T05:44:49.097+00:00
Colin Marshall 1 Reputation point
answered 2020-08-28T01:32:50.747+00:00
m 4,271 Reputation points
5 answers

Unable to import Sybase ASE native data file using bcp

Hi, I have a requirement to import native BCP file from Sybase ASE to SQL Server. Can anyone please advise on this? Thanks.

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,731 questions
asked 2020-08-21T15:09:39.523+00:00
ssalun 26 Reputation points
answered 2020-08-28T01:32:01.563+00:00
m 4,271 Reputation points
6 answers

Arquivos MDF

Bom dia, tenho um banco de dados sendo o arquivo com 800Gb, e o disco onde ele está armazenado está praticamente cheio. Gostaria de saber qual é a melhor pratica para isso. Criar um novo drive, criar um novo MDF com autogrow e o arquivo atual…

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,731 questions
asked 2020-08-21T11:46:46.687+00:00
Alexander Benatti 21 Reputation points
answered 2020-08-28T01:31:35.553+00:00
m 4,271 Reputation points
1 answer One of the answers was accepted by the question author.

Query takes long time to run

SQL Server: 2014 Problem: I am running a query that joins 3 views and produces results. Query takes over 8 minutes to run, but it runs without an error and produces correct output. Can you please take a look at my query and tell me why it takes 8…

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,731 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2020-08-27T14:38:34.403+00:00
SQLIsGood-7036 176 Reputation points
accepted 2020-08-27T17:55:56.03+00:00
SQLIsGood-7036 176 Reputation points
1 answer One of the answers was accepted by the question author.

Is there a way to auto-create all of the columns in a tablix?

Is there a way to auto-create all of the columns in a tablix? I have a SQL view with 100+ columns that the user wants to see in a spreadsheet created from an SSRS report and I do not want to manually create each column for the tablix.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 questions
asked 2020-08-26T17:51:16.39+00:00
Tom Stone 521 Reputation points
accepted 2020-08-27T14:28:31.44+00:00
Tom Stone 521 Reputation points
1 answer One of the answers was accepted by the question author.

Just show last date with Report Builder 3.0 custom report

Is there anyway to just show the last date something was added within the report builder as in reports I am getting multiple results when I just want the date of the last one added.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 questions
asked 2020-08-25T16:29:49.727+00:00
Adrian Hall 21 Reputation points
commented 2020-08-27T14:22:27.203+00:00
Adrian Hall 21 Reputation points
4 answers

Backup and Restore Database - Affect on Full Text Indexes

We are planning to move a database from SQL Server 2008 R2 to a SQL Server 2016 instance. This database has a few Full Text Catalogs, with all the indexes part of the PRIMARY file group. When we perform a Full backup and restore on this database, will…

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,731 questions
asked 2020-08-25T22:34:52.483+00:00
Mark Sanchez 61 Reputation points
answered 2020-08-27T13:02:46.017+00:00
Stratos Matzouranis 36 Reputation points
2 answers

Create SQL functions with parameters

Hello, I have a lot of sql scripts which use functions like "string_agg" and "concat_ws". those funcations are available from sql 2017. now I would like to create some backward compatibility for MSSQL 2016 and earlier. I tried if I…

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,731 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2020-08-26T12:11:26.737+00:00
Bart K 1 Reputation point
commented 2020-08-27T10:37:27.927+00:00
Viorel 112.2K Reputation points
3 answers

SQL CLR Types does not show up in Registry Editor

The administrator has installed and uninstalled the SQL CLR Types on a coworker's machine multiple times and when we search for it in the Registry Editor it isn't there. We keep wasting IT's time, and I figure I should ask the forum before asking again.…

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,731 questions
asked 2020-08-24T23:21:09.17+00:00
Brian Green 1 Reputation point
answered 2020-08-27T09:36:52.423+00:00
m 4,271 Reputation points
4 answers

SQL Server 2008 R2 Support extension

Hello, Our organization is using SQL Server 2008 R2. We do not wish to upgrade it to latest version due to cost implications and dependency on the associated application version. I read that extended support ended for SQL Server 2008 R2 ended in July…

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,731 questions
asked 2020-08-24T13:54:56.753+00:00
Shashank PS 1 Reputation point
answered 2020-08-27T09:36:33.34+00:00
m 4,271 Reputation points
5 answers

Table in sql server 2017 takes alot of time to update/insert few rows

Hello I have a table in sql server 2017 that has around half million records and it is constantly used via website. Select statement are very fast over it or over its views,but update/insert of 1 or 2 rows takes a lot of time sometimes 1 row needs 15…

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,731 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2020-08-24T06:59:59.057+00:00
mahag 1 Reputation point
answered 2020-08-27T09:36:13.22+00:00
m 4,271 Reputation points
6 answers

Getting an Intermitent issue with Linked Server between 2 On-premise SQL Servers

Hi All, Every now and then I am getting this issue and not sure where to look into it..? _Master_ODS:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source:…

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,731 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
asked 2020-08-24T03:22:38.75+00:00
Shivendoo Kumar 736 Reputation points
answered 2020-08-27T09:35:47.087+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

Error during the registration of a CLR assembly in SQL Server 2017 which references other assembly

I got the following error when I try to deploy my DLL which references other ThirdPartyDLL. Msg 10300, Level 16, State 2, Line 4 Assembly 'MYDLL' references assembly 'ThirdPartyDLL, version=300.1.0.1, culture=neutral,…

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,731 questions
asked 2020-08-26T15:05:18.123+00:00
Shamszadeh, Imran 26 Reputation points
commented 2020-08-27T09:26:55.29+00:00
m 4,271 Reputation points
2 answers One of the answers was accepted by the question author.

File System Error - Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the cube-user database cryptography key.

SSAS DB Synchronization job is scheduled to synch using a XMLA script via SSIS. This synch the SSAS DB 'ESSJMT' from process server ( Source ) to Query Server(Destination). When it failed , server logged below error. And when I tried to run profiler…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
asked 2020-08-16T10:36:17.99+00:00
Komal Sahu 311 Reputation points
accepted 2020-08-27T07:55:21.713+00:00
Komal Sahu 311 Reputation points
3 answers

Extended Events to trace Foreign Keys becoming untrusted

I am trying to find out what is continually setting the Foreign Keys and Constraints to untrusted. I've setup an Extended Events session to trap Alter Table events but it's not catching it. How can I trap this using Extended Events? WHERE…

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,731 questions
asked 2020-08-21T15:28:25.193+00:00
Iain Barnetson 106 Reputation points
answered 2020-08-27T07:28:46.713+00:00
Cris Zhan-MSFT 6,606 Reputation points
4 answers One of the answers was accepted by the question author.

AlwaysOn reads on readonly replica and latency

Hi all, On an sqlserver2016 alwayson replica in asynchronous mode with readonly activated, If I have a long query (several minutes) selecting datas, are the logs still applied or is it waiting the end of the query to apply the new logs and keep data…

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,731 questions
asked 2020-08-26T15:50:09.793+00:00
begin 26 Reputation points
answered 2020-08-27T07:21:23.85+00:00
begin 26 Reputation points
3 answers One of the answers was accepted by the question author.

Can't see table relationship while create ER diagram for SQL database

Hi There, I'm trying to generate ER diagram for one the SQL database. When selecting tables, I can see only tables but can't see table relationship. Please help me. Regards, Ken

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,731 questions
asked 2020-08-21T05:03:50.24+00:00
Ken 21 Reputation points
answered 2020-08-27T06:09:00.983+00:00
Ken 21 Reputation points
2 answers

Find what I am looking for

This was my query page url: https://learn.microsoft.com/en-us/search/?terms=sp_enumerrorlogs I got: "8,300 results for 'sp_enumerrorlogs'" I searched 5 or 6 pages without encountering "sp_enumerrorlogs" in the article…

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,731 questions
asked 2020-08-26T15:43:49.37+00:00
David Rogers 1 Reputation point
answered 2020-08-27T06:07:07.843+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

VB.NET ReportingService2005 QueryDefinition.CommandText

I would like to know if there is a good example of ReportingService2005 QueryDefinition.CommandText using vb.net. My goal is to retrieve / get the SQL within the rdl report. I found this Link but no examples how to use it. any suggestions 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,731 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,801 questions
asked 2020-08-25T14:44:15.323+00:00
jim brown 271 Reputation points
answered 2020-08-27T03:11:21.2+00:00
ZoeHui-MSFT 33,051 Reputation points