Forum Replies Created

Viewing 15 posts - 8,491 through 8,505 (of 9,244 total)

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Jeff Moden (1/14/2009)


    you floor a 4 week drive on black ice on a curve, all wheels loose traction at the same time.

    that's neat. On the flip side, due to...

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

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

  • RE: SQL 2005 and GIS server

    yes, post installation just creates the windows service and licences it before creating the objects, but under 9.2 the SDE is part of the application server suite, even under 9.1...

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

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

  • RE: SQL 2005 and GIS server

    sblock (1/27/2009)


    ArcSDE is installed on the same server as the Sql Server.

    in an ideal world no. In v9.2 SDE is part of the ArcGIS server suite and the SDE libraries...

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

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

  • RE: SQL 2005 and GIS server

    we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008

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

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

  • RE: SQL Server Architecture? What's going on behind the scenes?

    GSquared (1/22/2009)


    how often in a DBA's career does it really matter that pages are 8k in size,

    database sizing springs to mind, something a DBA may well be required to...

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

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

  • RE: How to access SMO in sql server 2000

    sridevi_kj (10/21/2008)


    Hi all,

    I added the SMO reference in .net 2.0 in one machine in which sql server 2005 is installed. I used the SMO...

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

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

  • RE: DBCC Shrinkfile to a size not working - why ?

    regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...

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

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

  • RE: DBCC Shrinkfile to a size not working - why ?

    regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...

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

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

  • RE: DBCC Shrinkfile to a size not working - why ?

    you cannot shrink past the active portion of the log. if the log has an active portion near the end of the file it will not shrink beyond that no...

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

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

  • RE: SQL Server, SANs and Virtualisation

    george sibbald (1/21/2009)


    Perry, I'll find out the exact versions and LUN configuration if only because I want to know and am a little worried we might be missing a trick...

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

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

  • RE: SQL Server, SANs and Virtualisation

    Colin, i have never encountered changing the max degree of parallelism either.

    george sibbald (1/21/2009)


    the article mentioned that VM streamlines the DR process, but for that to be fully true the...

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

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

  • RE: SQL 2005 and GIS server

    we use SQL2005 std edition! What version ArcGIS are you using?

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

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

  • RE: Help? Upgrade from SQL Server 2000 to 2005 failed . . .

    that would be the path i would recommend 😉

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

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

  • RE: Help? Upgrade from SQL Server 2000 to 2005 failed . . .

    yeah i already checked with him. He wasnt trying to upgrade the SBS instances just one of the 2 new instances

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

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

  • RE: Help? Upgrade from SQL Server 2000 to 2005 failed . . .

    Matt, it would seem he has a mixture of sql2000 instances, 2 of the instances are the MSDE which SBS installs. The other 2 seem to be developer edition

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

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

Viewing 15 posts - 8,491 through 8,505 (of 9,244 total)