SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,328 questions
3 answers
How to recover data from reinstallation of Windows server 2012 R2
Hi there, I'm facing a problem that I have restore the data from the backup and the data is not up to date. Previously I had faced a windows update issue and cause the server to restart in a loop. After restore the data from the backup. I notice…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
2 answers
could not allocate a new page for database because of insufficient space in filegroup...
I have an ETL staging which run out of space. I removed some data but tables do not release space after deletion, cannot truncate or copy to another database due to policies/etc. eventually I want to stay at same space and number of datafiles. there…
asked 2020-08-20T21:58:45.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 93%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SeHor
66
Reputation points
answered 2020-08-21T06:18:30.233+00:00
Olaf Helper
43,166
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…
asked 2020-08-19T14:50:34.277+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
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…
asked 2020-08-20T05:06:08.347+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jim Millerick
21
Reputation points
answered 2020-08-21T03:12:55.797+00:00
Jim Millerick
21
Reputation points
2 answers
SSAS MDX named set
I am trying to create a common named set with fixed members so it can be used in multiple calculated members. But for some reason, it's failing. I am new to MDX scripting. Let me know if there is an issue here. Aggregate({[TT Collection].[TT…
asked 2020-08-20T11:34:07.953+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nagrajuna Bandi
1
Reputation point
answered 2020-08-21T02:28:03.203+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,821
Reputation points
1 answer
Why SSRS report parameter not considering float values after selected the data type as float, when we pass values at preview level.
Why SSRS report parameter not considering float values after selected the data type as float, when we pass values at preview level.
asked 2020-08-20T09:04:41.677+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 68%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sathish
1
Reputation point
answered 2020-08-21T02:23:01.233+00:00
Joyzhao-MSFT
15,571
Reputation points
0 answers
Running PowerShell command in Central Management Server
I'm a PowerShell noob. I know I can run T-SQL commands against multiple servers in my Central Management Server. Can I run a PS cmdlet or function against multiple servers from within the CMS? When I click on any node in the CMS hierarchy, the…
asked 2020-08-20T04:15:12.643+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David C
191
Reputation points
commented 2020-08-20T09:18:45.613+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
1 answer
Replication with AlwaysOn AG misidentifies distributor
Hi, I have two servers (MYSQL1, MYSQL2), Windows-clustered, each with a default SQL instance (port 1433) and each with a named instance (MYSQL1\REPL1, MYSQL2\REPL2, both on port 1435). SQL Server 2016 SP2 CU14 Enterprise. I have an AG across the…
asked 2020-08-20T05:09:29.803+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Simon Bailey
1
Reputation point
answered 2020-08-20T08:35:53.037+00:00
MelissaMa-MSFT
24,186
Reputation points
2 answers
MASTER Database SGAM page corrupted
MASTER Database SGAM page corrupted and it says object id 99 but when in search in sysobjects table there is no 99 object id.
asked 2020-08-19T21:23:34.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 65%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Allen Francis
26
Reputation points
commented 2020-08-20T08:12:40.66+00:00
Shashank Singh
6,251
Reputation points
3 answers
Blocked process report.
Hi everyone! I am trying to use the SQL Server blocked process reporting feature but it is not working. Below the commands I executed and the article I followed. …
asked 2020-08-17T15:03:05.207+00:00
Doria
1,246
Reputation points
commented 2020-08-20T07:38:08.04+00:00
CathyJi-MSFT
21,126
Reputation points Microsoft Vendor
1 answer
unable to connect ms sql server via jdbc 8.2.0 on linex through spark with windows authentication
i am trying to connect MS SQL server via jdbc 8.2.0 using spark with windows authentication from linux server but it throw error message as sqljdbc_auth not found in java library path.
asked 2020-08-13T12:21:45.863+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 0%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
senthil veeramani
1
Reputation point
commented 2020-08-20T07:23:07.11+00:00
Cris Zhan-MSFT
6,611
Reputation points
5 answers
Can I install SQL server 2016 from licensed SQL 2017 Installer?
I need to install SQL server 2016 on a server. We have a licensed SQL server version 2017. Is it possible to downgrade the 2017 installer to install version 2016.
asked 2020-08-19T10:54:14.713+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Lertprasertwech, Krissada
6
Reputation points
commented 2020-08-20T07:11:48.463+00:00
CathyJi-MSFT
21,126
Reputation points Microsoft Vendor
2 answers
SQL Server 2019 trigger does not execute
I just moved a database from sql server 2014 to 2019 and now an update trigger does not execute when it should. Here's the first part of the trigger: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER…
asked 2020-08-19T22:07:59.907+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 83%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
moondaddy
1
Reputation point
answered 2020-08-20T05:28:25.983+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com
4,306
Reputation points
2 answers
I installed 2017 LocalDB, then 18.6 MSSMS. But I couldn't connect to server.
TITLE: Connect to Server Cannot connect to MY-PC\SQLEXPRESS. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the…
asked 2020-08-19T15:39:57.067+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 46%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
David Fan
1
Reputation point
answered 2020-08-20T04:05:28.177+00:00
Cris Zhan-MSFT
6,611
Reputation points
1 answer
SSAS 2019 Hangs while processing
This has happened four times now since March 2020: I have a SQL Agent job that handles the processing of several SSAS Tabular models. One of the processing steps will hang up. When it does, the SQL Agent Job cannot be STOPPED. Oh, you can try to stop it…
asked 2020-08-19T18:23:20.647+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Todd Chittenden
1
Reputation point
answered 2020-08-20T03:14:20.383+00:00
Lukas Yu -MSFT
5,821
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…
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
asked 2020-08-18T19:37:11.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
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…
asked 2020-08-18T13:46:27.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Mullady
221
Reputation points
accepted 2020-08-19T15:20:14.327+00:00
Tim Mullady
221
Reputation points
2 answers
SharePoint Permissions Problems
Hi there, I'm not sure if anyone has experienced this issue before, but it's surely a strange one! Our organisation suffered network issues last week with our DR site and since then we are having problems with SharePoint permissions. Some users…
asked 2020-08-18T12:50:44.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 96%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Aled Hughes
96
Reputation points
commented 2020-08-19T14:16:38.98+00:00
Trevor Seward
11,696
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.