Questions tagged [sql-server-2008-r2]
SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.
3,778
questions
1
vote
0
answers
32
views
Execution plan showing high hash match [closed]
i have a sql query running from database 1 that joins table company on to a view
SELECT DISTINCT RTRIM([K].[cmpCompanyCode]) AS [cmpCompanyCode]
FROM [dbo].[view] AS [K]
JOIN [database2].[dbo].[...
2
votes
0
answers
57
views
Views that were created in SQL Server 2008 R2 are encountering compatibility issues when re-created in SQL Server 2016 with identical definitions
We've created a view in 2008 R2. Provided below are the definitions for both the base table and the view.
Base table:
CREATE TABLE dbo.test(
fcrecid char(25) NOT NULL,
fctype char(1) NOT NULL,
...
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
votes
1
answer
58
views
sp_BlitzWho while executing gives error message as 'Incorrect syntax near the keyword 'COALESCE'.' in SQL SERVER 2008
To know the spids which are causing slow down/blocking each other; I am trying to use 'sp_BlitzWho' by brilliant Brent Ozar; however on executing on SQL SERVER 2008; am getting message as below.
Msg ...
-1
votes
1
answer
187
views
DMV sys.dm_exec_procedure_stats sometimes returns weird (incorrect?) values in successive object snapshots
I'm working on a small project to monitor activity and execution metrics of user stored procedures. Periodically (every 10 minutes or so), I'm taking snapshots of the sys.dm_exec_procedure_stats DMV, ...
0
votes
1
answer
357
views
MS SQL Login failed for user 'sa'.[CLIENT: <local machine>]
I changed the password of sa using the command [ALTER LOGIN WITH PASSWORD]. Then , it keeps showing the below message in fail log every minute.
Login failed for user 'sa'. Reason: Password did not ...
0
votes
1
answer
63
views
Table structure where name changes to be retained
Example Situation - order table with client list and products. In below example table , when client name/company changes (company name may change) when updating records need to retain old company name ...
0
votes
1
answer
196
views
SSAS Backup to Remote Location
I followed the steps in the best answer on this question - How can I dynamically back up all SSAS databases on a given instance? - and can successfully create backups of our BI Cubes to a local drive ...
1
vote
1
answer
86
views
Delete records in different tables
I need to delete the records where UserIndex = 1 and ItemNumber = 5202 in all three tables, all in a single query. I am using SQL 2008 R2.
Table UserInfo1
UserIndex
Itemnumber
ItemCount
1
5202
99
1
...
0
votes
0
answers
176
views
Dealing with Corruption
I started getting Error 823 alerts from my SQL Server. When I checked SQL Server error log, I found lots of this:
A read of the file 'path\to\my\file.ndf' at offset 0x00000d5f850000
succeeded after ...
2
votes
1
answer
103
views
What is trace flag 1605?
What is trace flag 1605 in SQL Server 2008 R2? I haven't been able to find any documentation on it so far.
1
vote
0
answers
30
views
SA disabled and no other user has access to master db [duplicate]
I have inherited an old SQL Server 2008 R2 where SA login is disabled. No other logins gives access to master db, so I cannot really gain access to administrative stuff (create new logins, change ...
0
votes
0
answers
283
views
Inplace upgrade SQL Server 2008R2 to 2019 while retaining IP and computername using Start-DbaMigration?
I am running existing legacy applications in production using an older version of SQL Server 2008 R2 Standard Edition, my goal here is to perform an inline/in-place upgrade to SQL Server 2019 Standard ...
0
votes
1
answer
930
views
Is it possible to grant EXECUTE permissions on a custom function without compromising read-only access?
We have an ancient database instance - Microsoft SQL Server 2008 R2 SP1 - that is running an (also obsolete) business-critical application. I know this is horrible, but for now it's not my call.
Long ...
0
votes
0
answers
479
views
SQL Server - Exclusive access could not be obtained because the database is in use
Took backup of database from SQL Server 2008 R2 Enterprise and trying to restore it on a database on SQL Server 2019 Enterprise but getting error:
Exclusive access could not be obtained because the ...