• Run Oracle Procedure in SSRS dataset

    Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

    redusn19505 pointsBadges:
  • High usage of SQL Server

    The SQL Server usage becomes high....How do I reduce the usage of SQL Server? The system performance becomes slow.

    senmalar210 pointsBadges:
  • Network & server issues

    We are a retail company dealing with textile , retail business. We have about 4 branches within the span of around 250 to 300 kms from our main office. In a branch we have about 60-70 computers with thin clients operating with the help of IBM BLADE server. Total, we have about 250-270 computers...

    omegaserver5 pointsBadges:
  • Attaching AdventureWorks database To SQL Server 2005 SP1

    How can I get the AdventureWorks database for SQL Server 2005 SP1??

    Never5 pointsBadges:
  • encryting output file from BCP

    I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party...

    jswayne19645 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:
  • How to make fast indexing and flat text search in SQL database

    Our objective is to achieving good speed with Full-Text Search on an MS-SQL/2008, using Sphinx DB Indexing and text search engine. Our challenge: can we reach speeds better than 3 sec/per simple term search on a DB containing about 2GB of data / 200+ tables with complex permission system...

    Eid24305 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:
  • Changing web server can access back office app through local host but not when it is on DMZ

    We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into our database. All the ports that...

    Elziz15 pointsBadges:
  • SQL query

    I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y....and so on....

    hengameh5 pointsBadges:
  • Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • Supression by date and field data

    I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime...

    KMarie15 pointsBadges:
  • Importing data into SQL server from Intersystem Cache Database

    I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance

    nagakrishna5 pointsBadges:
  • SQL Authenticated user change his/her own password

    We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Authenticated logins and passwords have been created for each user on the SQL Server, these logins have been granted access to the SQL Server database. When creating the logins: Enforce password policy,...

    TLMercer45 pointsBadges:
  • Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?

    Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 is running slow

    SQL server 2005 is running very very slow while it has 32 GB ram 200 GB SAN and 4 Processor of Xneon 566 GHZ. The normal select query takes 30-35 seconds to returning 37 records. Please give me the suggestion how to increase the performance

    Biru25 pointsBadges:
  • SQL or T-SQL

    This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.

    BJ20125 pointsBadges:
  • Can any one post IKM online test questions (SQL Server 2008) please?

    IKM online test questions SQL Server 2008.

    IKMsql1235 pointsBadges:
  • Concatonating year using date parameter with extract function

    I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, 'DD-MM-YYYY'))) || '-' || substr(extract(year FROM...

    tmbdnelson70 pointsBadges:
  • Sharepoint 3.0 website no longer working after Windows updates installed

    We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error :...

    PPitcher85 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