SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
Content
2 answers
One of the answers was accepted by the question author.
MS SQL 2019 Developer Edition Download Link
Hi, I'm trying to find link for MS SQL 2019 Developer Edition. But all links lead to https://www.microsoft.com/en-us/sql-server/sql-server-downloads where SQL 2022 is. Where can I find link to download SQL 2019 Dev?
asked 2023-02-07T16:31:34.9033333+00:00
Pavel.Dyachuk
136
Reputation points
accepted 2023-02-08T09:12:04.2166667+00:00
Pavel.Dyachuk
136
Reputation points
7 answers
One of the answers was accepted by the question author.
indexes in view
Hi Expert, How to create indexes in view as it is taking more than hour to run alter view view1 as select col1,col2,col3... from table1... total 35 columns
asked 2023-02-02T16:38:54.7266667+00:00
Shambhu Rai
726
Reputation points
accepted 2023-02-08T07:43:55.8+00:00
Shambhu Rai
726
Reputation points
3 answers
One of the answers was accepted by the question author.
index not exists
After removing the indexes from the table, using the sys.indexes query, the removed indexes are still displayed. Although the deleted indexes do not exist in the table index folder. If this query is Join with sys.partitions, we will have the output of…
asked 2023-02-06T16:23:10.3333333+00:00
MohammadAmin Moazami
0
Reputation points
accepted 2023-02-08T05:29:47.9033333+00:00
MohammadAmin Moazami
0
Reputation points
3 answers
One of the answers was accepted by the question author.
[SSRS] How to get detail error message by table :ExecutionLogStorage
I execute SQL without error message detail , only Status rsProcessingAborted : SELECT B.Path ,a.* FROM [ReportServer].[dbo].[ExecutionLogStorage] A,[ReportServer].[dbo].[Catalog] B WHERE A.REPORTID=B.ItemID AND B.Path ='Reportpath' ORDER BY…
asked 2023-02-07T09:30:23.36+00:00
ShaoYu Hung(洪紹渝)
20
Reputation points
answered 2023-02-08T03:01:56.4466667+00:00
ShaoYu Hung(洪紹渝)
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Can an INSERT statement block SELECT ?
Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can anyone help me understand in what scenarios it may happen? Thanks, Sam
asked 2023-02-05T12:05:08.78+00:00
Samantha r
406
Reputation points
commented 2023-02-07T22:41:53.9533333+00:00
Erland Sommarskog
68,536
Reputation points MVP
4 answers
One of the answers was accepted by the question author.
can replication be limited to just some tables in the db?
hi , can replication be limited to just some tables on the db or must it be on the entire source db? and if the source has timestamps, will there be any problem for sql to keep them as is on the target/replicated db?
2 answers
One of the answers was accepted by the question author.
Change Tracking - Multiple xdes_id in table [sys].[dm_tran_commit_table] for the same commit_ts
Change Tracking is activated on a Microsoft SQL Server 2012 To get the Commit Date of the changes we LEFT JOIN on table [sys].[dm_tran_commit_table] FROM CHANGETABLE(CHANGES [Grf].[ChangementStatut], 55169) ct LEFT OUTER JOIN…
asked 2023-01-31T13:09:44.29+00:00
Steve Toutant
1
Reputation point
commented 2023-02-07T13:54:02.9466667+00:00
Steve Toutant
1
Reputation point
1 answer
One of the answers was accepted by the question author.
database reference for Linked Server Object
Hi all, I imported a SQL Server 2016 database into a VS 2022 SQL Server Project and the import finished without exceptions. When I tried to build the project, though I got a whole bunch of warnings about non existent referenced objects and that is…
asked 2023-02-03T13:32:39.6266667+00:00
VASILIANU Vlad -C I O
20
Reputation points
accepted 2023-02-07T12:26:11.4666667+00:00
VASILIANU Vlad -C I O
20
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server (SSMS) not listing all of the network servers
Using SSMS on the network server (which contains the network server DB) and laptop workstations, when executing SSMS on the network server, it only lists itself when selecting "Browse for more on the "Server Name" pull-down menu. However,…
asked 2023-02-04T01:57:36.94+00:00
Giacomo Raucci
81
Reputation points
answered 2023-02-07T11:18:55.79+00:00
Giacomo Raucci
81
Reputation points
9 answers
One of the answers was accepted by the question author.
join 3 views in one view
Hi Expert, i wanted to join three views in one using temp table i.e. Create view test1 as select col1,col2 into #temp1 from view1 select col1,col2 into #temp2 from view2 select col1,col2 into #temp3 from view3 select col1,col2 from #temp1 a join #temp2 b…
asked 2023-02-03T04:01:38.42+00:00
Shambhu Rai
726
Reputation points
accepted 2023-02-07T07:08:50.6033333+00:00
Shambhu Rai
726
Reputation points
1 answer
One of the answers was accepted by the question author.
Maintenance on Mirroring witness server
Hi I have couple of automatic failover mirroring setups and a single host which acts as a witness for all the mirroring set up I have. Now I am planning a maintenance window on my witness server. I want to study the impact on my mirroring setup when my…
2 answers
One of the answers was accepted by the question author.
Entity Framework Core can't create migrations table using created login
I am doing a some training with .Net 6.0, C# and Entity Framework Core. I got to the point that EF can generate a new migration but hen I run dotnet ef database update I am getting an error: Failed executing DbCommand (38ms) [Parameters=[],…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,591 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,028 questions
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
429 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
643 questions
2 answers
One of the answers was accepted by the question author.
WITH common_table_expression
Dear All, I'm using SQL server 2016. On the page Microsoft Documentation, I see the following code. However, I don't understand the meaning of the paragraph under the heading CTE_query_definition. Could anybody tell me the meaning of this paragraph? […
asked 2023-02-02T03:34:57.56+00:00
Anonymous
accepted 2023-02-06T08:41:44.3166667+00:00
Anonymous
3 answers
One of the answers was accepted by the question author.
blocking behaviour using hints
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried to check with application team, they said they are using with (ROWLOCK) hint in most cases. So, I tried to repro but not able to reproduce the issue of SELECT with…
asked 2023-02-01T19:42:31.68+00:00
Samantha r
406
Reputation points
commented 2023-02-05T06:10:32.8766667+00:00
Samantha r
406
Reputation points
4 answers
One of the answers was accepted by the question author.
How to move SQL server database to another drive
Hi How to move SQL server database to another drive? I tried before by making offline, move physical database file and make online again but it failed, please help
2 answers
One of the answers was accepted by the question author.
Help in Formatting without mentioning column name in SQL
Hi, How I can get the following desired result without mentioning column's name in the query. Select * from country CCode CName CPost CDest CSET CPOS CJOH 001 AU L1 RE 1 2 …
2 answers
One of the answers was accepted by the question author.
TSQL Convert Binary64 text to an image so it can displayed in reports
We have some code, as follows which we are trying to convert Base64 string to an image so that it can be displayed in reports. However, in SSRS, we get the following error message when trying to display the image: What needs to be changed in this…
2 answers
One of the answers was accepted by the question author.
Can Microsoft SQL Server 2019(RTM) be restored on 2016 SQL Server?
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) Using management studio to…
1 answer
One of the answers was accepted by the question author.
SSIS package Error: Cannot create a task from XML for task "Script Task", type "Microsoft.ScriptTask" due to error 0x80070057 "The parameter is incorrect.".
Hi, I get error while running DTExec.exe in cmd which executes SSIS package. The SSIS package job runs well when I run in VS 2019 manually, but throws error from cmd. command I have executed in cmd: "C:\Program Files\Microsoft SQL…
asked 2022-10-28T02:58:48.42+00:00
TC
41
Reputation points
commented 2023-02-03T16:35:21.3366667+00:00
Rajanand Ilangovan
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Unable to access unc shared folder remotely using pull subscription of snapshot replication
What could be the possible causes for a pull subscription of snapshot replication unable to access the unc shared folder remotely but a pull subscription is able to access the unc shared folder and replicate successfully? Where do I troubleshoot at…