Maybe one of Jacob Sebastians Blogs can help.

However, I have no idea what the performance counters will display...

But I have not seen any equivalent XQuery solution yet.

If you can't run any .exe file to install the software, chances are close to zero to find any free tool.

The main reason: almost anybody nowadays requires a single-click install....

If you "just" want to copy data, I would recommend to use bcp and generate files. Then use some MySQL tools to get the data back in (those tools exist,...

Any chance to post a sample or two and your expected output?

You could also drop me a PM / email if you like.

The data type issue is definitely something a...

I try to differentiate between the people posting for a hint or advice because they're stuck and the ones with the attitude of "Do my (paid) job! Now!".

Once in a...

You might want to ask this question in a PowerPivot forum.

From my point of view SQL Server only serves as a data provider.

Let's assume the ToolID is the identity column of a Tools table. Then there also should be a description or name.

Instead of using the db internal ToolID directly, I would...

R.P.Rozema (8/24/2011)

---

Attributes can be found using @*. So the names of these attributes can be found like this:

declare @xml xml;

select @xml = N'

<root>

<node attr1="1" attr2="2"/>

...

In order to know the daet range we'll need a start date.

The end date can either be limited by the number of rows, an additional date parameter or by limiting...

Jeff,

here are some additional sources you might want to have a look at:

Peso@SSC -> a similar approach like the one R.P.Rozema suggested and

Jason Follas blog. Jasons approach is based on...

Without seeing the query it's hard to tell.

I think there's...

Please have a look at the CrossTab article referenced in my signature. It's most probably exactly what you're looking for.

As a side note: If you know the data of each...

As long as you're not allowed to index this column, almost every approach will take a significant amount of time since you'll need to perform a table scan (or clustered...

I just had a glance at the first one. The job description sounds like asking for a complete dev team including the backbone DBA staff. Not to forget the customer...

What do you define as "being referenced"?

If you'ro looking for the refernces assigned by using foreign keys, you could look at sys.foreign_key_columns.

Other than that you'd need to analyze each object...