Forum Replies Created

Viewing 15 posts - 12,406 through 12,420 (of 39,936 total)

  • RE: Indexing

    Luis Cazares (6/14/2013)


    The question is interesting but I do wonder why would someone would disable a clustered index?

    ETL loads is one reason. It can be faster to load without indexes...

  • RE: sql 2000 jobs

    It's not quite clear what you mean, or what you did for access.

    What did you do to grant access.

    When you say he gets an error, do you mean he...

  • RE: Indexing

    My apologies. I think I cut and pasted the drop in the wrong spot when this was proofed. It definitely ran correctly when it was tested.

    I will award points back...

  • RE: Are the posted questions getting worse?

    wolfkillj (6/14/2013)

    You got close, Rod, and we'll give you a pass since you're not American.

    Here's the lineup:

    1st base: Who

    2nd base: What

    3rd base: I Don't Know

    Left field: Why

    Center field: Because

    Pitcher:...

  • RE: Need a help in backup Encyption Certificate

    First, you probably should have someone else responsible for setting this up or working with you. Encryption is serious business and if you lose keys, you lose data. Microsoft...

  • RE: Need a help in backup Encyption Certificate

    There is a percent complete column, where you can get the progress. In terms of the rate, you'd have to just watch this and calculate something.

    SELECT

    db.name,

    ...

  • RE: Fragmented pages in tables not changing

    Do you have lots of free space in your databases?

    In terms of the object, what's the way that it's structured? Is the row size significant compare to page size? Fill...

  • RE: Need a help in backup Encyption Certificate

    #1, why use tempdb? It's like you are trying to make this more complex first instead of getting it working.

    Do it WITHOUT ANY PATH first. Get the backup working correctly.

    Then...

  • RE: Phase of Recovery (Log Shipping)

    Roll forward - transactions committed in the log, but not written to the data files are pushed there.

    Roll back - uncommitted transactions are undone from the data file.

  • RE: Data Vision

    Visualizations are a great place to start, but not sure they're often good for decisions. Better to dig in further to the data itself and verify with the details. however...

  • RE: Exec msdb.dbo.sp_send_dbmail (zipped and password protected) issue

    You could use encryption in SQL Server 2008 to encrypt the data before it's exported to the file. however if you are attaching a file dropped on your file system,...

  • RE: Need a help in backup Encyption Certificate

    If your master key is not protected by the service master key, you need to open it. Since I don't know how you configured your encryption piece, you may need...

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/13/2013)


    Brandie Tarvin (6/13/2013)


    The Dixie Flatline (6/13/2013)


    Don't talk to me about time. Time is my business.

    Dixie, I could kiss you for this. @=)

    By the way, does...

  • RE: Verify multiple bak files via tsql

    The error is what it says, you are missing part of the media family. This is a striped backup, and you can do this natively in SQL Server.

    In Backup Pro,...

  • RE: Questions on resources and removing instances

    A few thoughts here.

    I have no idea on the uninstall and active v in active licenses. I would guess that it's installed licenses, so there is no concept of active/inactive...

Viewing 15 posts - 12,406 through 12,420 (of 39,936 total)