All Questions
Tagged with sql-server-2017 sql-server-2012
17 questions
0
votes
2
answers
2k
views
WHEN run query on SQL Server, it is very slow. How to solve execution plan issues?
I work with SQL Server and face an issue that a query is very slow.
INSERT INTO [ExtractReports].[dbo].[TradeCodesDelete] (PartID,
Code,
...
- 19
0
votes
0
answers
32
views
How To Grant A Specific Login Under Acitve Directory Group To View Server State In SQL Server [duplicate]
I want to grant only a login who is under an active directory user group to view server state in sql server. How can i do it?
- 1
1
vote
3
answers
406
views
Shrinking data file to save disk space before migration
I know this is most discussed answered on various forums: I completely understand answer is no in most of the time or cases.
However want to know if it can be good approach under any scenario:
Lets ...
- 794
0
votes
2
answers
668
views
What Is The Best Way To Clone A Database From Production To Development Environment? [closed]
We use SQL Server at our company as DBMS. I have a scheduled job working monthly. The job restores every databases on production server to development server at the end of the month but there is ...
user220660
0
votes
0
answers
69
views
Wrong column data types when using dtswizard
I need to copy a database from a MS SQL Server 2017 to a MS SQL Server 2012.
I am not sure what's the best way to go, but I'm currently trying to use dtswizard to do the job.
Everything seems to be ...
- 101
0
votes
1
answer
68
views
Getting VLF info with least privileged to run across multiple servers of different version
Per our monitoring scripts i am thinking to add monitor the status of VLF for each database across different SQL servers in our organization:
We have mix of servers from 2012 to 2019: I've found a ...
- 2,210
2
votes
1
answer
262
views
Reason why SQL Max memory expansion seems slow when migrated to newer version of SQL server
We are trying to understand below behavior happening in SQL Server and need some guidance:-
After migrating from older version SQL2012 (running on bare metal P Server) to newer SQL2017 running inside ...
- 794
0
votes
1
answer
3k
views
Need to upgrade SQL Server from 2012 to 2017 on a Server 2008 box
I have been asked to upgrade SQL Server from 2012 to 2017, it is currently installed on a server with Windows 2008 OS.
My thinking from what I've researched is this:
Take a snapshot of the server
...
LamNam
1
vote
1
answer
5k
views
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error
I created a linked server to MySQL database server on my SQL Server database server. I tested the connection. It succeeded successfully for MySQL connection. I can see the databases on MySQL instance ...
- 69
1
vote
1
answer
51
views
Where Database Alerts & Operators Exist In SQL Server?
My SQL Server database server has crashed. I have system databases backup. I will reinstall the sql server but i don't know how to find my operators, alerts and config settings. Is there a way to find ...
- 69
9
votes
1
answer
1k
views
Why do MS SQL Server SEQUENCEs not have an ORDER parameter like Oracle?
In the documentation of CREATE SEQUENCE for T-SQL, you can see that the CREATE SEQUENCE command has no ORDER parameter.
For comparison, the Oracle docs for CREATE SEQUENCE show the ORDER/NOORDER ...
- 689
3
votes
3
answers
2k
views
All SQL Server aliases linked to default instance instead of instance I assigned
I have multiple SQL Server instances(different versions) on my computer.
I try to create aliases for each instance as
First I thought I had everything settled then I found no matter which alias name ...
- 455
6
votes
1
answer
1k
views
What Other Information Is Stored in The Page Header
A SQL Server database page is defined as to be 8192 bytes in size.
There is some header information which is said to be 96 bytes in size.
And if you have ever tried to create a table with more than ...
- 18.3k
1
vote
0
answers
717
views
SQL Transactional Replication - some tables frozen, but others working fine
Background
We are "republishing" 20 SQL Server 2012 source databases, using SQL 2016 as the republisher and subscribers, with SQL 2017 acting as the single distributor for both "hops" (Hop 1 being ...
- 662
2
votes
1
answer
7k
views
Upgrading to SQL Server 2017 from SQL Server 2012
Upgrade or New Build? Any suggestions?
Does anyone have any gotchas or war stories to share about this process?
We have a 2012 instance in Prod that has both OLTP and OLAP databases. We are creating ...
- 135
2
votes
1
answer
91
views
What are the factors to consider or to worry when we migrate to SQL Server 2017 from 2012
We have been asked to migrate to SQL Server 2017 from 2012. Only coding experience as background we are not so aware of what are the crucial points to consider or to worry when migration.
Some of the ...
- 141
5
votes
2
answers
232
views
How to definitively clear away database before restoring from new version of backup file
We are a team of mathematicians (i.e., no DBA experience).
We are migrating from an old server box (SQL Server 2012) to a new server box (SQL Server 2017). For each database on the old server, we ...
- 409