Viewing 15 posts - 44,641 through 44,655 (of 49,571 total)
Well, if the log reader's missing/deleted that would explain the problem with the log. It's definitely a transactional replication, not snapshot.
Can see that from the Replication Type column in...
September 9, 2008 at 6:17 am
That's not what I'm talking about. I'm asking if getting your hands on the answer sheet for the upcoming exam that contains the questions that you know will be asked...
September 9, 2008 at 2:45 am
You have transactional replication there, not snapshot. Check that the log reader agent is running.
It should be a job, you should also be able to see it from enterprise...
September 9, 2008 at 2:31 am
Do you have regular log backups running?
See - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
September 9, 2008 at 2:24 am
Probably because of the affect they have on queries. Bad cardinality = bad query plans = higher than expected IO and CPU.
September 9, 2008 at 1:44 am
Tomm Carr (9/8/2008)
September 9, 2008 at 1:35 am
So, if you obtained the question and answer sheets for an upcoming college/university exam and used those to prep for the exam, would that be cheating, or smart work?
September 9, 2008 at 1:30 am
Please don't cross post. It jsut wastes people's time and fragments replies. Many of us read all the forums
No replies to this thread please. Direct replies to:
September 8, 2008 at 10:58 am
Check the windows event log, see if you have any drive errors. SQL doesn't corrupt its own files.
If the problem keeps reoccurring, I would suggest you move the DB...
September 8, 2008 at 10:53 am
SQL should run under a non-administrative account. It's a security best practice.
Create a domain account for SQL. I would suggest that you se the domain account so that it does...
September 8, 2008 at 9:11 am
GSquared (9/5/2008)
September 8, 2008 at 8:43 am
If there's no chance of overlap (which sound like there isn't in this case), that should be union all. Union means that SQL will do a distinct sort of the...
September 8, 2008 at 8:41 am
You can write your stored procedures so that they reference tables in both databases. Or, if the developers are beiong lazy and writing ad-hoc SQL code, they can use 3-part...
September 8, 2008 at 8:36 am
Because an order by is only valid in the outermost select statement. It can be used within other blocks, but then must be a part of a TOP n, where...
September 8, 2008 at 8:31 am
Viewing 15 posts - 44,641 through 44,655 (of 49,571 total)