• SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • Optimizing a SQL Server stored procedure

    I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • Reading xml url into SQL Server 2008 Table with OpenXML

    I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table.  My...

    Rscheinberg595 pointsBadges:
  • Writing a query to store an image file in a SQL Server 2005 table

    How would I write a query to store an image file in a SQL Server 2005 table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Finding a table’s name from a trigger name in SQL Server

    How can I find the related table's name from just a trigger name?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2008 R2: User table with clustered indexes

    I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

    ITKE345,065 pointsBadges:
  • Deny domain administrators to select from sql server tables ( SQL server 2005)

    I have added the "domain admin" group to the Sql Server, and set permission as "Deny" to connect to the database engine. All employees of this group can still select from any table. The sql server "public" role does not have any permissions on any database table. The "domain admin " group has local...

    IgorS5 pointsBadges:
  • Loading an XML file’s dataset into an existing SQL Server 2005 table

    I have a dataset in an XML file that needs to load into an existing SQL Server 2005 table. It also needs to check existing rows before loading. What will be a good way to do that?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2008: INSERT statement

    One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

    ITKE345,065 pointsBadges:
  • Looking to create and populate a numbers table in SQL Server 2005

    Now in SQL Server 2005, I know there are different ways to create and populate a numbers table. But, what's the best way? I'm looking for the best way to optimize these characteristics:Table created with optimal indexingrows generated fastestsimple code used to create and populate

    ITKE345,065 pointsBadges:
  • How can we add a column (with a default value) to a table in SQL Server 2005?

    Our business is using an older version of SQL Server (2005 in fact) and all we're trying to do is add a column, with a default value, to an existing table. Can someone point us in the right direction?

    ITKE345,065 pointsBadges:
  • SQL Server 2008: Query for names

    Now in SQL Server 2008, is there a way that I can query for names in all tables that contain the column with name. Something along these lines:%myName%

    ITKE345,065 pointsBadges:
  • Auto-increment in SQL Server 2008 R2

    I've just created a new table in SQL Server 2008 R2 and I'm trying to get the index on auto-increment. Is there a way to do this?

    ITKE345,065 pointsBadges:
  • Encypting a customer table in SQL Server 2012

    I have a customer table with contains several columns (names, address and contact info). Now, there are over 15000 records so I'm trying to figure out if I should encrypt the entire table of just several specific columns. How can I do this on a production database? Thanks!

    ITKE345,065 pointsBadges:
  • Update from another table and multiple criteria

    update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID) The above does not work with the error Msg 4104, Level 16, State 1, Line 4 The multi-part identifier...

    MyDanes35 pointsBadges:
  • Exchange – extracting email properties

    Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account - I don't want the content of the emails - but what I want is emailID, subjsy, date received and it's current location (ie what folder is it in) in that email account. I need this...

    dragonsong15 pointsBadges:
  • Joining unmatched tables with duplicates

    Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get the...

    jruth1325 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Query

    how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select

    SDN15 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.

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