• Open IT Forum: Security Worst-Cases

    Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the...

    MelanieYarbrough6,345 pointsBadges:
  • Thousands and thousands of simultaneous users hitting a sproc — what do you do?

    folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for a bunch...

    Oscarius5 pointsBadges:
  • Oracle 10g terminated_with_error

    while iam running a 10g report using the following code : declare   repid REPORT_OBJECT;   v_rep VARCHAR2(100);   rep_status VARCHAR2(50);  BEGIN   repid := FIND_REPORT_OBJECT('REPORT1');   SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');...

    K197070 pointsBadges:
  • SSRS Report switch for Operational DB to DWH

    We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed data in...

    An2795055 pointsBadges:
  • Contest Bounties: Last chance to win an iPad!

    The end of the iPad contest is drawing near - next Wednesday, February 16th to be exact - and we want to see more of you in the final drawing. In order to help push you over the 500 knowledge point requirement, we assembled some last chance bounties to get you in the running: 1. Tweet about...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server 2005 permissions required by public

    Our security madates that ALL object permissions be removed from"public". After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?

    VelameLaCosa110 pointsBadges:
  • Would like to learn SQL. Which vendor should I go for and what certification should I get?

    Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly. cheers! Jeevan

    Jeevan231015 pointsBadges:
  • SQL Server 2005 Reporting Services Move

    I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?

    Rick Martinez585 pointsBadges:
  • un-format object viewer sql tab

    Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer's SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

  • optimization of stored procedures in sqlserver

    is there any stored procedure optimization techniques actually my problem is my stored procedure is getting information from 15 tables by joins and have some conditions in where clause to get 15,000 records it is taking 40 sec how can i improve the my stored procedure thanks, naresh

    Naresh12265 pointsBadges:
  • Complex SQL query in SQL Server 2008 tables

    Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

    Itoracle5 pointsBadges:
  • SQL server 2005 vs. SQL server 2008

    What is the benefits of SQL server 2008 over 2005 (version 3.5 over 2.0)?

    Ryzawack15 pointsBadges:
  • SQL Server 2005 database installation

    i installed sql2005 s/w in my system.but i don't know how to use it.i don't know how to create database and manage and all.can u help me?

    Saranya885 pointsBadges:
  • Free IT Book: Drupal’s Building Blocks

    Today's free IT book is an essential addition to any developer's library: Drupal's Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server 2005 login error

    I am not able to login in SQL SERVER 2005, I am getting error message"The connection was succesfully established with server, but then an error occur during pre-login handshake.(provider:SSL provider error:0- The certificate chain was issued by an authority that is not trusted.)(Microsoft sql...

    Servernetwrkdbase60 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • Log on error Oracle enterprise manager

    i can log on sqlplus useing : sqlplus "sys/oracle as sysdba" but on em log on: user : sys password : oracle give me error msg "invalid passowrd"

    Tota10 pointsBadges:
  • Can I install SQL Server 2005 32 bit on 64 bit OS?

    can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?

    Siddiquiali15 pointsBadges:
  • Running scripts in SQL Server 2005

    How can I run scripts in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing a chat using SQLServer Service Broker – how good an idea it is?

    We are designing a chat engine. That's basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session...

    Marcofaustinelli5 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