Forum Replies Created

Viewing 15 posts - 256 through 270 (of 1,109 total)

  • RE: Pivot Tables

    vblllove (4/10/2008)

    I created a Pivot Table that totals the Products ordered for each month in a pivot Table. is there possible to Display Totals of Products and Totals of Values...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 10, 2008 at 4:58 am

    #800875

  • RE: Include columns after creating an index

    Zsolt Szabo (4/10/2008)

    I need to include columns to an index after creating it. So I need to replace this command

    CREATE INDEX

    [INDEX01] ON [TABLE01] (Column01, Column02, Column03)

    INCLUDE (Column04, Column05, Column06, Column07)

    with...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 10, 2008 at 4:56 am

    #800873

  • RE: Find the number of tables used by a procedure

    karthikeyan (4/10/2008)

    can't we achieve this by using SQL queries ? Because you are all saying sp_depends or dbo.sysdepends table will not provide the necessary or relaible informations.

    Again,can't we achieve this...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 10, 2008 at 4:09 am

    #800856

  • RE: Find the number of tables used by a procedure

    SQLZ (4/10/2008)

    ...

    I'm pretty sure that Microsoft's "View Dependencies" functionality included in Managment Studio also parses to correctly return the dependencies - plus you can drill-down through each dependecies' dependencies. ...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 10, 2008 at 4:06 am

    #800855

  • RE: Find the number of tables used by a procedure

    On SQL Server 2000 you can look at the dbo.sysdepends table, on SQL Server 2005 the sys.sql_dependencies.

    Unfortunately neither of these system tables/system views are reliable, and many times they do...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 10, 2008 at 3:23 am

    #800841

  • RE: Is checksum() guaranteed across SQL versions

    Peso (4/9/2008)

    Here is how CHECKSUM is calculated and how you break it.

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70832

    Very Impressive!

    Have you had a look at how MS handles a list of values?

    CHECKSUM seems to do different...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 8:42 am

    #800466

  • RE: Is checksum() guaranteed across SQL versions

    Jeff Moden (4/9/2008)

    How can you say that? I just ran ST's code in 2k and 2k5 and, all other things being equal, they both come up with the exact...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 8:24 am

    #800447

  • RE: Is checksum() guaranteed across SQL versions

    Andras Belokosztolszki (4/9/2008)

    souLTower (4/9/2008)

    If I use checksum() in SQL2000 will I get the same results in 2005 and later versions.

    EX:

    select checksum('abcdefg') -- yields -2039903324

    Thanks

    ST

    No, you will not.

    Regards,

    ...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 6:42 am

    #800320

  • RE: Is checksum() guaranteed across SQL versions

    souLTower (4/9/2008)

    If I use checksum() in SQL2000 will I get the same results in 2005 and later versions.

    EX:

    select checksum('abcdefg') -- yields -2039903324

    Thanks

    ST

    No, you will not.

    the above statement...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 6:37 am

    #800313

  • RE: Clear Log

    Bilichi (4/9/2008)

    i am having a database of size 60Gb of that (28GB of MDF & 32 GB of LDF).

    Is it possible to reduce the Log file size?if possible please provide...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 3:58 am

    #800252

  • RE: Clear Log

    Bilichi (4/9/2008)

    May i know what is the use of dump tran command in database?

    It backs up your transaction log.

    More info is in books online under "BACKUP LOG" http://msdn2.microsoft.com/en-us/library/ms186865.aspx

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 3:38 am

    #800240

  • RE: Clear Log

    Bilichi (4/9/2008)

    Hi

    How to clear the log file without detaching the database?

    Is there any command to do it?

    Why do you want to do this? Has it grown too much?...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 3:23 am

    #800235

  • RE: How To Desing a Database

    windows_mss (4/9/2008)

    hi friends,

    I'm planing to launch an site, In which I'm going to Use SQL Server 2000,

    I'n future there may be Million of Users. So now how should I Design...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 3:19 am

    #800230

  • RE: Attaching a database

    You could use osql as well as Management Studio (a graphical fronted, which if you do not have installed can install for SQL Server Express from http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en)

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 1:59 am

    #800201

  • RE: transpose

    nithyapoy (4/8/2008)

    Thanks.

    But Is it possible without creating Temporary Table.

    You do not need the temporary table (or table variable) at all. Just take the select part of Absinthe's example, and use...

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

    April 9, 2008 at 1:55 am

    #800200

Viewing 15 posts - 256 through 270 (of 1,109 total)