Forum Replies Created

Viewing 15 posts - 5,566 through 5,580 (of 6,678 total)

  • RE: T-Sql rant

    foxjazz (3/13/2009)

    I don't think it's my problem that sql server is so inefficient with the use of cursors. Maybe they should have designed sql server better eh?

    Yes shortening of stuff...

    March 13, 2009 at 3:12 pm

    #959480

  • RE: Any free Intellisense tool available?

    seth.rothman (3/11/2009)

    Another inexpensive option is SQL Assistant (http://www.softtreetech.com/isql.htm). It's less than $200/developer with maintenance. I have no affiliation with them whatsoever but I've found their tool to be...

    March 11, 2009 at 2:36 pm

    #957891

  • RE: How to change an IP for an SQL instance?

    The IP address is controlled by the machine hosting SQL Server, unless you are using a cluster. In a cluster, the cluster group containing that instance of SQL Server...

    March 11, 2009 at 2:33 pm

    #957890

  • RE: Different backup/restore sizes

    What are the sizes that you are seeing? Include the sizes for the backup, all data files (mdf/ndf) and the log files (ldf).

    March 11, 2009 at 2:29 pm

    #957886

  • RE: Index Fragmentation/Identity Property

    Dave Mason (3/10/2009)All the db files are enabled for autogrowth by 50 MB.

    Okay, so how large are the databases now - and is an autogrowth of 50MB large enough? ...

    March 10, 2009 at 3:12 pm

    #957108

  • RE: Index Fragmentation/Identity Property

    In addition to what Gail has mentioned, how much space is available in the data file? Do you have enough space available to rebuild indexes - or, do you...

    March 10, 2009 at 2:56 pm

    #957101

  • RE: Cross tab query, without data aggregation

    Change your order by to a group by, and use sum:

    SELECT Company,

    Year,

    SUM(CASE WHEN Quarter...

    March 10, 2009 at 2:50 pm

    #957099

  • RE: What if the IP addresses are inconsistent?

    SQL ORACLE (3/10/2009)

    Jeffrey:

    I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact I...

    March 10, 2009 at 2:45 pm

    #957096

  • RE: What if the IP addresses are inconsistent?

    SQL ORACLE (3/10/2009)

    Richard M (3/10/2009)

    If you have the users connect to the node specific IP address, you are not doing anything to "help" in case of a failover, as ...

    March 10, 2009 at 12:36 pm

    #957005

  • RE: What if the IP addresses are inconsistent?

    The virtual IP address will not change. The users connect to the virtual IP address and not the node specific address. Cluster administrator redirects the virtual IP address...

    March 10, 2009 at 10:47 am

    #956942

  • RE: What if the IP addresses are inconsistent?

    I don't think there is anything to be fixed. When SQL Server is running on node 1 - it uses the IP address for that node. Cluster Administrator...

    March 9, 2009 at 3:32 pm

    #956437

  • RE: DBCC SHRINKFILE

    bill (3/9/2009)STEP 2 (Conditional on STEP 1 being successful): BACKUP LOG sample_db TO sample_DbLog WITH INIT

    As soon as you issue the above command, you can no longer restore to a...

    March 9, 2009 at 9:37 am

    #956128

  • RE: BCP PROBLRM

    I may be missing something - so please correct me if I am wrong, but don't you need to specify which server you are going to connect to and whether...

    March 8, 2009 at 5:25 pm

    #955745

  • RE: (Not so) Simple update query

    You can use a case expression:

    UPDATE dbo.Person

    SET City = CASE Extension

    ...

    March 6, 2009 at 5:29 pm

    #955353

  • RE: "Script table as"

    Harold Buckner (3/6/2009)

    Most of the time when I use the "Script table as" option in SQL Management Studio it creates a Create Table script with all the columns. On this...

    March 6, 2009 at 2:09 pm

    #955268

Viewing 15 posts - 5,566 through 5,580 (of 6,678 total)