SQL Server Performance

Forums disruption

Discussion in 'Forum Announcements' started by admin, Jun 8, 2010.

  1. admin Guest

    Sorry if the forums have been disrupted this week, we are moving servers and the forum software hasn't been playing very nice with the new hosting environment (Win Server 2008/SQL Server 2008 vs the old Win Server 2003/SQL Server 2000). When under full load the forums have been a bit more memory hungry than I'd thought. Most of the issues will hopefully be resolved by the end of today, but apologies for any down time or slow loads.
  2. Luis Martin Moderator

    No problem.[:)]
  3. FrankKalis Moderator

    Can it be that we've lost some posts?
    I see that the guy here http://sql-server-performance.com/Community/forums/t/31913.aspx has only 1 post today. But I'm pretty I answered his question yesterday and he also replied to it.
  4. FrankKalis Moderator

    Something weird going on.
    I also replied to this thread here: http://sql-server-performance.com/Community/forums/t/31899.aspx
  5. admin Guest

    Yes, apologies for this, I had to recover to a backup a few hours old when the site went down in the morning US Eastern time. I've been running backups 5 times a day during this period. Seems a few hours got lost. Many apologies.
  6. FrankKalis Moderator

    No worries. At least it confirmed that I'm not mad. [:)]
  7. Luis Martin Moderator

    <p>[quote user="FrankKalis"]</p><p>No worries. At least it confirmed that I'm not mad. <img src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif" alt="Smile"> <br></p>[/quote]<br><br>&nbsp;Are you sure?[:p]<br>
  8. FrankKalis Moderator

    <p>[quote user="Luis Martin"]</p><p>[quote user="FrankKalis"]</p><p>No worries. At least it confirmed that I'm not mad. <img src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif" alt="Smile"> <br></p><p>[/quote]<br><br>&nbsp;Are you sure?<img src="http://sql-server-performance.com/Community/emoticons/emotion-4.gif" alt="Stick out tongue"><br>[/quote]&nbsp;</p><p>[ ] Yes<br>[ ] No<br>[ ] Maybe<br>[ ] Does it matter<br>[ ] None of the above.<br></p><p>&nbsp;</p>
  9. admin Guest

    I can't enter a post under a user's name - I could put it in my name and enter "recovered" underneath - but it might look a bit confusing...
  10. preethi Member

    I found a couple of threads missing (As per the mails). Is there anyway we can re-create them?
    knowing a new server
    By farrokhp in SQL Server 2005 General DBA Questions
    How can I say what servie accounts is for a sql server 2k or 2005 in windows xp or 2003 or vista?
    How can I find out what is the local sever name and what if there is any named sever?
    How can I know what people has admin acess to this server?
    What are the 5 or 10 first things you do when you inherit a new sql server?
    Thanks Folks
    T-log puzzling
    By farrokhp in SQL Server 2005 General DBA Questions
    Hi, I am not too expert but there is a T-log I have, No OpenTran, Size 17gb, Used only 200mb, Tried several things to shrink it but it does not shrink...why?? very strange to me. I tried 1- backup tlog with no_log, 2- dbcc shrinkfile (tlog ...) 3- From SSMS and EM
    Have same problem sometimes in sql2k

    Please advise the correct fully steps

    Stored Procedure Help
    By letmeupdate in SQL Server 2005 General Developer Questions
    Hi,
    I have written a stored procedure which gets results from DB. When I run this stored procedure from Query Analyzer it works great. But when I use this same in .net application it doesnt return results. I guess it has issue with dynamic query. Can anyone help me on this do I need to make any changes to below sproc.CREATE PROCEDURE [dbo].[My_SProc]
    @P_I_FIRSTNAME NVARCHAR(250),
    @P_I_LASTNAME NVARCHAR(250),
    @P_I_PageSize INT,
    @P_I_StartRowIndex INT,
    @P_I_OrderBy NVARCHAR(100),
    @P_I_SortDirection NVARCHAR(100)
    AS BEGIN
    DECLARE @SQL NVARCHAR(MAX)
    DECLARE @SelectClause NVARCHAR(MAX)
    DECLARE @WhereCondition NVARCHAR(MAX)
    DECLARE @OrderBy NVARCHAR(MAX)
    DECLARE @SortDirection NVARCHAR(MAX)
    DECLARE @StartRowIndex INT
    DECLARE @FirstRecNum NVARCHAR(MAX)
    DECLARE @LastRecNum NVARCHAR(MAX)
    SET @WhereCondition = ''
    IF @P_I_StartRowIndex = ''SET @StartRowIndex = 1
    ELSESET @StartRowIndex = @P_I_StartRowIndex
    IF @P_I_OrderBy is null
    SET @OrderBy = 'First_Name'
    ELSESET @OrderBy = @P_I_OrderBy
    IF @P_I_SortDirection IS NULL
    SET @SortDirection = 'ASC'
    ELSESET @SortDirection = @P_I_SortDirection SET @FirstRecNum = @StartRowIndexSET @LastRecNum = @P_I_PageSize + @FirstRecNum
    SET @SelectClause = 'SELECT * FROM tblUsers'
    IF @P_I_FIRSTNAME IS NOT NULL
    BEGIN
    IF @WhereCondition = ''
    SET @WhereCondition = ' WHERE First_Name LIKE ''' + @P_I_FIRSTNAME + '%'''
    ELSE
    SET @WhereCondition = @WhereCondition + 'AND First_Name LIKE ''' + @P_I_FIRSTNAME + '%'''
    END
    IF @P_I_LASTNAME IS NOT NULL
    BEGIN
    IF @WhereCondition = ''
    SET @WhereCondition = ' WHERE Last_Name LIKE ''' + @P_I_LASTNAME + '%'''
    ELSE
    SET @WhereCondition = @WhereCondition + 'AND Last_Name LIKE ''' + @P_I_LASTNAME + '%'''
    END
    SET @SQL = N'SELECT *'SET @SQL = @SQL + N' FROM (SELECT ROW_NUMBER() OVER (ORDER BY ' + @OrderBy + ' ' + @SortDirection + ') AS Row, * FROM tblUsers' + @WhereCondition + ' )' SET @SQL = @SQL + N' AS UsersWithRowNumbers WHERE Row >= ' + @FirstRecNum + ' AND Row <= ' + @LastRecNum
    --Print @SQL
    EXECUTE sp_executesql @SQL END
  11. satya Moderator

    Jude
    Glad to know the upgrade path for fourms, hope the recovery model for the database has been kept for maximum recovery to avoid the disruption.
  12. Madhivanan Moderator

    I was not able to login for the last one week
    I wondered what happened until I saw this thread

Share This Page