Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008-r2
Search options not deleted
user 11212
SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.
0
votes
How does SQL Server Startup?
Ah, after you updated your comment I realized that you were asking about how to start another process after all databases have been restored/loaded. You can configure a stored procedure to be called u …
- 629
1
vote
Accepted
Cursors and concurrent users
So this was an oddity and I have yet to get down to the nuts and bolts. In a nutshell I enabled MARS on sql server connections a while back to fix an issue I was having with IoC container connections. …
- 629
1
vote
1
answer
1k
views
Cursors and concurrent users
I typically avoid cursor operations like the plaque, however, I have come across my first problem where using a cursor outperforms a query. So I am forced to use it.
I have created an elaborate repor …
- 629
2
votes
1
answer
527
views
Sql Server And Very Hot CPU % of Total Wait Time
I have recently started monitoring a production database with transactional replication. The CPU % of Total Wait time = %93.00.
This is horrible. I confirmed all 8 processors are being utilized. This …
- 629
0
votes
SQL Server Merge Replication Computed Column Conflict Resolution
One way to circumvent this is to script and apply all objects needed to satisfy the expression to the target prior to a snapshot. The bulk copy likely fails because attempts to insert computed columns …
- 629
20
votes
2
answers
45k
views
Sql Server - Best Practices for Growing Database Files
I have been monitoring file growth via the data collector in sql server 2008 r2 for two weeks. The database is growing consistently at around 35(MB)/Day. The DB has not yet hit the initial size of 2 G …
- 629