18,571 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

MDX code to get today's date

Hello, I created a query for Excel in Power Pivot using the visual designer. I currently have to change the dates every month. I need to modify it so it automatically returns the data for January from the current year until the current month. …

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,258 questions
asked 2020-08-21T14:09:13.197+00:00
L G 1 Reputation point
answered 2020-08-24T05:43:05.687+00:00
Lukas Yu -MSFT 5,821 Reputation points
2 answers

Global variables using in other forms

I am making a software i want a global variable so that i can use across one form to other so basically i want to call roll no. that is written in an event datagridview row header event: Roll_No =…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,870 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.
13,269 questions
asked 2020-08-21T07:00:59.377+00:00
Zeeshan Haider 21 Reputation points
answered 2020-08-24T05:23:58.037+00:00
Daniel Zhang-MSFT 9,621 Reputation points
8 answers

Database trigger and there is login fail on the sql errorlog

I have the following trigger database trigger and then there is a error in the errorlog why is that ?

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,269 questions
asked 2020-08-18T04:18:24.463+00:00
sakuraime 2,321 Reputation points
answered 2020-08-24T01:37:34.48+00:00
m 4,271 Reputation points
5 answers

Index Optimization job stuck - Sql 2008R2

Hello, We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's maintenance Solution but during job was running and Sql server Shutdown/Restarted and job still showing as in 'Progress'. This is a Sql Agent job we…

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,269 questions
asked 2020-08-17T17:22:28.687+00:00
pdsqsql 411 Reputation points
commented 2020-08-24T01:25:20.25+00:00
AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
3 answers

SQL Server 2019 Highly Available Cluster - Setup

I have a Hyper-v Cluster and would like a recipe for adding a highly available SQL role

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,269 questions
asked 2020-08-17T14:33:35.027+00:00
Tolo, David 1 Reputation point
commented 2020-08-24T01:13:40.467+00:00
AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
7 answers

SQL Server 2014 table compression

Hello, planning on running a SQL Agent Job to compress some Prod Tables which looks like will take a couple of hours to finish. Is it correct to say that during this Tables (only) compression job just the target tables will be unavailable/locked 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,269 questions
asked 2020-08-19T23:21:22.477+00:00
techresearch7777777 1,801 Reputation points
commented 2020-08-23T21:25:06.43+00:00
Erland Sommarskog 106K Reputation points MVP
3 answers

MECM/WSUS - SQL option collocate or remote SQL?

Hi All Wanted to bounce my thoughts with fellow members. I am about to embark on a mini project for a customer. It's for a small experiment and a new network and infrastructure environment will be created on-premises. Unfortunately for this piece of…

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,269 questions
asked 2020-08-20T08:43:34.89+00:00
Anonymous
answered 2020-08-22T22:17:56.813+00:00
Jason Sandys 31,186 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Updating a table based on values in the table

I have a temp table #XX that looks like this" ID KWID NAME ORDER 1447 1144 SW_6368_58_55.png NULL 1450 1145 SW_6942_58_55.png NULL 1451 1147 Arb3_43_55.jpg NULL 1452 1147 Arb1_43_55.jpg NULL 1453 1147 Arb2_43_55.jpg NULL 1598 1152…

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,269 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-22T00:45:59.007+00:00
Jim Seidel 61 Reputation points
commented 2020-08-22T21:57:34.327+00:00
Jim Seidel 61 Reputation points
4 answers One of the answers was accepted by the question author.

Actual Execution plan for query store

is it possible to capture actual execution plan inside query store ? or else need to use back xevent ?

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,269 questions
asked 2020-08-20T04:57:53.157+00:00
sakuraime 2,321 Reputation points
accepted 2020-08-22T09:49:37.813+00:00
sakuraime 2,321 Reputation points
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,269 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,269 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,269 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

How to map IDs in different formats from source to destination

Hi, My source data is in postgreSQL and my target data is in Common Data Service (D365). On source, I have employees with these IDs: 1 2 ... On target, the IDs are a little bit more complex. How can I map these IDs? I need to know that…

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-20T14:11:24.923+00:00
Ana Alves 1 Reputation point
answered 2020-08-21T10:35:06.083+00:00
Cris Zhan-MSFT 6,611 Reputation points
2 answers

Msg 319, Level 15, State 1, Line 2152 Incorrect syntax near the keyword 'with'.

Forum, I'm trying to build a clustered index for the all the heap tables moving to a different FG i have almost 1k statements so running them all as a batch CREATE CLUSTERED INDEX [PK_Create_my_index1] ON [dbo].[tab1] ([ID] ) WITH (DROP_EXISTING =…

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,269 questions
asked 2020-08-19T12:35:14.847+00:00
NoviceDBA9 41 Reputation points
commented 2020-08-21T10:18:19.527+00:00
tibor_karaszi@hotmail.com 4,306 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,269 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
1 answer

Type of reports

We are considering getting our teachers (55 teachers) to set weekly homework via Microsoft Teams. As I am in charge of homework, is there a way for me to see (run a report/analysis) who has set homework across the organisation. We currently have this…

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,549 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,860 questions
asked 2020-08-12T15:38:54.57+00:00
D Samuel 1 Reputation point
commented 2020-08-21T09:53:40.837+00:00
Sharon Zhao-MSFT 25,081 Reputation points Microsoft Vendor
2 answers

Timeout after 10 minutes over Linked Server

I have a simple select query running over a linked server. It normally takes 7 or 8 minutes, but sometimes goes over 10, in which cases it appears to time out: Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000]…

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,269 questions
asked 2020-08-18T11:14:10.23+00:00
Aidan Grant 1 Reputation point
commented 2020-08-21T09:51:02.723+00:00
AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor