bcp AdventureWorks.production.Product out c:\temp\product.dmp -n -S. -T

The above command copies the table "Production.product" from database AdventureWorks in the native file c:\temp\product.dmp.

Other than SSIS, you could use BCP with the native format.

The important thing is that the datetime column stores the right value.

To change the way it displays on the report, try changing the report field.

I would check the execution plan on the Oracle side and see if some index can support this query.

The format can be applied to strings only, not to datetime fields.

Try using CONVERT(varchar(50), someDateTimeExpression, 104).

Be aware that formatting dates is something that belongs to the presentation layer and should...

Functions cannot be recompiled, because their plans are not cached.

The statements that call the functions can get cached, but not the function's plan itself.

Use a split function: http://www.sqlservercentral.com/articles/Tally+Table/72993/

The ON UPDATE clause is a proprietary MySQL syntax to automatically update a column to the current timestamp whenever the row is updated.

You can do that in SQLServer with a...

I don't think this will get too slow, even on a big input.

Anyway, I can't think of any other efficient way to generate that prefix.

While I heartedly agree with every word Johan wrote, let's see if this can get you started:

DECLARE @results TABLE (

TABLE_NAME sysname,

TOTAL_COUNT int,

COLUMN_NAME sysname,

DISTINCT_COUNT int

);

INSERT @results

EXEC sp_MsForEachTable '

DECLARE @q...

Welsh Corgi (3/5/2012)

---

Rather than perform several SELECT DISTINCT to identify what combination of columns it takes to define the natural candidate composite primary key on over a hunded tables I...

This means that your instance is using all the memory you reserved to it.

Target server memory = Total amount of memory in KB that the server can consume.

Total server memory...

Not sure what you would like the script to do.

All columns that contain unique values?

All columns in UNIQUE indexes?

Can you clarify please?

1) Depends on what you want to...

There's no problem, you can do it.

What exactly would you like to know?