SQL Server 2000 aborda varianta pesimista pentru tratarea tranzactiilor.Introducerea nivelului de izolare snapshot inseamna de fapt folosirea versiunilor de rand (o abordare optimista) si tratarea potentialelor conflicte in cazul modificarilor.Evident chiar si in SQL Server 2000 se pot genera versiuni de rand folosind un mecanism custom (similare ...

Pentru a primi o notificare cand evenimentul are loc, folositi functionalitatea blocked process reports:1. Setati o valoare pentru blocked process threshold:EXEC sp_configure 'show advanced options', 1 ;GORECONFIGURE ;GO-- use 20 seconds in this caseEXEC sp_configure 'blocked process threshold', 20 ;GORECONFIGURE ;GO2. Folositi SQL Server Agent ...

It is supposed to be feature complete. What will differ in the RTM version depends on your feedback!Download the CTP here: Microsoft SQL Server 2008 R2 November CTP

Hi,I am not sure what you mean by ''Candidate Check''.You can get a description of a fact table using the following links:http://en.wikipedia.org/wiki/Fact_tablehttp://en.wikipedia.org/wiki/Online_analytical_processingIf you need additional explanation feel free to ask.

Aveti raspunsuri la probleme de conectare la urmatoarea adresa: SQL Server Analysis Services Port (SQL 2005 / 2008)

Cum spunea si newsletter-ul sunt date estimative nu finale. Inca nu s-a stabilit locatia pentru Brasov si prin urmare nici data.

If you answered no, the new name for what we used to know as project Gemini is Power Pivot You can read more about it at http://www.powerpivot.com/ Yyou can also follow the project on twitter http://twitter.com/powerpivot

Personal va recomand partitionarea.

RoSQL Newsletter 13-10-2009============================================================English Version follows: In acest numar:1. SQL Server Community Eventsa. Romanian SQL Server User Group va invita la SQL Experience o serie de evenimente dedicate SQL Server organizate in Bucuresti. Pentru detalii, agenda si inscriere folositi urmatorul URL: ...