Viewing 12 posts - 1 through 12 (of 12 total)
GilaMonster (12/13/2015)
https://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspxhttp://dba.stackexchange.com/questions/28801/sql-server-ntfs-allocation-unit-size
Bear in mind that changing the size means repartitioning the drives, so that's a re-partition, re-format and reinstall. Downtime could be nasty.
Thank a lot Gail. Think we have to...
December 15, 2015 at 1:35 pm
Thanks Gail.. Even i feel the same.
Found this code in one of the jobs
declare @a varchar(8000);
set @a;exec(@a);
November 23, 2015 at 5:37 am
anthony.green (11/23/2015)
November 23, 2015 at 5:28 am
Thanks Guys.
Found below link which is much more simple to understand i feel.:unsure:
November 16, 2015 at 10:38 pm
Thanks a lot Justin.
The sp_ForceFullBackup stored procedure in the BizTalkMgmtDb database can be used to help perform an ad-hoc full backup of the data and log files. The stored procedure...
November 16, 2015 at 1:42 am
Perry Whittle (11/13/2015)
David Rich (11/12/2015)
November 13, 2015 at 10:56 pm
It grew over time or all of a sudden?
Did you check open transactions?
November 7, 2015 at 4:30 am
Thanks for the quick response. You are right the page count is 1 for all of them
November 4, 2015 at 4:16 am
Viewing 12 posts - 1 through 12 (of 12 total)