• Indexing Fact Tables for a data warehouse

    Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15...

    Garp0 pointsBadges:
  • Disaster Recovery

    How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup --please let me knw---

    Vaibhavmathur0 pointsBadges:
  • connecting VB2005 Express with remote msSQL2005 Express server

    I'm trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas

    Teqani0 pointsBadges:
  • Triggers in sql server 2005

    hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and...

    Kmm0 pointsBadges:
  • SQL 2005 Restore DB with Multiple files in Primary File group

    Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

    Leeland0 pointsBadges:
  • Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following