Welcome to Sign in | Help
» Search

Search

You searched for the word(s):
Showing page 20 of 20 (195 total posts) < 1 second(s)
  • Re: Transaction

    ssandu: Am patit un fapt interesant. BEGIN TRANSACTION INSERT INTO Tabela1 .... INSERT INTO Tabela2 ... COMMIT Ai patit un fapt banal. Ai comis o transactie fara ca sa te intereseza daca rezultatul ei e consistent&nbsp;sau nu. Daca&nbsp;verifici @@ERROR, trebuie sa-l verifici dupa fiecare statement. Daca primul&nbsp;INSERT a picat (e.g. ...
    Posted to T-SQL (Forum) by rremus on November 17, 2006
  • Re: Conectare la SQL 2005 Express

    Mihaly: Pana acum am folosit MSDE 2000 si acolo mergea numai cu NumeServer sau cu adresa TCP/IP. De aceea ma gandeam la o modalitate identica de apelare.&nbsp;Altfel nu ma deranjeaza. Nultumesc de raspunsuri! Mihaly Inseamna ca instanta de MSDE era instalata cu numele MSSQLSERVER si instanta de SQL Express e instalalta cu alt nume (probabil ...
    Posted to Intrebari (Forum) by rremus on November 17, 2006
  • Re: timeout expired

    .Net 1.1 sau .Net 2.0? In 1.1 SqlCommand.CommandTimeout setat la 0 nu functioneaza correct (http://support.microsoft.com/kb/887126), seteaza-l la o valoare mare, gen32000. Numai de bine, ~ Remus
    Posted to Intrebari (Forum) by rremus on November 17, 2006
  • Re: system out of memory

    Ce versiune de SQL Server? Ce versiune de OS?&nbsp;Cita memorie fizica? Cit de mare e pagefile? Daca e SQL 2005&nbsp; ar fi interesant de vazut care clerk consuma memoria:select top(10) single_pages_kb+multi_pages_kb as total_pages_kb, * &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from sys.dm_os_memory_clerks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by ...
    Posted to Intrebari (Forum) by rremus on November 17, 2006
  • Re: Performante slabe SQL pe platforma 64

    Presupun ca ai facut toate pregatirile necesare pentru &nbsp;a rula un test de performanta (pregrow databse/log, MDF si LDF pe spindle-uri separate, workload identic). Si evident, rulezi pe acelasi hardware ambele teste. Ce versiune de SQL Server? Ce versiune de OS? Cita memorie fizica? Ce dimensiuni pagefile? Cum compari 32/64? WoW64 sau OS 32 ...
    Posted to Intrebari (Forum) by rremus on November 17, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems