Viewing 15 posts - 44,281 through 44,295 (of 49,571 total)
Possibly that it's running as a parallel operation. If you could attach a pic of said operator, I can tell you for sure.
September 23, 2008 at 9:14 am
Ahmad Osama (9/23/2008)
Cath Trimble (9/23/2008)
September 23, 2008 at 9:03 am
You don't need to stop SQL and the agent after doing the alter (not for the user databases). Just take the database offline after doing the alter database, move the...
September 23, 2008 at 9:01 am
Most of that you can get by using sys.indexes instead of sysindexes. The row count you can get from sys.dm_db_index_physical_stats.
The one thing you won't be able using the DMVs is...
September 23, 2008 at 8:55 am
Alberto De Rossi (9/23/2008)
Nice article. Would you please briefly explain us how did you get the measures to do those graphics? Did you use profiler?
I ran the queries with...
September 23, 2008 at 8:45 am
Steve Jones - Editor (9/23/2008)
September 23, 2008 at 8:43 am
fjmorales (9/23/2008)
whow! Why its so dramatic the change?
No idea. I didn't investigate it. We created out own custom trace based on the audit requirements we were under and implemented that.
You...
September 23, 2008 at 8:28 am
Since a differential is essentially a "snapshot" of the data at the time is it necessary to retain all of the previous differentials?
It's not a snapshot of the data at...
September 23, 2008 at 8:26 am
465789psw (9/22/2008)
SQL will elect to one on its own in...
September 23, 2008 at 5:58 am
Andreas Berchtold (9/23/2008)
What I don't understand: Why more than 1 snapshot, isn't a snapshot "only" used to...
September 23, 2008 at 5:49 am
bhuvnesh.dogra (9/23/2008)
i know .....truncate cant be stopped by trigger 🙂 butcan we think beyond the available features of sql 2005
As a purely theoretical exercise?
is there any sys ...
September 23, 2008 at 5:46 am
Also read through the articles section here. Here are lots of very good info there.
September 23, 2008 at 5:38 am
Ahmad Osama (9/23/2008)
what if I dont have the tran log 1 backup
You'll only be able to restore to Diff2. Trying to apply Tran log backup 2 will give an error...
September 23, 2008 at 5:31 am
What is backup device 'dbpath'? Is there enough space on the disk?
If you're running in full recovery, you must run log backups. If you don't the log file will grow....
September 23, 2008 at 5:30 am
bhuvnesh.dogra (9/23/2008)
You can apply INSTEAD OF trigger FOR DELETE on that particular table
Won't help against truncates. Truncate doesn't fire triggers.
September 23, 2008 at 5:27 am
Viewing 15 posts - 44,281 through 44,295 (of 49,571 total)