RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

Microsoft MCP Business Page

My Microsoft Virtual Card     
Leggi tutto il post...
Categoria: News Events
martedì, 28 set 2010 Ore. 21.54

My New MCP Business Card  
Leggi tutto il post...
Categoria: Community & Forums
sabato, 18 set 2010 Ore. 01.50

Shrink datafiles with Sql Script

Uno script per compattare tutti i datafiles rilasciando spazio a scritp to compact alla datfiles with space relesing at the end USE Database GODECLARE @fileid as intDECLARE @name as varchar(50)DECLARE contact_cursor CURSOR FORSELECT file_id, nameFROM sys.database_files; OPEN contact_cursor;FETCH NEXT FROM contact_cursorINTO @fileid, @name; WHILE @@FETCH_STATUS = 0BEGIN    --Shrink datafile. Rilascia tutto lo spazio disponibile alla fine del file sistema operativo.   
Leggi tutto il post...
Categoria: Sql Server ALL
giovedì, 02 set 2010 Ore. 09.42

Shrink defrag databases - Test Script

Shrink defrag databases An the end, only you can determine whether you want to shrink or not. With above information, you hopefully have enough to go on when making that decision. You probably know by now what I think of regular shrinking. Not to talk about autoshrink. :-)Below you find the T-SQL code I ran to prove that shrinking of a database will generate the same amount of transaction log records as the amount of data which was moved. (The script uses the 'NUL' filename as backup destinatio 
Leggi tutto il post...
Categoria: Sql Server ALL
mercoledì, 01 set 2010 Ore. 09.20
  • Views Home Page: 455.142
  • Views Posts: 869.146
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003