1
  • Looking for extended properties in SQL Server

    Where are extended properties located in an SQL server? Are they stored in the same database with the object with which it was added, or are they stored separately somewhere on the local machine?

    ITKE352,430 pointsBadges:
  • Composite vs Primary Key Storage in SQL

    How does a SQL Server store a composite primary key compared to a single primary key?

    ITKE352,430 pointsBadges:
  • SQL server storage for two Azure environments

    Hi I’m working with Azure in both a staging and production environment.  I need to deploy both blob and SQL storage for both environments.  What would be the best way to archive data?  I’m thinking the best way to do it, would be to set up an SQL server for staging and another one for...

    ITKE352,430 pointsBadges:
  • SQL Server Data Files

    I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

    Rick Martinez585 pointsBadges:
  • Estimate SQL Server tempdb space for a query

    Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...

    BR5 pointsBadges:
  • SQL Server 2008 Export data problem

    Hi I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty db on the local machine. Then I scripted the...

    Tsp196520 pointsBadges:
  • Storing large data files in SQL Server

    What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

    SQL Server Ask the Experts2,585 pointsBadges:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following