Read Books and CBT nuggets and training videos and all stuff are available on the internet free of cost

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE...

I am shocked because you dont know about how to generate T-SQL script from SSIS for the maintenance

Again, why? What's a USB...

Check the path and permission on the service account which one is using for SQL Server

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

execute .exe files as an Administrator ,if this windows 7 or windows Server 2008

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My...

your database files structure,how many file groups and files places on different physical drives or simple on different partition,tempdb database place,how many files in tempdb database

How much filfactor have you...

SELECT ST.TEXT,SP.* FROM SYS.SYSPROCESSES SP

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST

WHERE SP.STATUS != 'SLEEPING'

ORDER BY SP.CPU DESC

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Total Processors

Total RAM

Total Drives not partition

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

http://msdn.microsoft.com/en-us/library/ms366348.aspx

http://msdn.microsoft.com/en-us/library/ms130822.aspx

Have you applied Service Pack 2 if this SQL Server 2008 or CU6 if this SQL Server 2008 R2,what is the server configuration

Total Physical Processors

Total Logical Processors

Total RAM

Number of Physical...

if you split tables on the same disk but different file group and data on the tables are huge then you should increase the performance and you can increase more...

First install Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

First thing is you cant delete primary file and Second thing is organize the database with

USE [database name]

GO

DBCC SHRINKDATABASE(N'Database Name', 1 )

GO

It will works for all data files and...

first thing is to create script of index rebuilding from SSIS and execute 5 to 15 indexes at a time as your space and execute log backup and then log...

Use multiple Service Accounts

Different Account for DB Engine or Instance

Different Account for Agent Job

and so on

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP |...

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 |...