Have you actually run BIDS after changing that shortcut?

If so, try searching under your AppData folder for ActivityLog.xml , it may be in a different folder.

Right click on the BIDS icon (the one you usually left click to open BIDS) and choose properties.

In the "Target" text box, add a space and /log

So you get something...

try starting bids with the switch /log

This will write an activity log to (assuming standard installation of windows 7+) c:\users\your_login\AppData\Roaming\Microsoft\9.0

You can double click the ActivityLog.xml file (as long as there...

They are likely looking for more than one person and wanted to save time and effort on the job spec, so threw it all in there...

SQL_Surfer (4/24/2014)

---

Making column identity is an option that should have thought beforehand. If we go that route now, it can mess up reports and other files that we already sent...

Yes, it is hard coded for version 10+ of the database engine:

// Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.OpenTableHelperClass

public static DataTable GetColumnNames(Server server, Urn urn)

{

Request request = new Request();

if ([highlight="#ffff11"]server.Version.Major >= 10[/highlight] && !DatabaseEngineTypeExtension.IsMatrix(server.DatabaseEngineType))

{

request.Urn = string.Format("{0}/{1}",...

I understand now, thanks, but sorry I don't have an answer.

You can use the edit feature for sparse columns by manually adding the column names to the select statement, but...

Can you provide a screen shot or some sample data that displays the problem because I have no idea what you mean.

TSQL doesn't have an EDIT command, so your description...

First thing I see in the plan is Query 6 which shows up as 99% of the cost.

Within Query 6, there is a section that accounts for 96% of the...

Firstly, let me say that there are plenty of excellent women that use this site, so you may want to rethink the use of "Gents" as you are excluding half...

I realise I forgot to mention, the first method above (using the numeric lookup on the use_values table) worked in about 8 seconds on my PC with a ~700K target...

I would guess the first one is not performing well because of a lack of a clustered index on the "number" column?

Anyway, I hope you can find a good solution...

The problem I see with a truly random fill is that you need to select one value from 4000 for each of 700,000 source rows, so I can see two...

Yes, I can see that taking a long time as it is performing the outer apply ( selecting 1 from 4000 ) for each of the 700000 target rows.

I...

Like I said, I couldn't guarantee it, although on the test data you supplied, it worked for me where the other methods failed.

You definitely used an outer apply, and updated...