Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 7,164 total)

  • RE: Database Monitoring tool

    I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 31, 2012 at 11:01 am

    #1572557

  • RE: Creating Roles in SQL Server

    Shadab Shah (12/31/2012)

    Hi,

    I am new in Administration group. I read over internet that user that are created using windows auhentication have all the database rights Creating a SQL Server 2008...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 31, 2012 at 10:47 am

    #1572554

  • RE: Database Monitoring tool

    SQL Server Magazine > 2012 SQL Server Pro Editors' Best and Community Choice Awards

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 31, 2012 at 10:41 am

    #1572551

  • RE: Getting last ID in inserted trigger, howto ?

    aykut canturk (12/31/2012)

    the trigger is very simple and only makes some calculations. what I need is get the ID number of this record and write it to another field. why...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 31, 2012 at 10:38 am

    #1572549

  • RE: how to find resource database location

    rajeshjaiswalraj (12/29/2012)

    My question was Is it possible to copy a resource database files when instance is ruining. if not why and yes then how to do simply copy and pest.

    So...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 10:10 pm

    #1572379

  • RE: Allocating memory on a Hyper-V Server running three instances

    ericwenger1 (12/29/2012)

    Thanks for your prompt reply. I'm absolutely confident that you know more than I about this matter.

    Here is the link that I used:

    http://www.conetrix.com/Blog/post/Best-Practices-for-Memory-Management-of-Multiple-Instances-of-SQL-Server-2008-R2.aspx

    Given the fact that I have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 4:32 pm

    #1572362

  • RE: Allocating memory on a Hyper-V Server running three instances

    ericwenger1 (12/29/2012)

    I'm trying to determine the best allocation of memory on a virtual(hyperV) 2008 Server that has sql server 2008r2 installed with a default instance and two named instances....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 9:35 am

    #1572336

  • RE: Why Allow Heaps at All?

    GilaMonster (12/29/2012)

    opc.three (12/29/2012)

    I am under the impression that the clustered index requirement is a function of the way the Azure database team decided to replicate data behind the scenes to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 9:28 am

    #1572335

  • RE: SSIS loading only 5 of 42 fields to SQL

    SatishAyyar (12/29/2012)

    Yes the table was loaded with all the data that is in excel. Try to create a new package and see if it works

    I did, and was able to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 8:52 am

    #1572331

  • RE: Query Execution Plan

    The operator costs within an execution plan will always add up to 100%. If you are running multiple stored procedures in a batch then the relative batch cost of all...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 8:05 am

    #1572325

  • RE: how to find resource database location

    It cannot be viewed through SSMS Object Explorer if that is what you were wondering. Gail told you where the physical files reside and there are ways to access it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 5:39 am

    #1572322

  • RE: Script to know who is logged o to the server

    I think this is more of a system admin question than a SQL Server question. You can setup your RDP endpoint to end disconnected sessions after a certain amount of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 5:19 am

    #1572321

  • RE: SSIS loading only 5 of 42 fields to SQL

    nelsonj-902869 (12/28/2012)

    It's a monster...9200 rows. How about a sample of 200 rows?

    Attached is a SSIS package that loaded all columns in your test file cleanly into a test database...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 4:51 am

    #1572319

  • RE: SSIS loading only 5 of 42 fields to SQL

    SatishAyyar (12/28/2012)

    I was able to load the data as it is in EXCEL. All the columns are loaded. I do not see any issue. I have sql server 2008 R2...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 4:36 am

    #1572318

  • RE: Question about server alias

    cphite (12/28/2012)

    We currently have two production servers at my company, let's call them DB1 and DB2, each with a handful of databases that are used fairly extensively throughout the day....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 29, 2012 at 4:11 am

    #1572316

Viewing 15 posts - 2,596 through 2,610 (of 7,164 total)