Forum Replies Created

Viewing 15 posts - 31 through 45 (of 205 total)

  • RE: What is a passing score on 70-432?

    muthukkumaran (11/12/2010)

    Yes its 700.Two weeks back i had that exam.

    i got 1000:-)

    Nice

    Hope this helps,
    Rich

    [p]
    [/p]

    November 19, 2010 at 11:09 am

    #1253224

  • RE: Track Databases

    There's also something called change tracking, which isn't as detailed as CDC, you can read about it here

    Hope this helps,
    Rich

    [p]
    [/p]

    November 17, 2010 at 11:52 am

    #1252082

  • RE: Data Typing Quandry

    Interesting, I knew there was an overhead to data compression but went for TinyInt over Bit.

    Good question, thanks for taking the time to help educate the SQL community.

    Hope this helps,
    Rich

    [p]
    [/p]

    November 17, 2010 at 5:41 am

    #1251835

  • RE: Burned Out?

    Ray K (11/15/2010)

    I'm a musician in my spare time. Among other things, I play in a large community symphonic band. This group is therapy for me. There...

    Hope this helps,
    Rich

    [p]
    [/p]

    November 16, 2010 at 4:32 pm

    #1251644

  • RE: Today's Random Word!

    Grimethorpe Colliery Brass Band

    Hope this helps,
    Rich

    [p]
    [/p]

    November 16, 2010 at 4:02 pm

    #1251634

  • RE: Conditional Order By

    Good question, thanks for taking the time to help educate the SQL community.

    Hope this helps,
    Rich

    [p]
    [/p]

    November 16, 2010 at 3:59 pm

    #1251631

  • RE: IO Statistics

    From BOL:

    Returns I/O statistics for database files, including log files. In SQL Server, this information is also available from the sys.dm_io_virtual_file_stats dynamic management view.

    DMV's are generally populated since the last...

    Hope this helps,
    Rich

    [p]
    [/p]

    November 15, 2010 at 11:08 am

    #1250868

  • RE: t-sql help please

    Is this the same request as here

    Hope this helps,
    Rich

    [p]
    [/p]

    November 15, 2010 at 6:38 am

    #1250677

  • RE: Issues in Identity Column

    Paul White NZ (11/14/2010)

    Saravanan_tvr (11/12/2010)

    ...how can we update the values in identity column?

    Delete the row and then re-insert it with the correct identity value specified explicitly.

    You will need SET IDENTITY_INSERT...

    Hope this helps,
    Rich

    [p]
    [/p]

    November 15, 2010 at 6:35 am

    #1250675

  • RE: Index Fragmenaton linked wth Table

    I wrote this some time back to return the fragmentation levels across the entire database where fragmentation exists for tables that contain more than 100 pages.

    You can amend it...

    Hope this helps,
    Rich

    [p]
    [/p]

    November 15, 2010 at 6:32 am

    #1250672

  • RE: Query text during caching in SQL 2005

    Good question, thanks for taking the time to help educate the SQL community.

    I look at these DMV's a lot so thankfully answered this one correctly.

    Hope this helps,
    Rich

    [p]
    [/p]

    November 15, 2010 at 6:23 am

    #1250661

  • RE: Bad SQL Jokes

    True story this, I was on a business objects in-house training course and the instructor had to go through the needless task of explaining relationships and joins using the family...

    Hope this helps,
    Rich

    [p]
    [/p]

    November 12, 2010 at 9:14 am

    #1250100

  • RE: Today's Random Word!

    Ray K (11/12/2010)

    RichardDouglas (11/11/2010)

    Juneau

    Joe Juneau

    Juneau, Alaska

    Hope this helps,
    Rich

    [p]
    [/p]

    November 12, 2010 at 8:49 am

    #1250077

  • RE: Today's Random Word!

    Juneau

    Hope this helps,
    Rich

    [p]
    [/p]

    November 11, 2010 at 4:11 pm

    #1249762

  • RE: SQL Server Row based compression

    Check out "Creating Compressed Tables and Indexes" in BOL with lists lots of considerations.

    Hope this helps,
    Rich

    [p]
    [/p]

    November 10, 2010 at 8:18 am

    #1248912

Viewing 15 posts - 31 through 45 (of 205 total)