Forum Replies Created

Viewing 15 posts - 526 through 540 (of 644 total)

  • RE: Severe Performance Problem

    steve.clark 39713 (12/9/2011)

    the database grows by 1Gb a day and has done for the last couple of years, so nothing new on that front. The server isn't virtualised.

    It doesn't...

    December 9, 2011 at 4:58 am

    #1419222

  • RE: Severe Performance Problem

    steve.clark 39713 (12/9/2011)

    Hi All,

    Thanks for you comments so far. The TempDB is fine and there is plenty of disk space on the server. Yep i'm using 2005.

    The only...

    December 9, 2011 at 4:07 am

    #1419186

  • RE: Run a stored procedure automatically

    omidshf (12/9/2011)

    can a stored procedure run automatically when data files attach to a database?

    If you will elaborate on what you are looking for & for what purpose with some details,...

    December 9, 2011 at 3:46 am

    #1419173

  • RE: Severe Performance Problem

    GilaMonster (12/9/2011)

    Divine Flame (12/9/2011)

    What is the average row cont in sys.dm_io_pending_io_requests ??

    On SQL 2000?

    lol :-D, No way . He has not mentioned that he is using SQL Server 2000,...

    December 9, 2011 at 3:42 am

    #1419169

  • RE: 2008 distributor and 2005 publisher (Transactional Replication)

    Dpac (12/8/2011)

    Hi,

    SQL Server could not connect to the Distributor using the specified password.

    Connection to server [RS02] failed.

    OLE DB provider "SQLNCLI" for linked server "8xxxxxxxxA-Bxxx-xxxx-xxxx-xxxxxxxxx" returned message "Login timeout expired".

    Try...

    December 9, 2011 at 2:41 am

    #1419147

  • RE: Severe Performance Problem

    steve.clark 39713 (12/9/2011)

    I am having sever problems with a large database that has been running fine for a number of years. Two days ago all the running processes ground...

    December 9, 2011 at 2:08 am

    #1419125

  • RE: Not able to access table

    Also have you tried to view the data using NOLOCK hint ?

    SELECT TOP 10 (*) FROM TableName WITH (NOLOCK)

    December 9, 2011 at 2:00 am

    #1419121

  • RE: Not able to access table

    Varun R (12/8/2011)

    So I ran sp_lock

    which gives the following information.Is my table crashed? It is having 9 million records. My Process Id 19 has Exclusive lock in the pages. When...

    December 9, 2011 at 1:58 am

    #1419119

  • RE: microsoft sql server 2012

    Can't??? Export - Import, SSIS.

    When I said "Can't" it means that there is no restore/detach-atach kind of readymade facility available for it :-).

    You can always generate script for...

    December 9, 2011 at 1:03 am

    #1419101

  • RE: microsoft sql server 2012

    pallavi.unde (12/8/2011)

    Okiesss...

    If i take a back up of database from SQL Server 2008 and trying to restore it in MSSQL 2005 then it shows error that it is not compatible.

    How...

    December 9, 2011 at 12:46 am

    #1419093

  • RE: microsoft sql server 2012

    pallavi.unde (12/8/2011)

    Is Microsoft sql server 2012 launched????/

    is it better to use .. currently i am using SQL 2005...

    where could i get the installation material.

    It is not released yet. It will...

    December 8, 2011 at 10:50 pm

    #1419059

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    GilaMonster (12/8/2011)

    Same as the index key values are. Part of the row in the leaf pages. That's the definition of an include column - one that's in the index leaf...

    December 8, 2011 at 9:57 pm

    #1419049

  • RE: help me with attaching database

    pavluxaf (12/8/2011)

    Hello. I have a problem with attaching DB.

    There is a DB that was detached from the instanse of SQL Server. DB was placed on RAID0. There were nearly nearly...

    December 8, 2011 at 6:32 am

    #1418646

  • RE: Insert Into With Count()

    Rixxe (12/7/2011)

    I'd rather not insert false records just to get a '0' for the count.

    You shouldn't. You can always use IF EXISTS to know if there is any row available...

    December 7, 2011 at 6:30 am

    #1418031

  • RE: Database user activity

    You can use the Server Side Traces also instead of GUI, they consume less resources on server. You can read about them here[/url].

    To read how to create server side traces...

    December 7, 2011 at 5:54 am

    #1417999

Viewing 15 posts - 526 through 540 (of 644 total)