6,859 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
5 answers One of the answers was accepted by the question author.

Test if any SQL Server related questions already exist

I checked all 4 forums under SQL Server and I see 0 posts. However, I think I saw a thread somehow where I saw Uri has an answer. How come I don't see any questions in relation to SQL Server?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-04T03:35:39.533+00:00
Naomi 7,366 Reputation points
commented 2020-08-22T01:16:44.963+00:00
Ronen Ariely 15,101 Reputation points
5 answers One of the answers was accepted by the question author.

SQL Server Reporting Services -- Deploying report fails -- The operation has timed out

HI All, I am getting an error today that I have not received before. When using Visual Studio to deploy a report to my SSRS 2017 Report Server, I am getting the error "The operation has timed out." I am using SSDT and Visual Studio…

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,860 questions
asked 2020-08-18T18:44:10.42+00:00
DJAdan 671 Reputation points
accepted 2020-08-21T20:34:19.677+00:00
DJAdan 671 Reputation points
1 answer One of the answers was accepted by the question author.

SSRS - STORED PROCEUDURE WITH TABLE VALUED PARAMETERS

Hi, How can we use Stored Procedure with Table Valued Parameter in SSRS Dataset ? CREATE TYPE DBO.MultiFilter AS TABLE ( filterVal VARCHAR(200) ) CREATE PROCEDURE DBO.USP_multiFilterTest @position DBO.MultiFilter READONLY …

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,860 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
asked 2020-08-19T09:59:25.577+00:00
Srinivasa Rao Chigulla 46 Reputation points
commented 2020-08-21T18:29:45.693+00:00
Allen M 11 Reputation points
1 answer One of the answers was accepted by the question author.

Lookup do not bring amount

Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one value from the datasource therefore I am out balance. The money is sitting there but my lookup is not bringing both…

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,860 questions
asked 2020-08-20T18:02:40.463+00:00
Ysa8989 41 Reputation points
commented 2020-08-21T17:45:33.763+00:00
Ysa8989 41 Reputation points
3 answers One of the answers was accepted by the question author.

Description=[Microsoft][ODBC SQL Server Driver] [SQL Server] Invalid object name 'databaseproperty'

