Forum Replies Created

Viewing 15 posts - 5,626 through 5,640 (of 9,244 total)

  • RE: SQLVDI and then Terminate Unexpectedly

    Fraggle-805517 (4/24/2012)


    We have Litespeed set to "Verbose, cleanup on success" so I have stuff that Litespeed is looking into.

    The event logs don't show any restart errors.

    Fraggle.

    a;; of the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    Orion Pax (4/24/2012)


    So I too proposed a three RAID setup of:

    Drive RAID Cnt ...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQLVDI and then Terminate Unexpectedly

    Have you enabled Litespeed logging this will provide more info?

    Try checking the windows application and system logs for any potential restart errors

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can you restore a 2008 DB to 2005?

    rummings (3/13/2012)


    I tried to use an SSIS package, but it complained about the versions. I think tried Export/Import.... still received version errors. I then tried to generate a create...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Created availability group, but cannot connect to listener

    winston Smith (4/22/2012)


    I have created an availibity group with 2 databases, across 3 servers.

    ServerA is the primary server

    ServerB is synchronous failover

    ServerC is synchronous readonly copy of the data.

    I created a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Problem Uploading large files

    Check the maxfileupload size in IIS, it defaults to 5MB you may want to change this

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Dynamically configure/deploy database using database projects and/or DTA

    SMO has various methods you can exploit to do a whole range of database interaction tasks through C# and VB.net

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DBCC

    In general the DBCC commands are database engine direct functions, they have thousands of lines of code behind them.

    What is it you are expecting or would like to see?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3

    APA0876 (4/23/2012)


    Perry,

    I finally found the article Part 3, this is wonderful, I just have question can I have multiple default sql instances on a SQL cluster? Or just one default...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to configure SQL Server 2008 R2 Active/Passive Cluster

    here you go[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cost Threshold Paralllelism -

    GilaMonster (4/22/2012)


    A query's cost is not the number of seconds that SQL thinks it will take to run. Yes, the documentation says it is, the documentation here is wrong. Costs...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cost Threshold Paralllelism -

    sqldba_newbie (4/22/2012)


    So when MAXDOP is set to 1 no matter what CTP value is set to query would ever use ONLY 1 processor?

    CTP will have no bearing when maxdop is...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Litespeed high CPU usage

    Have you thought of throttling the Litespeed backups

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Cost Threshold Paralllelism -

    Cost threshold is in secs based on what the optimiser thinks a query wy take in secs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Multiple files for tempdb

    balasach82 (4/21/2012)


    Perry,

    While creating a DB, if the size is not given, it takes the size of the model, whereas if the size is given (which is greater/lesser than model size),...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 5,626 through 5,640 (of 9,244 total)