Viewing 15 posts - 44,926 through 44,940 (of 49,571 total)
Do you need redundancy on the drives? (ie, if a drive fails must the system continue working)?
If so, your best option is 3 RAID 1 (mirrored) arrays. It may not...
August 21, 2008 at 10:37 am
You may be better off monitoring that via perfmon. The os_performance_counters in the table version of all the counters that SQL Server exposes to perfmon. The counters are better explained...
August 21, 2008 at 7:33 am
Gut feel on this one it that (fk_websiteID, logdate) may be a good choice, though without seeing exec plans I can't say for sure.
Reason is that you say they are...
August 21, 2008 at 6:59 am
stephane3d (8/20/2008)
What's the golden rule of creating such clustered index for a log table?
In depends. < Ducks and runs >
Seriously, there aren't any hard and fast rules on...
August 21, 2008 at 6:51 am
Perry Whittle (8/21/2008)
GilaMonster (8/20/2008)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4.Gail i pointed this out already
I thought it...
August 21, 2008 at 6:50 am
Provided the database was shut down cleanly, that is.
August 21, 2008 at 6:46 am
The MCTS (technical specialist) certification is a requirement for the MCITP (IT Professional)
You can write the ITP exams without haivng the technical specialist cert, but you won't gain the certification...
August 21, 2008 at 6:21 am
Make sure you trace the StoredProcedure:StmtCompleted event and not the StoredProcedure:SPCompleted event.
If you trace the procedure completed, you won't see any inserts/updates within those procedures.
Also trace the T-SQL:Stmt completed to...
August 21, 2008 at 6:20 am
Some background info on what's happened - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
August 21, 2008 at 3:59 am
nikhil.verma (8/20/2008)
Thanks for ur Help!!!!!!!!But i have checked the link and couldnt find suitable info abt my prob .
The entire creation script for that stored proc is in...
August 21, 2008 at 3:48 am
823 is an IO error. It means that SQL asked for a page and the OS returned an error. It's a very serious condition and could indicate that you have...
August 21, 2008 at 3:41 am
thiyaga4u (8/20/2008)
Default bound to column.
That's not a warning, it's an informational message. Somewhere in your script you're either binding a default to a column (sp_binddefault) or you're using a user-defined...
August 21, 2008 at 2:15 am
onlo
How much longer will Microsoft support SQL 7.0 for?Do you have any ideal ?
Mainstream support for SQL 7 ended in 2005. Extended support will end in 2011.
Mainstream support for...
August 21, 2008 at 2:09 am
You should always set max memory on a 64 bit server. If you have 3 GB physical memory, set SQL's max to 2GB, no more.
August 21, 2008 at 1:55 am
Databases can't be primary. Files can be primary. Each database will (must) have a primary file.
What exactly are you trying to do and what errors are you getting?
August 21, 2008 at 1:43 am
Viewing 15 posts - 44,926 through 44,940 (of 49,571 total)