If you know how many 100-nanosecond intervals (ticks) are in a day (864000000000) and how many days difference there are between 1-1-1601 and 1-1-1900 which is SQL Servers base date...

Well, I don't know how big your spreadsheets are, so don't know what the performance will be like for you with this, but how about you have two Excel Source...

Microsoft call this a newsletter-style report. It only works for me when I export the report to PDF. The report rendered in my browser still has only one...

In that case I'd go with the suggestion from "DBA From The Cold" and look into the sys.sysdatabases table for new databases based on the crdate column with a SQL...

Hadrian, do you want to backup the new database immediately after it is created? If so, why? Or do you want to add it to the list of databases to...

Hi Peter,

As you are already truncating the tables with the blob data in, is it possible you could try dropping the tables instead? You could then run the shrink...

Hi Bobby,

You can do this using the String functions in T-SQL, specifically SUBSTRING and CHARINDEX. There are some links below to msdn that will get you started.

String Functions

http://msdn.microsoft.com/en-us/library/ms181984%28v=sql.90%29.aspx

SUBSTRING

http://msdn.microsoft.com/en-us/library/ms187748%28v=sql.90%29.aspx

CHARINDEX

http://msdn.microsoft.com/en-us/library/ms186323%28v=sql.90%29.aspx

I guess this question if trying to show us that from a peformance point of view it is better to use the IF EXISTS statement to check for a rows...

Do you use a SAN to provide storage to the SQL server? If so there may be something you can do at that level to get a copy of the...

I've seen a lot of places use Active Directory Groups to control access to SQL Server, with a group for the DBA team which has been granted sys admin.

One thing...

I have got this to work by setting the visibility on a textbox component on my report which is used to show a total for the column, using an expression...

You said in an earlier post that you re-created the key. How did you do that? If you dropped the key then I suspect that is why you...

If you want overwrite the existing file with the changes to the column name then yes you do.

Have you tried renaming the column in the Flat File Connection Manager Editor? Select Advanced and then the column and then you can change the name.

Top of my list is GROUP_CONCAT, closely followed by REPLACE with wildcards.