Hello, A good friend of mine runs a tech support business from his home and is in the hospital for an unforeseeable amount of time. I've run a disk repair for his son but whatsup isn't loading properly (i kept poking at it and admit every time I fix…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-21T03:37:15.87+00:00
Boe Dillard 666 Reputation points
accepted 2020-08-21T16:50:54.78+00:00
Boe Dillard 666 Reputation points
2 answers One of the answers was accepted by the question author.

Managing MDF Files

I have a database MDF file with 800Gb, and the disk is almost full. I'd like to get the best practice to grow create new files to my database. So, I have some options to do this: Create a new drive, create a new MDF file with autogrowth, 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.
13,268 questions
asked 2020-08-21T12:18:32.277+00:00
Alexander Benatti 21 Reputation points
accepted 2020-08-21T16:29:06.52+00:00
Alexander Benatti 21 Reputation points
1 answer One of the answers was accepted by the question author.

Choice of Join hash join

I believe sql server optimizer will choose loop join if one of the input table will be relatively small . like few rows. but in the following example show that it use hash join and using the smaller table as to build hash column in memory . so the query…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-19T06:46:47.407+00:00
sakuraime 2,321 Reputation points
commented 2020-08-21T09:58:03.093+00:00
sakuraime 2,321 Reputation points
5 answers One of the answers was accepted by the question author.

Enquiry about Queries for SRSS

Hello everyone, I write my problem here because I tried everything that I could, and I don't find a way to make what I want. I need to make a report, for this, I'm using Microsoft SQL Server Report Builder to prepare Tables and Queries. Here…

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,860 questions
asked 2020-08-19T14:50:34.277+00:00
fabien prieur 41 Reputation points
commented 2020-08-21T05:15:26.003+00:00
fabien prieur 41 Reputation points
4 answers One of the answers was accepted by the question author.

Backup & restore of SQL DB from one location to another - how do I get the versions of the SQL DB to be the same?

Hello, We want to restore a SQL DB from one SQL server to another from a backup. I want to be clear I don't know much about SQL - I usually install them and someone else does any programming needed. I can't even run a query unless someone walks me…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-20T05:06:08.347+00:00
Jim Millerick 21 Reputation points
answered 2020-08-21T03:12:55.797+00:00
Jim Millerick 21 Reputation points
2 answers One of the answers was accepted by the question author.

Aged Data Not Removed in SQL Server Temporal History Table

ENVIRONMENT: SQL Server 2017 Enterprise running on Windows Server 2016 Standard Test Case: Create 2 identical temporal tables (differ only by name) where 1 table has HISTORY_RETENTION_PERRIOD set to 1 day. The other table is set 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.
13,268 questions
asked 2020-08-17T19:18:34.237+00:00
Ed Woo 21 Reputation points
accepted 2020-08-19T21:29:40.58+00:00
Ed Woo 21 Reputation points
2 answers One of the answers was accepted by the question author.

Always_Health

Hi, Is it necessary to always trun on AlwaysOn_Health event session in SQL Server 2016. If yes, does it impact on server performance? 18501-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-18T19:37:11.523+00:00
Vijay Kumar 2,031 Reputation points
accepted 2020-08-19T18:03:18.23+00:00
Vijay Kumar 2,031 Reputation points
1 answer One of the answers was accepted by the question author.

SSIS - Excel Macro

Hello, I have an SSIS ETL that moves excel files from a local folder and inserts the data into a SQL database. I'm running into some issues with a the excel files being in two different formats breaking the ETL mappings. I've created an excel macro…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2020-08-18T13:46:27.5+00:00
Tim Mullady 221 Reputation points
accepted 2020-08-19T15:20:14.327+00:00
Tim Mullady 221 Reputation points
4 answers One of the answers was accepted by the question author.

Objects never used in the database.

Hi everyone! Is it right to conclude that objects (tables and indexes) that do not have entries (records) in 'sys.dm_db_index_usage_stats' are objects never used in a database? Hope I was clear enough.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-19T02:41:13.517+00:00
Doria 1,246 Reputation points
accepted 2020-08-19T13:13:20.087+00:00
Doria 1,246 Reputation points
5 answers One of the answers was accepted by the question author.

SQL Server Agent - Retrying When Job Does Not Start

Using SSMS 18. I know I can use the Retry Attempts option to retry a job if it fails. What I'm wondering is whether there is a way to retry a job if it hasn't run at all. For example, I had a job scheduled to run a few nights ago but the server was being…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-18T15:02:08.537+00:00
Josh K 81 Reputation points
answered 2020-08-18T18:52:31.447+00:00
Josh K 81 Reputation points
2 answers One of the answers was accepted by the question author.

Can you please help to recovering a database with log file alone upto latest transactions?

I have lost the drive which hosted data file and DB is recovery so I wanted to recover the data till the last point? is that possible with log file alone ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-18T14:37:51.233+00:00
Anu Grah 21 Reputation points
answered 2020-08-18T18:36:29.95+00:00
Shashank Singh 6,251 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS - Send Mail Task

Hello, I created an SSIS ETL that Loops through a local folder, inserts excel file data into a SQL db, then archives the file. I'm trying to add a Send Mail Task to the process but I can't seem to get it to work. I can get the email to run but it…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2020-08-17T14:35:07.65+00:00
Tim Mullady 221 Reputation points
accepted 2020-08-18T17:58:15.073+00:00
Tim Mullady 221 Reputation points
3 answers One of the answers was accepted by the question author.

Unexpected Termination - SQL Agent - excel Import

Hi experts, According my research over google, this issue has been active since 2018. Unfortunetally I haven't found the right answer. I hope somebody could help me. I have a package in SSIS which loads an Excel file data into a Table. At the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
asked 2020-08-18T07:01:13.66+00:00
Alejandro Lopez 21 Reputation points
answered 2020-08-18T14:40:38.573+00:00
Alejandro Lopez 21 Reputation points
2 answers One of the answers was accepted by the question author.

Display current hour Production

CREATE TABLE dbo.RAWTable(Time_Stamp datetime , Date date , Shift_Id varchar(5) , Line_Code varchar(10) , Machine_Code varchar(10) , Variant_Code varchar(20) , Machine_Status varchar(30) , OK_Parts int , NOK_Parts int , …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,596 questions
asked 2020-08-17T12:15:33.477+00:00
Rakesh Ponnala 21 Reputation points
commented 2020-08-18T12:12:48.63+00:00
Rakesh Ponnala 21 Reputation points
1 answer One of the answers was accepted by the question author.

Segmentation fault (11) when start mssql in centos 7

i installed mssql, made setup, it was working fine. I created some databases and tested some apps can connect. All was fine. After this i rebooted my centos 7, and mssql never started again. i tried to reinstall it, but not successful. On start i get…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,268 questions
asked 2020-08-06T08:14:45.73+00:00
Oleg Koval 96 Reputation points
accepted 2020-08-06T14:57:44.163+00:00
Oleg Koval 96 Reputation points