Welcome to Sign in | Join | Help
» Search

Search

You searched for the word(s):
Showing page 4 of 7 (62 total posts) < 1 second(s)
  • Re: Neverending queries

    Dupa un backup totul a revenit la normal
    Posted to SQL Server 2008 (Forum) by ssandu on June 2, 2009
  • Neverending queries

    De azi dimineata se intampla ceva foarte ciudat.Toate query-urile dureaza la infinit (ne se mai termina).Daca dau restart la serviciul SQLServer totul revine la normal dar dureaza doar 10 min.Ceva idei ce pot sa verific ?
    Posted to SQL Server 2008 (Forum) by ssandu on June 2, 2009
  • Problema select din 2 tabele

    Am 2 tabele Debit si Credit identice cu urmatoarea structura : cont, fel_valuta, suma, leiTrebuie sa le unesc intr-un singur tabel de forma: cont, debit_usd, credit_usd, debit_euro, credit_euro, ... unde debit_usd trebuie sa fie coloana suma din tabela Debit unde fel_valuta este USD, credit_usd = suma din tabela credit unde fel_valuta este USD si ...
    Posted to T-SQL (Forum) by ssandu on February 11, 2009
  • Re: Slow query

    Cred ca am rezolvat problema.Cand am transformat in select @comp l-am facut char(2) nu int cum era in procedura.Modificand parametrul procedurii in char(2) merge la 1 sec.Multumesc ptr. sugestii.
    Posted to T-SQL (Forum) by ssandu on November 17, 2008
  • Re: Slow query

    ExactIncerc sa-mi explic fenomenul.Oricum chiar daca scot SP si pun selectul incarcarea unui Dataset (sau DataReader) dureaza la fel de mult.Aici e problema !
    Posted to T-SQL (Forum) by ssandu on November 17, 2008
  • Re: Slow query

    Rulat ca simplu select (nu ca procedura stocata dureaza 2 sec.) !!!!
    Posted to T-SQL (Forum) by ssandu on November 17, 2008
  • Re: Slow query

    Subinterogarile returneaza ultima inregistrare din tabel de aceea am nevoie de ele.Exista alt mod de a face asta ?
    Posted to T-SQL (Forum) by ssandu on November 14, 2008
  • Slow query

    SalutAm urmatoarea SPCREATE PROCEDURE [dbo].[inventar]&nbsp;@comp int, @gestiune varchar(30), @data DATETIMEWITH RECOMPILEAS WITH Preturi (cod, pret) AS(&nbsp;&nbsp;&nbsp; SELECT cod, pret&nbsp; &nbsp;&nbsp;&nbsp; FROM stocuri AS c1&nbsp;&nbsp;&nbsp; WHERE pk_key = &nbsp;&nbsp;&nbsp; (select max(pk_key) as pk_key from cont as c2 &nbsp;&nbsp;&nbsp; ...
    Posted to T-SQL (Forum) by ssandu on November 14, 2008
  • Re: Fisier log foarte mare

    As fi vrut sa evit si un backup de log deoarece fac doar un backup full.ce parere aveti deALTER DATABASE .... SET RECOVERY SIMPLE WITH NO_WAITsi apoiDBCC SHRINKFILE('fisierlog', 0, TRUNCATEONLY)si iarALTER DATABASE .... SET RECOVERY FULL WITH NO_WAIT
    Posted to Intrebari generale (Forum) by ssandu on September 16, 2008
  • Re: Fisier log foarte mare

    Este valabil si ptr SQL Server 2008 (nu mai are NO_LOG sau TRUNCATE_ONLY) ?Ce recomanzi ?DBCC SHRINKFILE nu merge decat daca recovery model e SIMPLE.
    Posted to Intrebari generale (Forum) by ssandu on September 16, 2008
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems