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
1
answer
165
views
Update Table with Network Client Connection Status, I need help with DB design. SQL 2008 Ex R2
I have C# client application that updates a Server Database, SQL 2008 Express R2. The client application send a ping to a group of devices once every 30 seconds and displays their status then updates ...
- 11
4
votes
4
answers
750
views
Cannot reproduce client SQL 2008R2 error: subqueries are not allowed
EDIT: My question is not "how do I work around the failure?", my question is "why is the failure occurring?"
We have a client that reports error "1046 subqueries are not allowed in this context. Only ...
- 41
5
votes
1
answer
3k
views
SQL Server 2008 R2 reindex job reorganise getting stuck
I am currently experiencing this job getting stuck in my nightly maintenance solution -
ALTER INDEX [PK_ThirdPartySettleCalled] ON [evo_archive].[dbo].[ThirdPartySettleCalled]
REORGANIZE WITH (...
- 2,591
3
votes
1
answer
3k
views
Getting error on SQL Server
I am getting these error messages one after the other every week on Win 2008 and SQL 2008 R2. MAX DOP is set at 1. Any idea how I can solve this?
Thanks.
DESCRIPTION: A fatal error occurred ...
- 1,371
3
votes
3
answers
2k
views
Instant File Initialization | Lock Pages in Memory Issues
I have a server that I'm coming onto performance tune and for the life of me I can'g get these rights enabled. So I ran
PS SQLSERVER:\SQL\NOFAULT2010\DEFAULT+sa\> whoami
nofault\administrator
...
- 957
8
votes
1
answer
2k
views
Understanding SQL Server permissions
I am rooting around in SQL Server Management Studio against my instance of SQL Server 2008 R2 Express Edition. I am trying to understand how the permissions work.
What I can see is (via the ...
- 450
5
votes
2
answers
4k
views
SQL Server database forum design sample
I am doing a design for a database using SQL Server 2008 R2, basically it is a simple database design for a forum (just like games fans forums). Fortunately I am struggling with it as I didn't find ...
- 153
31
votes
4
answers
32k
views
Adding columns to production tables
What's the best way to add columns to large production tables on SQL Server 2008 R2? According to Microsoft's books online:
The changes specified in ALTER TABLE are implemented immediately. If the ...
- 609
23
votes
3
answers
6k
views
How often to backup the master database?
The suggestion in BOL is fairly vague:
Back up master as often as necessary to protect the data sufficiently
for your business needs. We recommend a regular backup schedule, which
you can ...
- 2,619
25
votes
3
answers
8k
views
Should I stop transaction log backups during a full backup?
I have two SQL Agent jobs which are scheduled to run at different intervals. The first job runs a full backup once a day. The second job runs transaction log backups every fifteen minutes.
As the ...
- 2,619
7
votes
3
answers
53k
views
SQL Server Configuration Manager not display services
Config: Window Server 2008 R2 Enterprise SP1 / SQL Server 2008 R2 Enterprise (RTM)
I have searched through Google using many different words and phrases. I know this was a common issue to occur with ...
user507
0
votes
2
answers
2k
views
Auto-Shrink, Encryption & Recovery Model properties in SQL Server 2008 R2
I am creating a new database in SQL Server 2008 Express R2. In the New Database dialog, I could see an option to set the Recovery Model, which is by default set to: Simple. If I set it to Full, what ...
- 1,425
4
votes
1
answer
3k
views
Unattended install of SQL Server 2008 R2 cluster fails with error - "Illegal characters in path."
I am trying to build an .ini file for unattended installations of SQL Server 2008 R2. I followed this blog post to build an initial .ini file: http://blogesh.wordpress.com/2008/09/23/silent-install-of-...
- 664
14
votes
5
answers
46k
views
Save Results as CSV *with* headers in SSMS
With SQL Server 2008 R2, when I save the results as a CSV there are no headers. I can work around this by copying and pasting with the "Copy with Headers" , or just grab the headers and paste them in ...
- 2,335
2
votes
1
answer
7k
views
Sql Server 2008 R2 DBCC SHRINKFILE Severe Error
I am trying to run the following command in Sql Server 2008 R2:
DBCC SHRINKFILE('filename')
When I try to run this command, I get the following error:
Msg 0, Level 11, State 0, Line 0
A severe ...
thiag0
2
votes
1
answer
5k
views
SQL 2008 R2 Repair: Setup failed to install Windows PowerShell. Error code is -2145124329
When I try to Repair my SQL 2008 R2, I get the following error. How can I solve this?
TITLE: Microsoft SQL Server 2008 R2 Setup
The following error has occurred:
Setup failed to install Windows ...
- 163
3
votes
2
answers
1k
views
SQLCLR TVF that calls web service is getting error 401: Unauthorized
I am calling a web service from a SQLCLR TVF in SQL Server 2008 R2.
On the IIS server this service has open permissions. When tested using GET or POST requests on a browser the web service works as ...
- 151
3
votes
3
answers
3k
views
SQL Server Permission Denied Error When I'm DBOwner?
So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to run CREATE TABLE on a database that I had created and now owned, but was getting a ...
- 145
2
votes
1
answer
18k
views
How to backup and restore a database to a different location and name via command line only
I have a database that I want to copy from one location to another (maybe even to a different computer) via the command line only.
The name of the database on the new location should not be identical ...
Li.
5
votes
1
answer
387
views
Migrating large database
What is a quick way of migrating 75G database to the cluster? I tried to test the backup and restore and it took more than 2 hrs. Business owners won't accept the long outage. Any idea how I can make ...
- 1,371
1
vote
1
answer
5k
views
"Request to run job dbxxxxx refused" error in merge replication
I'm doing merge replication whole of my database but when I create the subscription I encounter this error:
SQLServerAgent Error: Request to run job DBXX-XX--bazresiostani2-2 (from User sa) refused ...
- 269
1
vote
2
answers
2k
views
maintenance plan executing by agent
I have a built-in, regular maintenance plan scheduled to run weekly.
The databases are SharePoint databases and a snap manager (netapp snap manager) backs up these databases.
The rebuild ...
- 1,371
15
votes
2
answers
9k
views
SQL Server 2008 - Partitioning and Clustered Indexes
So let me preface by saying I do not have total control over my db design, so a lot of the aspects of the current system cannot be changed for the purposes of this scenario.
Comments about how we ...
- 17.9k
42
votes
3
answers
81k
views
Execution Plan Basics -- Hash Match Confusion
I am starting to learn execution plans and am confused about how exactly a hash match works and why it would be used in a simple join:
select Posts.Title, Users.DisplayName
From Posts JOIN Users on
...
- 2,335
5
votes
3
answers
110k
views
SQL Server 2008 R2 (Suspect) mode - how to repair?
I have SQL Server 2008 R2 database in Suspect mode. I tried to fix it running this query:
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(’yourDBname’)
ALTER ...
- 171
11
votes
1
answer
1k
views
SQL Server 2008 R2 Dirty reads - how non-atomic?
I am wondering "how dirty" dirty reads can get under a read-uncommited isolation level. I understand that rows that have been updated but not yet committed are visible, but:
Can a row appear as ...
1
vote
1
answer
130
views
Sessions, Processes, Object Instances, Sequential and Parallel Processing Theory
A stored procedure contains a view which is accessed multiple times with the confines of the SP.
If the SP is executed multiple times in one query window with different parameters, e.g.
EXEC spMySP ...
- 113
4
votes
2
answers
181
views
Randomizing table contents and storing them back in the table
I have a table with at least a million records in it. These rows were created by a custom app that reads several SharePoint site collections and stores the item urls in the table. Now, since we read ...
- 143