I just have a question about this also, what if I have 10 or more different tools, so it will be a union of ten tables? Will my query be...

From what I could gather from reading your question, you need to have following tables:

1) Table to store all the tool information.

2) Borrower table.

3) Lookup table(s).

4) Transaction table with ToolID...

First define a variable of string type and create your OLEDB Source query using expression and assign it to this new variable.

Next go to the OLDEDB Source component and use...

Right, but this was supposed to be an simple question, isn't it? My point was if it was simple then they should have had no difficulty answering this.

Amol

"How do you move a table to a different filegroup" is not a simple question, some of the senior DBA's that i have interviewed couldn't answer this question 🙂

Amol

We moved the data and log files back to where they were originally and the Job behaviour returned to normal and completed like it did before we moved around the...

My favorite question is "How would you troubleshoot a slow running query?" and i get surprized by the replies given by the DBA candidates. They go to the extent of...

It doesn't use any blobs. The tables are indexed, as i mentioned in my initial post, we did perform a index rebuild.

Looking at the perf counters did not give us...

Piotr,

What do you mean by temporary files? ETL is implemented using SSIS and the packages are running on a separate server.

Thanks,

Amol

I figured out the query myself.

SELECT O.[name],[data_compression_desc], [partition_id]

FROM sys.partitions P (NOLOCK)

INNER JOIN sys.objects O (NOLOCK)

ON O.Object_id = P.object_ID

WHERE data_compression > 0

I agree with cengland0.

Thanks, but there is no re-index job occuring at the time job is running. By the way our ETL job ran quicker today in just 3 hours. There was some...

Few years back when i was working on SQL Server 2000, i had a client requirement to import EDI files into our database, i had then used ActiveX vbscript wihtin...

Check how many pages the table has used. The table in question might have fewer data pages. If there are fewer pages SQL Server does not consider this to be...

I said 40K per year and NOT month. Yes, if you want to live like a king then you need that amount or even more in India now.