Code, Query, Ship, and Learn

Sign in Subscribe

lejin2000

USEFULL DMV MS SQL 2016

SELECT TOP(10) dows.* FROM sys.dm_os_wait_stats as dows ORDER BY dows.wait_time_ms DESC --CPU BOUND QUERY SELECT TOP 5 st.text, qp.query_plan, qs.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st CROSS

14 EXPERTS SHARE HOW TO DO WELL FINANCIALLY IN 2017

14 EXPERTS SHARE HOW TO DO WELL FINANCIALLY IN 2017 (FOR MALAYSIANS) Published January 5, 2017 by mr-stingy in Money http://www.mr-stingy.com/do-well-financially-2017-malaysians/

Stored procedure working when run manually, not running in SQL Agent Job XML sp_OACreate

1 down vote accepted I had this same issue when google geocoding and parsing the XML result. Seems that when run via an SQL job the XML result was being truncated. Found the solution here: http://www.progtown.com/topic376715-a-problem-with-spoagetproperty-p2.html Had to put: SET TEXTSIZE 2147483647; at the start

Detect hashchange and hash existed code run duplicate?

https://stackoverflow.com/questions/33056521/detect-hashchange-and-hash-existed-code-run-duplicate var hash = ''; $(document).load(function() { $(window).trigger('hashchange'); }); $(window).on('hashchange', function() { if (hash == window.location.hash) { // do nothing, hash is the same as it was previously return; } hash = window.location.hash; if (hash) { alert("Apple"

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

Changing the Setting From The Tools Menu In the Options dialog box of Tools Menu, expand Query Results, expand SQL Server and then select Results to Text as shown in the image below. In the right side panel change the value of Maximum number of characters displayed in each column

Turn svg to font icons

About IcoMoon is striving to build and provide the best iconography and icon management tool for perfectionists. IcoMoon's icon library features only the very best icon sets out there. All of our icons are designed on a precise pixel grid. The IcoMoon app lets you build and use

Send excel file to user in web

Private Sub ExportFile(ByVal strfilePath As String, ByVal strFilename As String) Try Response.Clear() Response.ContentType = "application/vnd.ms-excel" strfilePath = Server.MapPath(strfilePath) If Not System.IO.File.Exists(strfilePath) Then strfilePath = Server.MapPath("~//Data//ExportToExcel//NoRecord.xls") Response.AddHeader("content-disposition", ("attachment;filename=

Export data from a DataSet into a real Excel 2007 file Open XML SDK

Ever wanted to add an "Export to Excel" function to your ASP.Net, WinForms or WPF application ? This free C# and VB.Net library lets you export a DataTable or DataSet of data into a "real" Excel 2007 .xlsx file, using one line of code. DocumentFormat.

Dividend share KLSE 2017

[June topic: high dividend series] - you recommend, I analyze! WeShareWeTrade decided to launch a high dividend series in June after the team launched a small series every month! We will share a high dividend company every day in June and analyze whether these companies are suitable for long-term dividends

Dividend share KLSE 2017

【六月专题：高股息系列】- 你推荐，我分析！继团队推出每月小股系列后，WeShareWeTrade决定在六月份推出高股息系列！我们将会在六月的每一天都分享一家高股息的公司，并分析这些公司是否适合买来长期收股息，以提高你的passive income！也就是说，我们将会分享并分析30家公司！我们会分享那三十家公司呢？我们将会分析The Edge Malaysia 整理的20大高股息公司，另外10家就由你们做主！你只需要留言comment推荐高股息公司的名字，我们团队就会筛选10家并在六月做出分析。一个完美的投资组合中必定要有至少一两支稳到没有朋友的高息股来磨合一下。所以一定要把高息股这个好康头分享给你喜欢买股收息的朋友们知道，不然就真的没朋友了。哈哈，希望读者们多多支持!分享分享! 这是一个连续三十天的功课分享，可以预见团队在未来的三十天都会很忙碌，如果要求至少三十个分享应该不会很过分对吧 :P hehe The Edge Malaysia (#1162期) 整理的20家最棒的高股息公司(过去10年都有派股息，净利和正面现金流) STAR (6084) FPI (9172)