Viewing 15 posts - 45,826 through 45,840 (of 49,571 total)
It checks the integrity of your database to ensure you have no corruption present.
CheckDB includes all the checks done by checkAlloc, so it's not necessary to run both.
July 10, 2008 at 4:16 am
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic531452-148-1.aspx
July 10, 2008 at 4:14 am
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic531452-148-1.aspx
July 10, 2008 at 4:14 am
Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic531452-148-1.aspx
July 10, 2008 at 4:13 am
Satya_skj (7/10/2008)
... unless there is a huge problem of disk storage free space.
In which case you get more disks. It's not as if storage is that expensive these days.
Shrinking is...
July 10, 2008 at 4:08 am
You'll find a few tools to decrypt if you use google. I don't have the links handy. I don't recall any of them been free.
July 10, 2008 at 12:29 am
If 030 is the name of the database, it needs to be in square brackets - [030]
That said, why are you truncating your logs? If you don't care about point-in-time...
July 10, 2008 at 12:26 am
Vijaya Kadiyala (7/9/2008)
Hi,Can any one give some simulation lins on this exam.
Thanks -- Vj
Asking for or using braindumps is against the rules of the exam and can get you certifications...
July 10, 2008 at 12:21 am
Triggers fire once per insert/update/delete, not once per row. Your line here
select @stokkod=stokkod,@quantity=quantity from deleted
Will fetch only one of the values from the deleted table, while there are as many...
July 10, 2008 at 12:19 am
Mani Singh (7/9/2008)
So you should consider running REINDEX after you shrink operations.
You shouldn't be shrinking your databases in the first place.
July 10, 2008 at 12:16 am
Ouch. Not a good layout.
The thing is, C, D, E are logical splits. They're the same physical devices and it means that IOs occuring on the swap file will impact...
July 10, 2008 at 12:08 am
The entire Inside SQL Server series is excellent. There are four books - the storage engine, T-SQL querying, T-SQL procgramming and Query tuning and optimisation.
The other one I'll recomend...
July 10, 2008 at 12:03 am
er.kalidass (7/9/2008)
Hi guysTry with snapshot isolation levels. it will reduce the db blocking Massively .
Agreed, snapshot isolation will completely prevent...
July 9, 2008 at 11:57 pm
CarlosHawes (7/9/2008)
July 9, 2008 at 11:52 pm
terry.jago (7/9/2008)
July 9, 2008 at 11:47 pm
Viewing 15 posts - 45,826 through 45,840 (of 49,571 total)