Forum Replies Created

Viewing 15 posts - 271 through 285 (of 471 total)

  • RE: Data Typing Quandry

    Hugo Kornelis (11/17/2010)

    Cliff Jones (11/17/2010)

    UMG Developer (11/17/2010)

    Cliff Jones (11/17/2010)

    Yes, I agree with this. Compression has an effect on the storage but does not change the defined row...

    November 17, 2010 at 2:29 pm

    #1252162

  • RE: Data Typing Quandry

    UMG Developer (11/17/2010)

    Cliff Jones (11/17/2010)

    Yes, I agree with this. Compression has an effect on the storage but does not change the defined row size.

    But what is the...

    November 17, 2010 at 12:44 pm

    #1252110

  • RE: Data Typing Quandry

    SanDroid (11/17/2010)

    UMG Developer (11/17/2010)

    I couldn't find any definition for "defined row size", do you have a link to a definition? Does it include metadata?

    Exactly my point. The term in the...

    November 17, 2010 at 12:09 pm

    #1252090

  • RE: To switch or not to switch

    Oleg Netchaev (11/11/2010)

    A little ambiguity around Partitions can be on any column part aside, this was a very good question, thank you Stewart. Interestingly, we had a question on ASK...

    November 11, 2010 at 12:09 pm

    #1249658

  • RE: To switch or not to switch

    So what would be an example of a column that could not be partitioned? My coin toss also went the wrong way.

    November 11, 2010 at 12:03 pm

    #1249652

  • RE: Why SHRINKFILE is a very bad thing, and what to do about it.

    Simon Facer (11/9/2010)

    SanDroid (11/9/2010)

    I am really disappointed with this article and it's information.

    Lots of it is directly from the BOL or other articles.

    All it told me was:

    SHRINKFILE BAD. Be...

    November 9, 2010 at 1:40 pm

    #1248562

  • RE: Predict the outcome of the SQL statements

    Tom.Thomson (11/2/2010)

    Good question, but as some have already noted the explanation is a bit lacking.

    Also, the question was made too easy by the absence of the All 2s option as...

    November 2, 2010 at 9:55 am

    #1245511

  • RE: Affected tables in DB

    You can always use SQL Profiler and capture a trace while users are using the application. It will capture every SQL statement executed against the database which you...

    October 14, 2010 at 7:52 am

    #1236858

  • RE: backup database

    sknox (9/22/2010)

    Dave62 (9/22/2010)

    sknox (9/22/2010)

    ... --other data changes (e.g, by other users) are not rolled back. In this case, the items related to a backup are the backup file itself, and...

    September 22, 2010 at 9:02 am

    #1225672

  • RE: Inside the Optimizer: Constructing a Plan - Part 4

    This is an outstanding series, thanks Paul for sharing this information.

    September 16, 2010 at 9:48 am

    #1222303

  • RE: Fun with Transactions - Part II

    Thanks Hugo for the explanation.

    September 16, 2010 at 7:57 am

    #1222204

  • RE: Fun with Transactions - Part I

    Good question, thanks.

    September 14, 2010 at 12:17 pm

    #1220901

  • RE: Disabling Indexes

    vk-kirov (9/10/2010)

    The question would be more educational if it had no 'DROP CONSTRAINT' statement. In this case I would probably have answered wrong 🙂

    Yes, I agree.

    September 10, 2010 at 7:54 am

    #1219168

  • RE: How many rows?

    Interesting question, thanks.

    August 27, 2010 at 8:04 am

    #1212968

  • RE: default schema trouble

    I did not notice the Sysadmin role. Gotta' read the whole question I guess.

    July 28, 2010 at 10:07 am

    #1199343

Viewing 15 posts - 271 through 285 (of 471 total)