Forum Replies Created

Viewing 15 posts - 376 through 390 (of 771 total)

  • RE: How does Winrar handle unused space in an MDF file

    Gail,

    Well it is a restore from a backup but not a native SQL Backup. We use DPM (from Microsoft) and so the normal laws of the SQL World seem...

    Kindest Regards,

    Just say No to Facebook!

    October 4, 2010 at 2:04 pm

    #1231261

  • RE: DMV sys.dm_exec_sessions lists Multiple SA Logins

    GilaMonster (9/28/2010)

    Did you exclude system processes? (WHERE is_user_process = 0)

    I did not Gail but I do now. Thanks. I knew it was a dumb question. It would be...

    Kindest Regards,

    Just say No to Facebook!

    September 28, 2010 at 1:30 pm

    #1228635

  • RE: How to search across all SQL Instances

    CirquedeSQLeil (8/24/2010)

    Are you searching for dbname or was that just an example?

    When I need a query to run across multiple versions (for instance in SSIS), I setup a query to...

    Kindest Regards,

    Just say No to Facebook!

    August 24, 2010 at 2:07 pm

    #1211278

  • RE: How to search across all SQL Instances

    CirquedeSQLeil (8/24/2010)

    You could look into Central Management Server. That is an option that is available with SQL 2008. You can execute a query against multiple servers at the...

    Kindest Regards,

    Just say No to Facebook!

    August 24, 2010 at 12:45 pm

    #1211226

  • RE: Why Developers Make Mistakes when working with Database Tech

    UPDATE:

    I have to apolagize for wasting anyone times who read over this post. I just found out the article was specific to ORACLE, a DB platform that I can...

    Kindest Regards,

    Just say No to Facebook!

    August 23, 2010 at 12:58 pm

    #1210658

  • RE: Why Developers Make Mistakes when working with Database Tech

    sturner (8/23/2010)

    For one thing indexes on SQL server do not get 'degenerated'. They can suffer from excessive fragmentation or even just plain worthlessness.

    Since indexes in SQl server are implemented...

    Kindest Regards,

    Just say No to Facebook!

    August 23, 2010 at 12:55 pm

    #1210657

  • RE: How can CREATE INDEX be made more effecient

    UPDATE

    Well this test of creating a duplicate index by a differnet name has appeared to of worked. The purge tool ran to completion without errors and the Index it...

    Kindest Regards,

    Just say No to Facebook!

    August 20, 2010 at 3:29 pm

    #1209955

  • RE: How can CREATE INDEX be made more effecient

    Stefan_G (8/20/2010)

    GilaMonster (8/19/2010)

    YSLGuru (8/19/2010)

    I take it you don't believe that an existing index with teh same structure but by a different name would help speed up the create index statement?

    It...

    Kindest Regards,

    Just say No to Facebook!

    August 20, 2010 at 8:37 am

    #1209705

  • RE: How can CREATE INDEX be made more effecient

    GilaMonster (8/19/2010)

    YSLGuru (8/19/2010)

    I take it you don't believe that an existing index with teh same structure but by a different name would help speed up the create index statement?

    It quite...

    Kindest Regards,

    Just say No to Facebook!

    August 19, 2010 at 10:07 am

    #1209233

  • RE: How can CREATE INDEX be made more effecient

    Derrick Smith (8/19/2010)

    What is your MAXDOP setting on the server?

    Index creation time is improved greatly by parallelism. Most of my OLTP servers have maxdop=1, but when I create indexes, I...

    Kindest Regards,

    Just say No to Facebook!

    August 19, 2010 at 10:05 am

    #1209231

  • RE: How can CREATE INDEX be made more effecient

    GilaMonster (8/19/2010)

    YSLGuru (8/19/2010)

    Bhuvnesh (8/19/2010)

    Also know that this Purge tool we have been sent by the Vendor is not a step by step process so once it starts I have...

    Kindest Regards,

    Just say No to Facebook!

    August 19, 2010 at 9:11 am

    #1209197

  • RE: How can CREATE INDEX be made more effecient

    BTW - since I haven't gotten but 1 reply so far I just wanted to say that I'd appreciate any suggestions on where else to go and aks this quesion...

    Kindest Regards,

    Just say No to Facebook!

    August 19, 2010 at 9:02 am

    #1209191

  • RE: How can CREATE INDEX be made more effecient

    Bhuvnesh (8/19/2010)

    You can do one thing , dont drop/create index instead , DISABLE it before purge process ( it must contain

    INSERTION into destination table ) and then REBUILD...

    Kindest Regards,

    Just say No to Facebook!

    August 19, 2010 at 9:00 am

    #1209187

  • RE: List all SQL servers in multiple domains

    This would require that you have security access on the domain to peruse whats on a server but the again I imagine any method of doing thsi would have something...

    Kindest Regards,

    Just say No to Facebook!

    August 11, 2010 at 4:52 pm

    #1205762

  • RE: LIONS, TIGERS, & LOGINS, Oh What A Bear

    Doug S. (7/29/2010)

    Here's a link to a Great MSDN article with code download for using SQL Server management objects to create your own GUI.

    http://msdn.microsoft.com/en-us/magazine/cc163409.aspx

    Good luck

    Sweet! ...

    Kindest Regards,

    Just say No to Facebook!

    July 29, 2010 at 1:37 pm

    #1200026

Viewing 15 posts - 376 through 390 (of 771 total)