Viewing 15 posts - 36,151 through 36,165 (of 49,562 total)
omkarred (10/26/2009)
please elaborate on the clustered & non clustered indexes & implementation of it in actual db
That's what parts 2 and 3 cover.
October 26, 2009 at 3:56 am
arun.sas (10/26/2009)
Exec Get_Name 'Usa'Select @@rowcount
Ensure that, your procedure should not having/use of
SET NOCOUNT ON/OFF.
The setting of NoCount has no effect on @@RowCount. Setting NoCount on simply prevents SQL from...
October 26, 2009 at 3:13 am
Jeff Moden (10/25/2009)
Oh... be careful, Johan... XML splits are relatively slow compared to many other methods.
Plus the OP indicated he was still on SQL 2000 (despite posting in...
October 26, 2009 at 2:09 am
select *
from msdb.dbo.backupset bs
inner join msdb.dbo.backupfile bf on bs.backup_set_id = bf.backup_set_id
October 26, 2009 at 2:06 am
Jeff Moden (10/25/2009)
October 26, 2009 at 1:56 am
No. Plans are memory only and are not included in a database backup.
October 26, 2009 at 1:54 am
repent_kog_is_near (10/25/2009)
Although they are not the same, the end result of Rebuild also accomplishes (or includes) what is done through a reorg (rearranging leaf level pages), right?
Both will fix the...
October 26, 2009 at 1:54 am
ianwilson91 (10/25/2009)
October 25, 2009 at 3:35 pm
UtterSQLNewb (10/24/2009)
The .bak file was 59MB but the .trn file was 188MB ( a massive increase over the first one).
Because you didn't take log backups.
Please read through this...
October 25, 2009 at 3:18 am
Technically no, but understand what the two do.
Reorg shuffles the pages at the leaf level of an index back into order. It doesn't touch the non-leaf levels and it doesn't...
October 25, 2009 at 3:00 am
ravikanth. (10/24/2009)
3)DBCC FREEPROCCACHE to clear out old query plans.
Completely unnecessary. Plans are memory-only and don't survive a restart of the instance or a detach of the database. There's no way...
October 25, 2009 at 2:59 am
mahesh.vsp (10/24/2009)
What is the use of the belowChange the database's page verify to Checksum
SQL 2000 only had the option to use torn page verification. Checksum, new in 2005, picks up...
October 24, 2009 at 2:01 pm
Couple more things
After upgrading to SQL 2005/2008, do the following:
Change the database's page verify to Checksum
Run a checkDB with the Data Purity option
rebuild all indexes
update all column statistics with fullscan.
October 24, 2009 at 1:27 pm
homebrew01 (10/24/2009)
However, if there were specific permissions on the table, they do not get recreated. How can I script them out ?
Not sure if there's a way from the GUI,...
October 24, 2009 at 11:39 am
Viewing 15 posts - 36,151 through 36,165 (of 49,562 total)