| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 13:08:24 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b67fc4f672ffb-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=64f9130d-0a76-460a-80ea-f85c56d54266; expires=Thu, 23 Jul 2026 13:08:23 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: db4ca45a-3cdf-4435-aa1b-743f57c155b7
x-worker-origin-response-time: 1035000000
x-dns-prefetch-control: off
set-cookie: prov=64f9130d-0a76-460a-80ea-f85c56d54266; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=vJLcNIfrIyNymwLLHpkTGbh.0dxtfvDPDDnB0NtpM1A-1753276104-1.0.1.1-M3eNJXCNPmyRXaLLzkMrmIUSgDRMhYi_Ji6l55tovAU3ZVKOzdyyKhSiXmt2tQwoLMBweL0y8CUQZblY05wiIKAamTdEBKLV2jMxiqqhGng; path=/; expires=Wed, 23-Jul-25 13:38:24 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=8eom.5FgVRfkTAnTId8qbaV8Ma3GyMQ61.a_.PLgHrs-1753276104132-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'sql-server-2008-r2' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [sql-server-2008-r2]
SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.
3,781 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
17
views
SSAS Multidimensional Model: Questions on Key Attributes
I have several dimensions whose key attributes (i.e. attributes whose Usage property = "Key") takes a really long time to process (because the dimensions are really big; some of them are ...
-1
votes
1
answer
138
views
SQL Server 2008 R2: Rebalance files of a database to a same size
I have a SQL Server 2008 R2 database which consists of 4 physical files:
DB_0.mdf (200 GB)
DB_1.ndf (300 GB)
DB_2.ndf (500 GB)
DB_3.ndf (1300 GB)
No tables of this database have clustered indices.
...
0
votes
1
answer
130
views
Transactional replication Snapshot agent not starting
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 ...
1
vote
1
answer
44
views
SSMS Version of 2008R2 Publisher not compatible with 20012 Subscriber
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
1
vote
0
answers
134
views
Remove Transactional Replication Manually or Via SSMS?
I am setting up transactional replication on my 2008R2 server to 2012 distribution server to 2012 Subscriber server. All the three servers are on FULL recovery mode. Log backup is taken every 15 ...
1
vote
1
answer
38
views
SQL Server 2008R2 - data file grows back after shrinking and available to shrink again
After shrinking of datafile there is around 180Gb of free space on hard drive (prior to operation shrink file dialog also shows that it is possible to free up around 180Gb of space). After 1-2 days ...
1
vote
0
answers
41
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
81
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
58
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
102
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
318
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
548
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
109
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
326
views
SSAS Backup to Remote Location [duplicate]
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
119
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
...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 2630
t-sql × 354
sql-server-2008 × 337
performance × 217
sql-server-2012 × 171
backup × 124
index × 111
replication × 110
permissions × 104
ssis × 96
ssms × 95
query-performance × 88
security × 74
restore × 71
sql-server-2014 × 70
sql-server-agent × 66
stored-procedures × 64
linked-server × 62
transaction-log × 60
mirroring × 56
database-design × 55
sql-server-2005 × 52
index-tuning × 50
memory × 47
more related tags
Hot Network Questions
- Why were two 2x6 boards installed on top of a window rough sill?
- What was the Russia-Germany 1996 "Defence pact" that Russia recently announced has been terminated?
- Story about a room on Mars that contains God
- Mother in Law has overstayed her schengen visitor visa by 9 days. She is applying for the same visa this year, what should we take care of?
- Distribution of a dot product of multinomial variables
- Dystopian 80s sci-fi movie about the USA choosing mediocrity
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- Why is the number of Marie Curie postdoctoral fellowships in mathematics significantly lower than in other subjects?
- Make a Mulenère encryption program
- A soviet sci-fi novel (novelette?) with frogs?
- Calculating the wall thickness in a hollow rotating cylinder space habitat
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?
- Idempotent integral operator
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- How to make peaks with thick lines pointy?
- A word that describes some people
- Must hospitals care for unidentifiable individuals indefinitely?
- SOSL/SOQL isn't returning User records
- At Helsinki airport, connecting from Schengen to non-Schengen flight, is there exit immigration?
- Is a diet of one third Tuna ok for an eldery cat?
- How do mechanical gyros maintain rotational speed?
- Console-based Casino Game in C++
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Prevent equation label from shifting down