Viewing 15 posts - 42,136 through 42,150 (of 49,562 total)
Lots more. See - http://www.microsoft.com/learning/mcp/certifications.mspx
December 27, 2008 at 3:27 am
Reindexing is not going to fix this. There's corruption in the data pages (index id 0). If it was only in the nonclustered indexes (index id 2 and higher) then...
December 27, 2008 at 3:23 am
jananik (12/27/2008)
But I think I had taken the backup in a single destination only.
Did you backup using the management studio gui? If there were two files listed in the...
December 27, 2008 at 3:10 am
I posted a link to a doc about tran log management earlier in the thread.
GilaMonster (12/22/2008)
Take a read through this - http://www.sqlservercentral.com/articles/64582/
December 27, 2008 at 3:01 am
You're pulling the entire of two tables, amounting to a total of 15 million rows. That's never going to be quick and there's no way indexes are going to help...
December 27, 2008 at 3:01 am
GilaMonster (12/23/2008)
Have you looked through Books Online, specifically the sections on SSIS?
December 27, 2008 at 2:57 am
Paresh Prajapati (12/26/2008)
Take transaction log backup of database and apply on that server with recovery.
How's that going to help with creating a second copy of an in-recovery database without breaking...
December 27, 2008 at 2:55 am
Pavas Malviya (12/26/2008)
c++ is bad. But good at c#
But you can't write extended procs (as far as I know) in C#.
December 27, 2008 at 2:53 am
leonp (12/24/2008)
We have perfmon running for 3 hours; thrice a day. Sampling once every 75 seconds. Is that a bad thing?
Not perfmon. Profiler.
Select * for the reader (which the...
December 24, 2008 at 7:34 am
Michael Earl (12/24/2008)
At least they were able to open Management Studio and run the query.
Well there was this one guy (who claimed to be a performance tuning guru and have...
December 24, 2008 at 7:33 am
Michael Earl (12/24/2008)
December 24, 2008 at 5:46 am
Where CancelFlag = 0
A bit holds values of 1 or 0. By convention, 0 is false and 1 is true, though there's nothing in SQL that enforces that.
December 24, 2008 at 3:04 am
Doesn't look like memory bottleneck either.
If the app's inserting a lot of new data, then the PLE will be low because new data's constantly coming in.
Do you have SQL profiler...
December 24, 2008 at 1:44 am
jasmineywchen (12/23/2008)
My questions and concerns are:1. When the base tables are being written, is it going to lock the tables causing the view to timeout??
Probably not the entire table,...
December 24, 2008 at 1:25 am
SQLBill (12/23/2008)
December 24, 2008 at 1:14 am
Viewing 15 posts - 42,136 through 42,150 (of 49,562 total)