Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
1,041 questions
0
votes
1
answer
40
views
SSIS To Move Schemas
I'm having one heck of a time trying to compare and move schemas for a new database. I've tried Red-Gate, ApeXSQL etc. and every time I turn around it's not working. I have a customer who has 5 ...
- 21
-1
votes
1
answer
207
views
Identify which index's rebuild operation is causing the log file to grow
We have a database, in full recovery model, which goes under index rebuild maintenance once a week. There is an index which is causing the log file to grow. I have log file growth event alerts enabled,...
- 1,550
-1
votes
1
answer
6k
views
Restore database - Operating system error 5(Access is denied.) on Linux
I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server.
My SQL command is:
RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
- 101
-1
votes
1
answer
181
views
Do I need to stop Log backups when I stop data sync on AOAG?
I was curious about this specific topic.
If I stop data sync to alter primary without affecting secondaries, do I need to stop log backup jobs? does a log backup during the stop data sync would mess ...
- 7,484
-1
votes
1
answer
68
views
RAID 0 for development [closed]
in your experiences does of real world testing of RAID5 come "close" or "far" behind RAID0 in terms of performance as the underlying storage for a heavy write OLTP workload? Please ...
-1
votes
1
answer
1k
views
Maintenance Job not running but not Failing [closed]
I set up a maintenance plan that contains three sub-plans. One sub-plan for hourly log backups, one sub-plan for daily maintenance, one for weekly maintenance. These are custom plans set up using ...
- 67
-1
votes
1
answer
48
views
AOAG not failover when server is unresponsive
We usually have some issues with one of our servers. We notice it was related to RAM and we are already dealing with it.
In the meantime, when the server becomes unresponsive, it will just lock all ...
- 7,484
-1
votes
1
answer
71
views
Performance Metrics are missing for a problem timeframe [closed]
There was a problem time frame of 30 mins (22:00 to 22:30) during which queries had performance issues - bad execution plans, which led to high CPU.
That's what monitoring tool shows:
CPU:
Checking ...
- 5,964
-1
votes
1
answer
121
views
Should my company upgrade from Enterprise 2017 to sql server 2019? [closed]
Our production server is currently running SQL Enterprise 2017.
We're paying for software assurance which means we can upgrade at any time.
Should we be looking at SQL 2019?
- 707
-1
votes
2
answers
130
views
What permissions should be added to public users sql [closed]
I have a SQL Server and am looking at making it public.
What I mean by this is: I can create a DB and give access to myself and friends etc.
I need to create a login which can only view databases it ...
- 101
-1
votes
2
answers
235
views
Whether SQL standard edition has NUMA support?
Link: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017#RDBMSSP
For NUMA Aware Large Page Memory and Buffer Array Allocation the table ...
- 3,489
-1
votes
1
answer
36
views
How to get partnumber that have at least have one source type Website and at least one stockid equal 1 Based on PartNumber?
I work on sql server 2017 i face issue i can't get partnumber
that have at least source type website and at least have stockid equal 1 per partnumber
so with another meaning i need to get part numers ...
- 147
-1
votes
2
answers
1k
views
Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?
To configure linked server pointing to a SQL server, there are 4 possible options.
Server Type: SQL Server
Server Type: Other data source; Microsoft OLE DB Provider for SQL Server
Server Type: ...
- 3,489
-1
votes
1
answer
446
views
Efficient dimension and fact joining
I have large fact table, and a much smaller dimension table in a simple star schema:
--1.
CREATE TABLE dbo.Dim
(
Id INT NOT NULL IDENTITY PRIMARY KEY CLUSTERED,
CustomerName VARCHAR(2000)
)
--index
...
- 265
-1
votes
1
answer
49
views
How can I figure out what the minimum MaxMem value could be without causing issues. MSSQL 2017 Enterprise CU18
I am running several 2017 CU18 instances in failover clusters with "standby" instances for planned growth. I want to configure those standby instances with the least amount of RAM (lowest ...
- 39
-1
votes
1
answer
98
views
Why is the estimate (out of Stream Aggregate) so low?
I have a table like this:
create TABLE dbo.MyTable
(
TMyTableID bigint NOT NULL IDENTITY(1, 1),
LogArgumentID bigint NOT null,
LogID bigint NOT NULL,
LogTextID int NOT NULL,
FloatValue float NULL,
...
- 2,239
-1
votes
1
answer
5k
views
Error at installing Microsoft SQL Server 2017 Database engine services and uninstalling multiple instances
I am trying to install Microsoft SQL Server 2017 with SQL Server 2017 media installation tool, but next error occurs at installation:
PerfLib 2.0 counter removal failed with exit code 2. Command ...
-1
votes
2
answers
147
views
SQL Server Express 2017 Database Mail Silent error
I have made an installation of a development environment in VMWare that contains:
Windows Server 2016
SQL Server Express 2017
The objective is to perform migration tests of a base that is currently ...
- 146
-1
votes
1
answer
177
views
Restoring AdventureWorks2014 Database to SQL Server 2017
I restored AdventureWorks2014 database from SQL Server 2014 to SQL Server 2017.
(I restored it twice, I changed the name on the 2nd restore, of course)
It works fine.
Now I tried to change the ...
- 1,350
-1
votes
1
answer
130
views
Alternatives to reclaim free space after Shrink activity
For couple of our SQL server databases on version SQL2017 APP team did purge to change retention on these partitioned tables which has released quite good amount of space.
Some background-
Before ...
- 794
-2
votes
1
answer
96
views
For how long will a query wait, and what will it do post the wait when offline index rebuild is running?
When an offline index rebuild is running, and a CRUD query is fired, assuming the rebuild takes couple of hours.
How long will the query wait for rebuild to complete?
What will it do once it ...
- 3,489
-2
votes
1
answer
2k
views
Type clash on update of always encrypted varchar in ssms 2017
I am using SSMS 17.6 and I am trying out the Always Encrypted feature.
I was able to update/insert/search a datetime field by declaring a parameter and then using the parameter, e.g.:
DECLARE @...
- 99
-2
votes
1
answer
71
views
Database scoped configuration applicable to Secondary
I saw some new database scoped configurations like MAXDOP and legacy cardinality for secondary options and have few questions or doubts i am not able to understand
MAXDOP-
How do i setup MAXDOP, say ...
- 794
-2
votes
1
answer
76
views
Optimize query with nested inner query and case statements [closed]
I have below query written by someone targeting Microsoft SQL server 2017. I do not have access to database to create indexes etc., So only way I can do is optimize below query as efficient as ...
- 105
-2
votes
2
answers
184
views
First query waits for loading the whole table in memory
I'm testing SQL Server 2017 performance. I've create a table like the following one:
CREATE TABLE [dbo].[AssessmentResponses](
[ResponseID] [int] IDENTITY(1,1) NOT NULL,
[AssessmentID] [int] ...
- 231
-2
votes
2
answers
7k
views
Connecting to Database using powershell [closed]
I'm trying to connect to my database using PowerShell but it's not find it even though I can see it using SSMS.
I'm trying to follow the example MS provides here
- 149
-2
votes
1
answer
821
views
when update large table it take too much time to update
I work on sql server 2019
when update table Z2DataCore.parts.SourcingNotMappedParts i found slow and long time when update
estimated execution plan
actual execution plan
Update statement takes 26.5 ...
- 147
-2
votes
2
answers
849
views
Why does log not get generated when the SQL maintenance plan job fails to execute (agent job history shows job failed)?
In maintenance plan, under the reporting and logging setting I have configured a text file report to be generated and email report. This gets generated and I receive an email every time the ...
- 3,489
-2
votes
1
answer
91
views
Delete millions of rows on a badly designed table [duplicate]
I have identified Millions of duplicated rows on a table I have inherited by using this query:
SELECT COUNT(*) AS NumRecords, AccessID, LEFT(SQLTEXT, 5000)
FROM Table
WHERE AccessID=5012
GROUP BY ...
- 447
-2
votes
1
answer
53
views
Function to convert time difference between two dates into timer format
Does anyone have a function that converts date difference between two dates into timer format ?
For example:
select udf_DateDiffTimer ('2020-05-12 14:12:34','2020-05-12 14:12:35')
The result should ...
- 5,964
-2
votes
1
answer
350
views
Migrate data from Express Edition to Developer Edition [closed]
How can I migrate a database from SQL Server Express Edition to a newly created instance of SQL Server Developer Edition if I do not have a backup file?
I do have the .mdf (data file) and .ldf (log ...
- 105
-2
votes
1
answer
687
views
Datawarehouse Staging Tables: Null or Not Null
We are loading data from OLTP into Staging Tables with SSIS, then into Kimball data warehouse with ETL process.
We are inquiring about staging tables, if they should have null/not null constraints. ...
user168914
-2
votes
1
answer
3k
views
Row_number to not increment if values on three columns are the same from the row before
Suppose I have a dataset that looks like the screenshot below and I need to add a count column for the rows based off the orderid, DocumentNo_, and CurrPackageTrackingNo with the following logic:
...
- 617
-2
votes
1
answer
486
views
Condtional String_Agg In Azure SQL
I have a table of Points.
CREATE TABLE Points(
ID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
Label varchar(50) NULL,
Destination bit NOT NULL,
PickUp bit NOT NULL,
SetDown bit NOT NULL)
)
With Data ...
- 107
-2
votes
1
answer
144
views
Can't create availability group , big error message
hello I am setting up my "high availability group" and I have a little problem, I have this error message .
maybe I have to validate my cluster first? I already tried to validate but I also receive ...
-2
votes
1
answer
1k
views
calculate count by month and year
I am trying to calculate how many people are on a waiting list or still on the waiting list at the end of the month. Ex. If 5 people are waiting in Jan and then in Feb 3 people get added to the list ...
- 11
-3
votes
1
answer
3k
views
What is the difference between CU-GDR and GDR?
There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade.
CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
- 1
-3
votes
2
answers
67
views
i need answer for this problem [closed]
I need to get How many days each customer place order?
Table name - T_Order
OrderId OrderDate MenuItemId Quantity CustomerId
1 2021-01-02 1 2 1
2 ...
-3
votes
1
answer
90
views
How to write select statment that get data based on partid from last date to current date with filling gapes?
I work on sql server 2012 i face issue i can't make select statment get Partid from last month until current month march (3) .
based on last date exist per partid
and on same time if there are any ...
- 147
-3
votes
1
answer
3k
views
Select records based on priority
I have data stored as:
TestId | Priority |
--------+-----+-----
test103 | 2 |
test104 | 2 |
test105 | 1 |
test106 | 0 |
test107 | 1 |
test108 | 2 |
...
user244947
-4
votes
1
answer
235
views
I need help with fixing this query please!
I need to figure out what is wrong with this query. I get this error when running the query: "Msg 8169, Level 16, State 2, Line 1
Conversion failed when converting from a character string to ...
- 1