-
IE8/IE9 append row table disappear
Suppose to have this table on the page: <table border=”1″ id=”TABLEID”> <thead><tr><th>col1</th><th>col2</th><th>col3</th><th>col3</th><th>col6</th><th>col7</th></tr></thead> <tbody></tbody> </table> Now suppose you want to append some row with jQuery, row returned by AJAX call as string containig ‘<tr>…</tr>’, with the code: $(‘#TABLEID’).empty(); var t=$(‘#TABLEID’); var b = t.find(‘tbody’); if (b.length == 0) { t.append(msg.d); } If the string contain tailing…
-
Monitorare il backup/restore in sql 2005
Spesso bisogna monitorare l’avanzamento del backup o del restore di un db, con la query sotto è possibile monitorare tutti i processi di tale tipo. SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a WHERE r.command in (‘BACKUP DATABASE’,’RESTORE DATABASE’) La query…
-
Microsoft® SQL Server ® 2012 High-Performance T-SQL Using Window Functions
Una ottima guida all’uso efficiente delle window function dell’SQL. La guida è aggiornata alla versione 2012 di SQL server, ma buona parte delle indicazioni sono utili anche per SQL Server 2005 e SQL Server 2008. Infatti la prima introduzione delle window function in SQL Server risale alla versione 2005. Microsoft® SQL Server® 2012 High-Performance T-SQL…
-
SQL Server 2008 Query Performance Tuning Distilled
One of the finest book on SQL Server Perf Tuning. A great reference book as I was expecting. Lot of theories and matching examples make this book stand out from the rest. SQL Server is just not SQL Tuning. It includes Database System tuning. This book has given a dedicated chapter in making you understand…
-
Limits of EXEC and SP_EXECUTESQL
One thing that is not clear from MSDN documentation is the limits of 8000 byte for query input of EXEC and SP_ECECUTESQL. If you execute this query: declare @query1 as varchar(max) set @query1= replicate(‘ ‘,7951)+ ‘ select top 1 object_id,name from sys.all_columns’ exec (@query1) declare @query2 as nvarchar(max) set @query2= replicate(N’ ‘,3951)+ N’ select top…
-
Empty data file on SQL Server 2005
If you have the following error while empting a data file (with DBCC SHRINKFILE (N’datafilename’ , EMPTYFILE)): Msg 2555, Level 16, State 2, Line 1 Cannot move all contents of file “xxxxxx” to other places to complete the emptyfile operation. Check that the file do not contain tables with no clustered index. If a table…
-
SQL e lock
Un ottimo articolo http://www.sql-server-performance.com/2004/advanced-sql-locking.
-
Huawei E586 Linux driver
Download from here: http://download-c.huawei.com/tcpsdownload/downLoadCenter?category=&flay=software&downloadID=NDcwMzU= unpack and cd to the right directory type sudo ./install restart the computer plug off and plug in the device Driver founded here. Updated: link do not work, try this.
-
Corel VideoStudio Pro X4 e Common.msi
Dopo aver disinstallato il programma Corel VideoStudio Pro X4 è cominciato a comparire un avviso del windows installe che cercava il file Common.msi per completare una fantomatica installazione. Il problema si manifestava appena veniva selezionato un disco. Il problema era dato dalle seguenti estensioni della shell non correttamente disinstallate: HKEY_CLASSE_ROOT\Drive\shellex\ContextMenuHandlers\Ulead UDF Driver HKEY_CLASSE_ROOT\Drive\shellex\PropertySheetHandlers\Ulead UDF Driver…