1
  • IBMDA400 Provider & SQL 2008 select statement issue

    Using IBMDA400 as a provider on SQL 2008 server then a link server object. In the studio when I ask it to create a select statement for a table the numeric columns are not included. I can do Select * and all fields are included and the query works fine or I can simply add the numeric fields to the...

    Peteakers45 pointsBadges:
  • Update duplicate records

    Before change: CLAIM_ID CR/RE   Internal TAT 11061488        Rebill 27 11061488        Credit  11061488 Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit            After change : CLAIM_ID CR/RE   Internal...

    SQLbamola5 pointsBadges:
  • Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan

    Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by.  The computed column is not persisted and there is a non-cluster index on it (the only index on the...

    Steve005 pointsBadges:
  • SQL Server Database Maintenance Performance and Hyperthreading

    I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that...

    Rick Martinez585 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

    I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

    ITKE828,960 pointsBadges:
  • SQL Server 2008: Difficulty setting mixed mode authentication password

    I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, "The...

    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.

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

Following