Forum Replies Created

Viewing 15 posts - 571 through 585 (of 641 total)

  • RE: Book suggestion?

    In my opinion, Michael Hotek's MicroSoft SQL Server 2008 -- Implementation and Maintenance is a good place to start. It is comprehensive and touches on everything. From there...

    July 13, 2010 at 4:50 pm

    #1192409

  • RE: unable to open SSMS in single user mode

    Paul, I should have been clear. I am tinkering. I was simulating a problem with the master database being off-line. I stopped SQL Server and tried starting up...

    July 13, 2010 at 4:35 pm

    #1192401

  • RE: Deleting Specific Rows and Columns in SSIS

    Novicejatt (7/13/2010)

    After Importing it into Table, I want to delete the rows which have "total" and the column "Data".

    Table after deletion:

    Code,Time,Volume,Edge

    100,6/20/2010,200,300

    100,6/21/2010,210,320

    100,6/23/2010,220,340

    102,6/24/2010,230,350

    102,6/25/2010,210,320

    102,6/26/2010,220,340

    103,6/27/2010,230,350

    103,6/28/2010,210,320

    103,6/29/2010,220,340

    Can you guys provide me steps to do it?

    Thanks

    If you...

    July 13, 2010 at 4:30 pm

    #1192398

  • RE: unable to open SSMS in single user mode

    So at this point I am limited to using only the cmd line until I can get the underlying problem solved?

    July 13, 2010 at 4:22 pm

    #1192395

  • RE: Job runs but no notification

    ALZDBA (7/13/2010)

    - Did you follow the BOL ref "How to: Notify an Operator of Job Status (SQL Server Management Studio)"

    - did you create a dbmail profile to be used...

    July 13, 2010 at 2:32 pm

    #1192345

  • RE: How to handle out of disk Tempdb on production server?

    Reo (1/4/2010)

    Hi All;

    I was face a question - How to handle out of disk Tempdb on production server? ; In an IBM DBA interview.

    The interviewer’s concern is that if tempdb...

    July 13, 2010 at 12:59 pm

    #1192298

  • RE: Prevent Truncate, Delete and Update Statements

    Will you kindly specify (with link) where on the SQL Security forum? I can't find the post that addresses creating a DDL trigger to prevent TRUNCATE actions.

    July 13, 2010 at 10:55 am

    #1192231

  • RE: Database Partitioning

    Thank you!

    July 13, 2010 at 9:14 am

    #1192127

  • RE: Database Partitioning

    janyalee (7/12/2010)

    TK432.ndf is the file. Each filegroup may contain one or more files.

    To illustrate this, see the tabs for files and filegroups in SS Management Studio.

    It's explained...

    July 12, 2010 at 5:14 pm

    #1191755

  • RE: Database Partitioning

    George, what is meant when you are speaking about data being written to files in round robin fashion (I get the part about proportionaly growing files, but need clarification on...

    July 12, 2010 at 3:36 pm

    #1191729

  • RE: Job runs but no notification

    I just realized I didn't have the mail profile set to default. So I have changed that.

    The remaining question I have is where do I defined the recipients...

    July 12, 2010 at 2:06 pm

    #1191677

  • RE: Database Partitioning

    janyalee (7/12/2010)

    Any tables not assigned a partition scheme or explicit filegroup will default to the primary filegroup. If multiple files are contained within a filegroup, data will be distributed...

    July 12, 2010 at 12:12 pm

    #1191631

  • RE: Database Partitioning

    george sibbald (7/12/2010)

    No. Data for a non-partitioned table will be confined with a filegroup. You can split out nonclustered indexes to a different filegroup but you have to explicitly define...

    July 12, 2010 at 11:27 am

    #1191613

  • RE: Database Partitioning

    I have another question related to this. .

    If I have a table that I partition across a number of filegroups in a way that is favorable to me, what...

    July 11, 2010 at 8:30 pm

    #1191295

  • RE: Database Partitioning

    Thank you, George Sibbald.

    July 10, 2010 at 9:36 am

    #1191142

Viewing 15 posts - 571 through 585 (of 641 total)