Posts

sql - How useful is database statistics -

How useful is database statistics in terms of query performance? I did the database engine tuning at SQL Server 2004 and said that I could improve the query processing by 79% and the recommendations were made 5 figures and 1 index. In terms of performance, in this case, how would the performance of the query be improved in terms of percentage compared to 1 index, compared to 1 index? Figures for performance queries are important without them adapting that the ordering of the path in the data is the most important. Will be efficient. Every entry table on every table is not better than a scan. It is very important that SQL Server makes them on the fly for ad hoc queries. If you have Meritable from SELECT * where this column = 'some value' , then it will make data on ThisColumn . As the data is modified in your table, the statistics eventually become "stale", at this point the adapter starts ignoring them and actually creating bad plans. The exhibit closes a ...

angularjs - How can one UI Bootstrap DatePicker update several controllers? -

I am new to angular JS and I suspect that the answer is to use a factory, but it is beyond my current capacity. "post-text" itemprop = "text"> Do I have the $ scope in the controller of my codepicker $ watch () And, when the value changes, one can set a $ yolk code and another controller $ rootscope $ watch () that? Yes, your hump is perfect and this is a clean way that comes to mind: date = date = function (date) {setDate = null; return {getSelectedDate: function () {return selectedDate;}, selected date from the set: function {dateDate = date ;},};}) and in its controllers: app.controller ("ctrl1", function ($ scope, date service) { $ Radius $ watch ("dt", function (date) {if (date) {dateService.setselectedDate (date);}}, true);}); app.controller ("ctrl2", function ($ amount, date service) {$ radius. $ clock (dateService.getSelectedDate, function (date) {$ scope.dateFromTheOtherController = date;}, true);});...

android - Stream mp3 from link -

I am trying to create an app that can stream MP3 content from the web. When I run this code, I do not mind, but no audio is played, any help? Thanks Private Media Player Media Player; Override public null on @reate (bundle saved instainstate) {super.naught (savedinstenstate); SetContentView (R.layout.activity_main); InitView (); Try {MediaPlayer.setDataSource ("my link.mp3"); // mediaPlayer.prepareAsync (); //mediaPlayer.prepare (); // if (Mediaplayer.isplaying ()) {mediaPlayer.start (); }} Hold (exception e) {e.printStackTrace (); }} Private Zero initView () {mediaPlayer = New MediaPlayer (); } } Private Media Player Media Player; Override public null on @reate (bundle saved instainstate) {super.naught (savedinstenstate); SetContentView (R.layout.activity_main); InitView (); Try {MediaPlayer.setDataSource ("my link.mp3"); // // mediaPlayer.prepareAsync (); MediaPlayer.prepare (); // If you want async operation, then this Mehthod block U.L. MediaPl...

how to return from bash function with a message? -

I have a function that calls a command, when the command fails, I have to resize a message and then signal failure . EDIT: Sorry, I do not remember that if I had an attempt to do this, as other answers have said, then I may have made a mistake, so I am removing it . This one works fine: function F () {command || Return 1} But I will have to resign the message to indicate due to failure, so I tried to do it, even this function does not come back function f () {command || (Echo "message" & amp; amp; amp; amp; amp;; refund1)} Recommend the right way to do this. In this case: function F () {command | | (Resonant "message" and return 1)} The brackets make a subsection, and therefore returning to the function instead of returning to that subsection to avoid it, instead Use {} (but note that you need the space around them and requires a semicolon before } ). Additionally, the use of the function keyword is non-standard Finally, it is ...

c# - How do I store Point datatype in SQL Server? -

How well can I store a dot data type in my SQL server database? ? I was thinking of making it simply nvarchar , and then when I split the string after inserting a point-string like: 100,246 I read values ​​from db, but a dot ? One way to insert SQL Server is supported by point DataType: Create table: create table [dbo]. [Pointist] Insert (Rohid) [int] (1,1) No, zero [Mypoint] [Geometry] No Taps,) Insert (SRID = 4326): Include the Point Test (MyPoint) values ​​(Geometry :: Point (3, -4, 4326)) Select: Select MyPoint.STX X, PointTest from MyPoint.STY Y; Html>

regex - Why is grep showing lines that don't match? -

I am trying to print all the lines with at least one letter which is not numerical. My Grep code looks like this: grep '[^ [: Points:]] GteST Where GteSt is: test 55 55 pink 123 ssas sas sas a1b2 abba doup dap 12 13 77 a 59360 and in gteast it is exactly the same except the matching parts of the lines (All alpha characters of aka) Instead of displaying matching letters in red, I would print lines / only / matching characters Want. I grep tag (-o, -w, etc.), but none of these do this for me. Am I missing something? Edit: Expected Production will be: Exam 55 55 Pink SAS AAA SAAAA SSA1B2 ABA Dup DAP 77A grep '[^ [: Points:] ] 'File Test 55 55 Pink SSAA SAS AAAAA SAS A1B2 ABA Dup DAP 12 13 77A You get 12 13 because the 12 is the place between and is 13 is a non-digit letter. Initiation Or later points such as: 123 This is how you can: Grep '[^ [: Issue:]]' File Test 55 55 Pink SSAAASAAAAAA SSA1B2ABA Dup DAP 77A or bet...

calling matlab function from Java -

Is it possible to call the matlab function in Java, if so, how can I use it? For example, matlab contains a function called scatter3 and plotter3. How can I use them in Java? thanks There are inappropriate methods for calling MATLAB from Java. You can learn a lot about them from @YairAltman's blog, some of these methods have been captured in the package. Since the functionality is inappropriate and subject to change (and since matlabcontrol is not updated often), you should not rely on this capability for something important.