Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 6,678 total)

  • RE: Make Collation Case-Insensitive From Linked SS2K DB

    If you create a schema called 'db', then create a synonym for a table in your other database as:

    CREATE SYNONYM db.Test FOR linkedserver.Database.dbo.Test;

    You can then query it using:

    SELECT * FROM...

  • RE: Strange SQL 2K5 behavior

    Another thing you can do, and should do is:

    ALTER DATABASE SET PAGE_VERIFY CHECKSUM;

    Then, include the checksum option in your backups:

    BACKUP DATABASE ... WITH CHECKSUM;

    Not only with the backup create a...

  • RE: Data File Autogrowths

    The only way I know of to check this for data files is to use the analyze feature of defrag. With a 30GB data file grown in 10MB chunks,...

  • RE: Restart SQL Server 2005 after changing master DB compatability mode to 90?

    No, you don't need to cycle SQL Server.

    Ellis, when you perform an upgrade from SQL Server 2000 to 2005, and there are custom objects in the master database - the...

  • RE: SQL Server 2005 Management Studio Query Shortcuts

    This does not exist natively in SSMS 2005. It does exist in SSMS 2008 - but Microsoft has modified the latest version (RC0) to exclude the capability when accessing...

  • RE: Partitioned Database

    Sunil (6/20/2008)


    Hello Guys,

    I am working as a DBA in a MNC. Currently i need some help ....

    I have very large production environment database so my server response is very slow...

  • RE: Space Available 0.00

    Run a DBCC UPDATEUSAGE for those databases. Then look again.

  • RE: Modify a View....

    No problem - glad I could help, at least with one part.

  • RE: Help with IS NULL

    Manu - unless you have specifically allowed for this, COLUMN = NULL will not work. You always should check for nulls using IS [NOT] NULL syntax.

    Jeff

  • RE: Date Parameter

    Taking what GSquared gave you and adding to it - I think you want this:

    CREATE PROCEDURE mr_test_input

    @PostingDateF_in DateTime =...

  • RE: Modify a View....

    The format is just what I gave you. In your query, replace the date column with:

    ,CONVERT(char(10), yourdatecolumnhere, 101) AS Request_Date

    ,CONVERT(char(8), yourdatecolumnhere, 108) AS Request_Time

    Jeff

  • RE: Modify a View....

    I don't understand how you want to use this as a security view - that is not clear. But, for the date questions, you can use CONVERT to return...

  • RE: How to backup clustered servers

    You perform backups of the DB's exactly the same way you would on a non clustered system.

  • RE: Help with IS NULL

    rsheppick (6/20/2008)


    SELECT Contact.Name, Contact.Phone, Contact.Email ,BundleList.Status as BundleStatus, ProductTypes.Producttype as ProductType,

    ProductList.Status as ProductStatus, BundleType.Bundletype as BundleType, ProductList.Version

    ...

  • RE: SQL 2005 Server Performance on Multicore CPU

    info (6/20/2008)


    On the SQL propetis i all cpu are selected. I have set the sql server high priority checkbox. I have set teh value 0 to limitation of work threds...

Viewing 15 posts - 6,451 through 6,465 (of 6,678 total)