http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

SSIS Package in SQL Server Agent Job Fails

Error:

Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

Solution:

If your SQL Server is 64...

Simple script to find SQL Server agent job running at this moment.

exec msdb.dbo.sp_help_job @execution_status=1

http://www.sqlserverbox.com/sql-server-agent-job-running-at-this-instant.html

http://sqlism.blogspot.com/2015/04/sql-server-agent-job-running-at-this.html

Thank u so much

I also did it with RIGHT FUNCTION

SELECT substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),5,4)+substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),1,2)+

substring(RIGHT('00000000' + CAST([END DATE] AS VARCHAR), 8),3,2) from...

http://sqlism.blogspot.com/2014/10/a-database-snapshot-cannot-be-created.html

Sometimes an issue arises when the hidden database snapshot runs out of space. Because it’s implemented using alternate streams of the existing data files, the database snapshot consumes space from...

During DBCC CHECKDB, If the database being checked has a heavy update workload, more and more pages are pushed into the database snapshot, causing it to grow.In a situation where...

During DBCC CHECKDB, If the database being checked has a heavy update workload, more and more pages are pushed into the database snapshot, causing it to grow.In a situation where...

Identify the SQL passwords that are not enforced by policies

SELECT NAME

,is_disabled

FROM sys.sql_logins

WHERE is_policy_checked = 0

ORDER BY NAME;

All the logins listed in the output might have a weak password.

Enforce...

Thanks for correcting me Sean

Try this link

http://sqlism.blogspot.com/2014/09/script-to-delete-millions-of-records.html

Delete records without increasing your log space

------------------------------------------------------------------

DECLARE @continue INT

DECLARE @rowcount INT

SET @continue = 1

WHILE @continue = 1

BEGIN

PRINT GETDATE()

SET...

Try this link

http://sqlism.blogspot.com/2014/09/script-to-load-sql-profiler-trace-file.html

Try this

http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

Creating database roles and server roles have no impact on performance.

Refer

http://sqlism.blogspot.com/2014/09/upgrading-integration-services-in-sql.html

or

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

Restoring Orphaned MDF File in SQL Server

http://www.sqlserverbox.com/restoring-orphaned-mdf-file-in-sql-server.html

http://sqlism.blogspot.com/2014/09/restoring-orphaned-mdf-file-in-sql.html

Check this link

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html