Forum Replies Created

Viewing 15 posts - 721 through 735 (of 3,061 total)

  • RE: Move backup File

    Saga... (11/22/2011)

    I guess in SQL Azure(11) % Denali(12) we can take backup on network drives.

    Even on SQL 6.5 you could do it if properly mapped but that does not...

    November 23, 2011 at 6:29 am

    #1412127

  • RE: Landing My First Job

    Dev (11/23/2011)[hrNope. He/she is not. Last Login Friday, May 06, 2011 9:35 PM.

    :w00t: don't you feel like preaching on the desert?

    November 23, 2011 at 6:25 am

    #1412124

  • RE: Multiple Databases or Multiple Schemas?

    Klarence A. (11/22/2011)

    I am planning to consolidate the data from different database applications like DB2,SQL Server,ORACLE. I was thinking what is the better approach?

    Approach # 1

    DB2 -> SQL Server DB1...

    November 23, 2011 at 6:19 am

    #1412117

  • RE: Trying to determine fraudulent activity based on numbers dialed

    Here goes the pseudo-code...

    FOR EACH SourceNumber on DialedNumbersTable(

    LOAD CURSOR DialedNumbersCursor from DialedNumbersTable

    SET SeedNumber = DialedNumbersCursor(1)

    SET Matches = 1

    SET...

    November 22, 2011 at 1:20 pm

    #1411773

  • RE: How we can get the log an data File sizes Increments with Query

    madhuu1905 (11/22/2011)

    Hi Friends, can you Please Help me to write a script that shows each data and log file for each database in a sql instance. the report should show...

    November 22, 2011 at 11:55 am

    #1411736

  • RE: What's the best way to get an entry level job on SQL server?

    Ninja's_RGR'us (11/21/2011)

    Bill Hansen (11/20/2011)

    You may also consider certification as one way to demonstrate knowledge and give you a slight edge.

    Many posters here conduct interviews and while it's not a deterant...

    November 22, 2011 at 11:48 am

    #1411729

  • RE: Questionnaire Database Design

    thamilanga (11/22/2011)

    3 sources namely staff and customers.

    :blink: Is this a Rick Perry kind of joke? 😉

    I'll suggest to start with an ER Model... so far you have identified...

    November 22, 2011 at 11:26 am

    #1411718

  • RE: Move backup File

    logicinside22 (11/22/2011)

    I like your suggetion can you tell me in details which command should use to setup for this

    Please follow the link I've posted in regards to how to...

    November 22, 2011 at 10:51 am

    #1411696

  • RE: Move backup File

    Richard Moore-400646 (11/22/2011)

    If the SQL Service account has permissions to the share, you can do it all in one step using the "MIRROR TO DISK = " option of the...

    November 22, 2011 at 9:19 am

    #1411629

  • RE: Move backup File

    logicinside22 (11/22/2011)

    I am creating full backup file on my local machine and wants to move on network shared drive but want to setup automatically . this job runs in weekend...

    November 22, 2011 at 9:10 am

    #1411624

  • RE: Cursor to fetch record from two table and insert to another

    Homework, isn't it? 🙂 otherwise there is no reason to use an explicit cursor.

    Do you remember joins from a couple of classes ago? Try populating the cursor joining...

    November 22, 2011 at 9:02 am

    #1411616

  • RE: Calculated field within Dimension

    T_VR (11/22/2011)

    The main advantage for me was that this is something that is used often within queries and this solution could have made the report not hit the fact table...

    November 22, 2011 at 8:57 am

    #1411610

  • RE: SQL 2008 insufficient system memory error

    sqlpadawan_1 (11/22/2011)

    We have a server (SQL 2008 SP2) that is going sideways every 10 - 14 days. When the problem starts, this entry shows up in the event log:

    ...

    November 22, 2011 at 7:22 am

    #1411479

  • RE: Unsure about Fact and Dimension

    T_VR (10/11/2011)

    In essence the "Policy" entity can sometimes behave as a fact (i.e policytransactions fact table )

    and sometimes as a dimension... (i.e. an entity with many descriptive attributes which can...

    November 22, 2011 at 7:17 am

    #1411477

  • RE: Calculated field within Dimension

    T_VR (11/22/2011)

    Hi everyone,

    I would like to get your input on the best practice/method for calculating a dimension attribute that is derived from a fact record. Something along the lines of...

    November 22, 2011 at 7:00 am

    #1411461

Viewing 15 posts - 721 through 735 (of 3,061 total)