Questions tagged [sql-server-2012]
SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.
4,535
questions
-1
votes
1
answer
116
views
Delete operation taking time from SQL Agent Job
I am running a job which deletes data from 7 tables, 2 of which contains 1-2 million records. But the job gets stuck at a point when deleting data from web_activity table which holds only 42 000 ...
- 1
0
votes
1
answer
50
views
What happens if the Subscriber goes down - will the t-logs keep accumulating on the publisher in Transactional Replication?
I am trying to consider all the options before setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL ...
- 27
0
votes
1
answer
48
views
Setting up Transactional Replication - Can i safely remove transactional replication if it is causing issues on my publisher?
Please excuse me if I am not making very much sense here. I am very new to replication and have been researching for quite some time about transactional replication to implement in our scenario..
I am ...
- 27
1
vote
1
answer
33
views
Recovered database files, need to be rebuilt using a new SQL server instance [closed]
Need some help in recreating a recovered database. We recently recovered an old disk drive that has the following folders on it:
Program Files\Microsoft SQL Server\MSSQL...
Program Files(x86)\...
- 11
1
vote
1
answer
379
views
Why did queries become slower after upgrading SQL Server 2012 to 2022?
I'm in the process of upgrading my current set of databases from SQL Server 2012 to 2022. I've ensured I've matched my resources/specs to ensure both Servers match. I am facing a huge performance ...
- 31
0
votes
0
answers
19
views
Problem with SQL Server Merge Replication 2017
I have multiple replications: merge replications that sync the data on both Headoffice and Stores but from past two days I am getting these error messages and replication doesn't complete successfully ...
0
votes
0
answers
33
views
What is the easiest way to do filtered replication to another SQL Server 2012 database with the exact same schema?
I need to start a filtered replication of a SQL Server 2012 database for a company subsidiary that contains only a subset of records related to that subsidiary (using only row filters). This is in ...
- 101
0
votes
0
answers
53
views
Elapsed time of the query is abnormal in SQL server
I am trying to find the elapsed time of the query in SQLSERVER using the view, sys.dm_exec_requests. For some queries the elapsed time is more than an hour, most of the queries coming up when using ...
1
vote
2
answers
331
views
How can I save the job result to a file?
I created a job in SQL Server. This job runs the following statement at regular intervals:
Select NationalIDNumber from HumanResources.Employee where BusinessEntityID = '1'
I want to save the result ...
- 57
0
votes
2
answers
189
views
sqlserver memory problems，How to check the memory usage
I want to know whether sqlserver has a memory bottleneck, how bad the free memory needs to be
Can you see which statements use more memory
thank you
Read some information do not understand, want to ...
- 1
0
votes
0
answers
80
views
Sql server database restoring from backup, sql users without login
After restoring a database from another SQL server, set database comes with database users without login. Do these users have any actual functionality or they are practically dead users? I've looked ...
- 79
0
votes
1
answer
37
views
Get Point from Another Table based on Category and Value Range
I am trying to get a column which specify the points by comparing the value from original table to min and max value from another table. I have a main table, which consists of few columns of values ...
-3
votes
1
answer
21
views
In what format do I need Insert 3 table sql? [closed]
In what format do I need Insert 3 table sql?
animals(`AnimalsID`, `Animals`, `IUCN_Red_List`, `TypesID`, `BloodedID`)
types(TypesID,Types)
blooded(BloodedID,Blooded)
0
votes
0
answers
46
views
Convert a list-of-IDs column into a junction table [duplicate]
I have a table, Office, with a column that contains lists of ids representing many-to-many relationships:
TABLE Office {
OfficeId int IDENTITY(1,1) NOT NULL,
CubeIds NVARCHAR(MAX) NULL, --values ...
- 11
0
votes
1
answer
341
views
Deleting rows using count after reaching certain threshold MS Sql server 2012
I'm trying to make a loop query for Sql agent which checks users data and if the criteria is met reward is sent, after that it would delete the records from the table restarting the loop. The issue is ...
- 79