Forum Replies Created

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

  • 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" 😉

    April 24, 2012 at 12:57 am

    #1477930

  • 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" 😉

    April 24, 2012 at 12:52 am

    #1477928

  • 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" 😉

    April 24, 2012 at 12:36 am

    #1477924

  • 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" 😉

    April 24, 2012 at 12:33 am

    #1477923

  • 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" 😉

    April 24, 2012 at 12:30 am

    #1477921

  • 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" 😉

    April 23, 2012 at 3:51 pm

    #1477841

  • 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" 😉

    April 23, 2012 at 1:32 pm

    #1477773

  • 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" 😉

    April 23, 2012 at 12:13 am

    #1477296

  • 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" 😉

    April 22, 2012 at 11:59 pm

    #1477290

  • 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" 😉

    April 21, 2012 at 5:34 pm

    #1477102

  • 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" 😉

    April 21, 2012 at 5:33 pm

    #1477101

  • 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" 😉

    April 21, 2012 at 10:51 am

    #1477077

  • RE: System Databases on C or with User Databases?

    Steve Jones - SSC Editor (4/21/2012)

    master/model/msdb usually are small enough, with few transactions, so including them with binaries is fine. Tempdb I treat as another user database.

    +1, but the only...

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

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

    April 21, 2012 at 8:15 am

    #1477070

  • RE: Multiple files for tempdb

    balasach82 (4/21/2012)

    Thanks Gail for the immediate clarification. I too was wondering that it does not make sense to modify model (which eventually would have an effect on the new user...

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

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

    April 21, 2012 at 5:48 am

    #1477053

  • RE: How to apply SQL Server 2005 service pack 4

    evevea (4/20/2012)

    Thank you very much. I have seen that page but was expecting a bit more than just "How to obtain ...." and How to install SQL server itself.

    For...

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

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

    April 21, 2012 at 5:35 am

    #1477047

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