Primary Key and Paritition Key can be independent,...

Good. Now you have a case for table partitioning.

Planning on archiving the data based on a particular...

Error Message reads:

The column sql_text cannot be used. The raw adapters do not support image, text, or ntext data.

Marius.D (2/8/2013)

---

I'm using this script to look at recommended indexes:

SELECT

migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure,

'CREATE INDEX [IX_' + CONVERT...

SQL_Surfer (2/8/2013)

---

I am kind of new in Table Partition. We have a huge table that we would like to do partiion on. My question is how many columns you can...

nick.mcdermaid (9/20/2012)

---

In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a dogs...

Kwisatz78 (2/8/2013)

---

Hi all

I have a table which contains login and logout times for a large set of users, and we are wanting to know how to code it to...

rs80 (2/8/2013)

---

Can a slowly changing dimension be used to insert/update records into a staging table? I haven't used that transformation before and from what I read it was more used...

If for some reason or company policy you are not able to link SQL Server table to your Access database then the solutions are:

1- Ask SQL Server developer to export...

Yes...

1- Gather business requirements.

2- Perform...

michal.giczewski (1/28/2013)

---

I was wondering if someone could point me in the right direction.

I need to gather information about different datasets used in different business areas: banking, insurances, online betting, sales,...

Thank you for the posting Andy. I'm sure it will help a number of people down the road, Thank you for sharing.

This certainly is a topic that exceeds...

I agree with Sean, this is not a task for an entry level person.

Building on his comment, ask whoever tasked you for the ER Model - if it exists it...

lewis.ray (1/29/2013)

---

I have an oracle linked table in an access 2007 database.

I created the linked table with an odbc.

when I run the following statement I get an error saying "sytax...