All Questions
Tagged with sql-server sql-server-2012
3,289
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 ...
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 ...
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 ...
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)\...
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 ...
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 ...
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 ...
0
votes
2
answers
188
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 ...
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 ...
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 ...
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 ...
0
votes
0
answers
287
views
Removing/disabling a single SQL instance on a failover cluster?
I need to retire a single SQL instance on a (classic) failover cluster while leaving other SQL instances running. SQL version is 2012 in case that matters, but this could come up for other versions in ...
0
votes
0
answers
309
views
How to delete specific table partition in SQL Server?
I am able to switch out and IN and also truncate partition.But I am not able to delete specific partition file in SQL Server. Suppose there is total 4 partition in order table, I don't need partition ...