Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 3,061 total)

  • RE: OBIEE vs SSRS

    Deeps-965988 (4/21/2011)

    I got a reporting requirement in my project and OBIEEE was decided to be used as a standard reporting tool as compared to SSRS even though our database exists...

    April 23, 2011 at 6:55 am

    #1315125

  • RE: Performance on very large database - Help

    Oliiii (4/18/2011)

    You'll need an index on it since none of your current index fits (the second is filtered).

    Agreed. Please check execution plan, most likely you will see a full...

    April 18, 2011 at 4:15 pm

    #1313125

  • RE: Performance on very large database - Help

    aGuareschi (4/18/2011)

    select * from vipt_tab_003

    where pt03_annomese = 201001

    and pt03_r_abi = 'XXXXX'

    and pt03_num_eff = '569845456165748'

    What's the cardinality of this query? how many rows is it supposed to return?

    April 18, 2011 at 8:01 am

    #1312803

  • RE: SQL Database Artistructure

    satish.saidapur (4/16/2011)

    Some one asked me Sql Database Artistructure, could you please help me for how to explain & what are the things i explain?

    Is it "artistructure" or perhaps "architecture"?

    Assuming the...

    April 16, 2011 at 12:47 pm

    #1312456

  • RE: SUM and ROUND functions

    round() and cast() are different functions - check BOL.

    April 14, 2011 at 5:27 am

    #1311502

  • RE: Sql query on orcale DB error (literal does not match format string)

    quillis131 (4/6/2011)

    Table1 (column ADDEDDATE) is in the form

    10/1/2005 12:00:00 AM

    8/18/2007 12:00:00 AM

    What's the datatype of ADDED_DATE column? is it a DATE or a VARCHAR2 column?

    If ADDED_DATE is a...

    April 10, 2011 at 1:49 pm

    #1309621

  • RE: Export and Transaction Log

    Carol Adams (4/5/2011)

    There is a job running that does an INSERT of all rows from a view into a table.

    The transaction log is growing out of control because of this...

    April 5, 2011 at 11:02 am

    #1307590

  • RE: Mon-Thu group by

    Filter out unwanted days of the week on WHERE clause.

    Use GROUP BY to group by Class, Day-of-the-week.

    April 3, 2011 at 3:58 pm

    #1306833

  • RE: database design question

    Mazenx (3/19/2011)

    hello...I have a table called Images which has images data , now...I want to create another table to hold date for image thumbnails , I have four thumbnail sizes...

    March 20, 2011 at 8:44 am

    #1301033

  • RE: Normalization of existing database

    $QLdb@ (3/18/2011)

    I have a database of 6o GB which is not in normalized form

    what should be my steps to make it in normalized form

    database consist of 244 tables and 1...

    March 20, 2011 at 8:41 am

    #1301032

  • RE: sql question

    nagireddy0024 (3/19/2011)

    plz any one rply correct answer.

    Okay, here I go: "correct answer" 🙂

    March 20, 2011 at 8:32 am

    #1301030

  • RE: not able to use xp_cmdshell...

    DZN (3/14/2011)

    so how to implement ? What's the solution ?

    Make master your current database.

    March 14, 2011 at 2:20 pm

    #1298568

  • RE: Dynamic SQL is getting executed faster than in a Stored Procedure

    mymail.default (3/14/2011)

    I did, and that's why I put the statistics for IO from the exec plans.

    Same execution plan against same tables in same database can't show such a different I/O...

    March 14, 2011 at 12:46 pm

    #1298530

  • RE: Dynamic SQL is getting executed faster than in a Stored Procedure

    mymail.default (3/14/2011)

    I have a view (join on a bunch of tables); This view is put inside of stored procedure with params to pass in to the view.

    The interesting thing is:...

    March 14, 2011 at 11:59 am

    #1298501

  • RE: not able to use xp_cmdshell...

    DZN (3/14/2011)

    Hello,

    I'm trying to read a folder located on another server.

    1. I have created a credential (Identity is <domainname>\<username>

    2. I have created a proxy (Operating System cmdExec) associated with the...

    March 14, 2011 at 9:51 am

    #1298416

Viewing 15 posts - 1,111 through 1,125 (of 3,061 total)