Viewing 15 posts - 346 through 360 (of 492 total)
Did you dropped Clustered Index too ?
You can create all indexes script RIGHT CLICK on the a specific database and then check attachment for further steps
Regards,
Syed Jahanzaib Bin Hassan
MCTS |...
April 30, 2011 at 12:09 am
if you still want to use jobs to schedule scripts then use SQLCMD and Operating System schedule,make your script on SQLCMD and save as a batch file then schedule on...
April 29, 2011 at 11:56 pm
Backup file drive and Restore File Drive is same ?
what is the size of Backup file now ?
Is there any Load on Database at the time of Restore ?
Regards,
Syed Jahanzaib...
April 29, 2011 at 11:53 pm
Light weight pooling use when CPU usage is high and note it you cant use Linked Server connections if you will this pooling
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA...
April 29, 2011 at 11:36 pm
fragmentation percentage < 30 then ReOrganize
fragmentation percentage > 30 then Rebuild
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 1:16 pm
Common files are installed on disk where windows installed in the program files
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 1:12 pm
on which version you have created those SSIS packages
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 1:07 pm
http://msdn.microsoft.com/en-us/library/bb933944.aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 12:58 pm
What is ACTIVE / ACTIVE failover node,is there any thing providing by microsoft,according to my knowledge there is no any active/active failover node in SQL Server.
ACTIVE/ACTIVE means 2 separate instances...
April 29, 2011 at 11:37 am
Yes,because he doesnt mention how many files and he mentioned files are 5GB restricted growth its mean each file have restriction of 5GB ,database size is cumulative size of files...
April 29, 2011 at 11:14 am
Database filegroup and files structure is ?
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 10:28 am
This flag is use for large page allocation from 2 to 16 MB
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
April 29, 2011 at 10:23 am
How did you create resource pool, this will change where you create resource pools,that is Resource Governor
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP...
April 29, 2011 at 10:15 am
SELECT o.[name], o.[type], i.[name], i.[index_id], f.[name]
FROM sys.indexes i
INNER JOIN sys.filegroups f
ON i.data_space_id = f.data_space_id
INNER JOIN sys.all_objects o
ON i.[object_id] = o.[object_id]
WHERE i.data_space_id = f.data_space_id
AND o.type = 'U' -- User Created Tables
GO...
April 29, 2011 at 10:07 am
Max Memory Set
1024 MB
106 MB
53 MB
53 MB
106 MB
106 MB
53 MB
53 MB
532 MB
Used Memory
14 MB
68 MB
2.4 MB
check this information,you have to change these setting for default
Regards,
Syed Jahanzaib Bin Hassan
MCTS |...
April 29, 2011 at 12:22 am
Viewing 15 posts - 346 through 360 (of 492 total)