good question. but for the life of me, i cannot come up with a reason to use this (nor anyone else where I work)- anybody?

jg

I fondly remember those days when I would re-build indexes with my dad in the garage on saturday mornings...right after cartoons...

jg

This tool has come in handy for me a few times moving between 2005 SSRS servers. I don't recall using it to move from 2005 to 2008.

http://www.sqldbatips.com/showarticle.asp?ID=62

jg

Using NOT EXISTS in your WHERE clause might work...

SELECT ...

FROM A

WHERE NOT EXISTS (SELECT * FROM B WHERE A.ID=B.ID and B.DATE IS NULL)

jg

This link has a good chart of all of the Formatting options:

Take a look at H vs h for 24 vs 12 hour time representation

jg

I agree that usability is most important, but so many developers I've worked with do not think performance is an attribute of usability. They believe it is a totally...

It might have to do with the fact that the trigger is acting on a large batch of rows, so the check is against existing rows, but if there are...

If you do some research into B-tree's you will find that not every distinct key value exists in the index levels - except at the leaf page level. If...

Thanks Andy, I've tried that. Still receive the same error message:

Description: The package path referenced an object that cannot be found: "\Package.Configurations[TestSetConfig].Properties[ConfigurationString]". This occur

s when an...

The dtexec doc states the following:

You can use the /Set option to change the location from which package configurations are loaded. However, you cannot use the /Set option to override...

The CTE "belongs" to the query, not the session.

IOW, if you want to persist it for the entire session you will not be able to use a CTE - you...

I doubt whether a complete article is needed for SSIS. The connection managers for Excel and flat files presents a check box to determine whether you want the first...

Could you setup a SQL Agent Job to run the package, and then use sp_start_job ?

jg

The thought behind the sample query is to have one table of exactly 17 rows, then LEFT OUTER JOIN to the report detail rows. That will result in exactly...

oops...I did not notice this was in the SQL Newbies section. My bad. I would not have just thrown code your way.

If you would like an explanation of...