I use Glenn Berry's scripts to find missing indexes (along with a lot of other great information). In his script he is already doing something similar to what you are...

Does the table(s) in question have a surrogate key (i.e. identity column or something)? If so use your date query but add a statement to get anything that is greater...

Have you verified that you are not running into a stop word issue? Try setting the index on the table to ignore all stop words (including the system default ones):

ALTER...

Actually RCSI is the "big...

There isn't a lot to go on here. If you could share some more information like: How large are the tables in question (both size and number of rows)? Are...

Take a look at this blog post:

http://consultingblogs.emc.com/jamiethomson/archive/2005/03/19/SSIS_3A00_-Evaluating-variables-as-expressions.aspx

It explains how to set variables using expressions.

Using a ForEach File loop on your folder you can set the filename as a parameter. Once inside the container set two variables using SSIS expression (date and file name)...

Using a ForEach File loop on your folder you can set the filename as a parameter. Once inside the container set two variables using SSIS expression (date and file name)...

This would be very easy to do in SSIS. Is that possible? or does it have to be done with a stored procedure or T-SQL code outside of SSIS?

you can seperate CTEs by using a comma i.e.

WITH cte_name AS (select 1 col1),

cte_name_2 as (select 2 col2)

select * from cte_name

union all

select * from cte_name_2

Service broker could be used to accomplish this. Read this article and maybe you could adapt your system to using this method.

http://rusanu.com/2009/08/05/asynchronous-procedure-execution/

You could create a date table/CTE and join every day to the msdb..backupset table on the backup_finish_date to make sure that a backup (of whatever type you choose) was taken...

This will depend on the number of levels you want to go with this, but this should accomplish what you wanted:

CASE

when PATINDEX('%Z%',EmployeeCode) > 0 then REPLICATE('A',PATINDEX('%[0-9]%',EmployeeCode)) + SUBSTRING(EMPLOYEECODE,PATINDEX('%[0-9]%',EmployeeCode),99)...

Solved my own issue. Under disconnected edit I went to the connections and opened the Text File (Destination) connection, opened the OLE DB Properties, and edited the Column Lengths -...

Hi Joe,

I check the recovery interval and it is still set to 0. I changed the value to 32,767 to see how that would affect performance and the issue was...