I need to identify stored procedures that are no longer used by our application (~2,000 stored procedures, duplicated in ~1,000 databases).  To do this, I'm querying dm_exec_procedure_stats, which initially seemed to give good results, until I saw some stored procedures that I know are being used a lot.  Subsequent investigations show that if I run the query a few times in a row, I get records dropping out.  Is this a simple indication of memory pressure causing the cache to be cleared? Nobody is running dbcc freeproccache or dbcc freesystemcache.  SELECT database_id, object_id, OBJECT_NAME(object_id, database_id) 'Name',     d.total_elapsed_time, d.execution_count, d.total_worker_time,      d.total_logical_reads, d.total_logical_writes FROM sys.dm_exec_procedure_stats AS d WHERE p.name LIKE '%myinterestingsproc%'   If, for example, that query returns two rows for 'one' stored procedure  (because it's the same name in two db's, I consider it one stored procedure  for the purposes of utilisation), a subsequent run of the query might lose one of the rows. Numbers of the remaining rows do not reset, so it's not a system-wide stats reset.
This next year, I am helping an effort to clean several SQL Server environments.    We have about 10,000 stored procedures and estimate that only about 1000 of them are used on a regular basis, and another 200 or so are used on a rare occasion, meaning we have a lot of work to do.    Since we have multiple departments and teams that can access these databases and procedures, we are not always the ones calling the procedures, meaning that we must determine what procedures are being called.  On top of that, we want to determine this over a few months, not in a few days (which eliminates some possibilities).  One approach to this is to use the SQL Server Profiler and track what procedures are being called and compare them to the list of what procedures we have, while marking whether the procedures are used or not.  From then, we could move the procedures to a different schema in case a department comes screaming.  Is using the Profiler the most effective approach here?  And/Or have any of you done something similar and found another way/better way to do this?
The output from uname:  root@debian:~ # uname -a Linux 5asnb 2.6.32-5-amd64 #1 SMP Mon Jun 13 05:49:32 UTC 2011 x86_64 GNU/Linux   However the /sbin/init executable shows up as 32-bit:  root@debian:~ # file /sbin/init /sbin/init: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, stripped   Other aspects of the system seem to contradict things as well:  root@debian:~ # echo $HOSTTYPE i486  root@debian:~ # getconf LONG_BIT 32 If I want my app to behave differently on a jailbroken iPhone, how would I go about determining this? C++ catching all exceptions Is there a c++ equivalent of Java's  try {     ... } catch (Throwable t) {     ... }   I am trying to debug Java/jni code that calls native windows functions and the virtual machine keeps crashing.  The native code appears fine in unit testing and only seems to crash when called through jni.  A generic exception catching mechanism would prove extremely useful. The shrine indicator (shrine detector? GPShrine?) has both visual and audio cues, so when I'm near a shrine, it beeps constantly. Unfortunately, I occasionally play the game near other humans who are engaged in their own activities, and my wife is decidedly unimpressed with this feature.   When I got the shrine indicator, I could have sworn that the dialogue said I could press [Y] to disable it... but pressing Y pulls out my weapon.   Ideally, I'd like to just make it stop beeping, but stay on for visual cues. But I'll settle for being able to turn it off entirely at times. Slow Network Printing over OpenVPN / Windows Server 2008 Our setup is as follows:  Two offices (A and B) connected with OpenVPN Access Server.  One Windows Server 2008 R2 Standard    Housed in remote datacenter. Terminals at both offices connect through RDP in order to use a particular piece of software concurrently. Network Connected printers (Deployed with GPO) that are connected to separate terminals at each office (and shared) are used with this software to print things throughout the day.   We are experiencing extremely slow printing times.  Opening printer properties can take 30-60 seconds and printing times range from 30-180 seconds with no apparent reason.  File sizes remain &lt; 1mb.  This happens with each of our printers.  All different models.  The server massively underutilized with a 6-core AMD, 16GB ram, 4x 120GB SSDs, and a 100 megabit port.  Our VPN does not seem to be a bottleneck either.  I've been attempting to find ways to increase print speed.  So far no success.  What can you advise? Where can I find the points per game throughout many NBA seasons? Where can I find the points per game (of both teams) throughout many NBA seasons?  To illustrate my point, what I mean is something like:   2000/01 average points per NBA game: 200; 2001/02 average points per NBA game: 210; 2002/03 average points per NBA game: 205;   so on... Marketing Cloud Mobile Push SDK - Switching app user I'm currently building a clienteling app that integrated the Mobile Push SDK on both iOS and Android and encountered some issue on switching the account.  I found that when I login to user A, and set contact key to A, the Inbox Messages will be send to this device. However, I logout user A and switch to a user B, I should set the contact key to B. But seems the inbox messages are associated with the Device instead of Contact, I can still see the inbox messages that were sent to contact A previously.  My question is, how should we deal with this situation, to prevent from seeing the previous inbox messages if the contact key has been changed? How to completely disable Siri on Sierra? Is a GUID unique 100% of the time? How do I add "citations" at the end of the document as done here? I'm trying to parse an INI file using C++. Any tips on what is the best way to achieve this? Should I use the Windows API tools for INI file processing (with which I am totally unfamiliar), an open-source solution or attempt to parse it manually? How do I technobabble without sounding like technobabble? Add a new repository to software sources How to serialize a JObject without the formatting? Natbib puts reference data one line per item I'm using:  \documentclass[oneside,article,openbib,12pt,titlepage]{memoir} \usepackage[authoryear,round]{natbib} % Better bibliography support \bibpunct{(}{)}{,}{a}{,}{,}   in the preamble of my document and  \backmatter \renewcommand{\bibname}{References} \bibliographystyle{chicago}    \bibliography{listb,mybib}   in the body of the file. But a typical formatted reference is:     Freely, I. (1997).   A small paper.   The journal of small papers -1. to appear.   I've tried other non-natbib styles (e.g., regstud), and the reference flows and wraps as it should. So how does one get natbib to do the same?  Also, how does one get natbib to include the authors' entire first names? Can anyone explain reverse bias pn junction using only electrons as charge carriers In forward bias condition p-type semiconductor is connected to positive side and ntype semiconductor to negetive side and the electrons flow from n-type to p-type to cathode of battery.  But imagine the same situation when the situation is reverse biased so now p-type is connected to negetive terminal of battery and n-type to positive terminal of battery.  Now there is excess of electrons in n-region and it is connected to positive terminal of the battery.So electron can flow from n-type region to positive terminal of the battery due to potential difference created by battery whereas in p-type electrons can flow from one covalent bond to another as they do in forward biasing.  Only difference is,here electron move in opposite direction (from one covalent bond to another) i.e. from n-region to depeletion region whereas in forward bias they move from depeletion to n-region.Which shouldn't be a problem   Now in this manner current must flow regardless of biasing so what's the correction? Package in Java I would like to see my review audit history Confession: I have been suspended a couple times from reviewing activities.  Partial Redemption: I have become better and better at passing audits.   I'd like to see my recent and distant history with audits.  Even better, I'd like to see my history with the various types of audits.    I'm not sure this has much value beyond self-reflection and self-analysis. I'd like to see if there are patterns to when I was more likely to fail (do I get sloppy after 10 or 20?), or if there are certain types of reviews at which I struggle more (e.g., suggested edit vs close question).  I suspect that if I reviewed my history and revisited audits I failed, I could create rules and rhythms for myself to become a better reviewer. Schema for a multilanguage database I'm developing a multilanguage software. As far as the application code goes, localizability is not an issue. We can use language specific resources and have all kinds of tools that work well with them.  But what is the best approach in defining a multilanguage database schema? Let's say we have a lot of tables (100 or more), and each table can have multiple columns that can be localized (most of nvarchar columns should be localizable). For instance one of the tables might hold product information:  CREATE TABLE T_PRODUCT (   NAME        NVARCHAR(50),   DESCRIPTION NTEXT,   PRICE       NUMBER(18, 2) )   I can think of three approaches to support multilingual text in NAME and DESCRIPTION columns:   Separate column for each language  When we add a new language to the system, we must create additional columns to store the translated text, like this:  CREATE TABLE T_PRODUCT (   NAME_EN        NVARCHAR(50),   NAME_DE        NVARCHAR(50),   NAME_SP        NVARCHAR(50),   DESCRIPTION_EN NTEXT,   DESCRIPTION_DE NTEXT,   DESCRIPTION_SP NTEXT,   PRICE          NUMBER(18,2) )  Translation table with columns for each language  Instead of storing translated text, only a foreign key to the translations table is stored. The translations table contains a column for each language.  CREATE TABLE T_PRODUCT (   NAME_FK        int,   DESCRIPTION_FK int,   PRICE          NUMBER(18, 2) )  CREATE TABLE T_TRANSLATION (   TRANSLATION_ID,   TEXT_EN NTEXT,   TEXT_DE NTEXT,   TEXT_SP NTEXT )  Translation tables with rows for each language  Instead of storing translated text, only a foreign key to the translations table is stored. The translations table contains only a key, and a separate table contains a row for each translation to a language.  CREATE TABLE T_PRODUCT (   NAME_FK        int,   DESCRIPTION_FK int,   PRICE          NUMBER(18, 2) )  CREATE TABLE T_TRANSLATION (   TRANSLATION_ID )  CREATE TABLE T_TRANSLATION_ENTRY (   TRANSLATION_FK,   LANGUAGE_FK,   TRANSLATED_TEXT NTEXT )  CREATE TABLE T_TRANSLATION_LANGUAGE (   LANGUAGE_ID,   LANGUAGE_CODE CHAR(2) )    There are pros and cons to each solution, and I would like to know what are your experiences with these approaches, what do you recommend and how would you go about designing a multilanguage database schema. Is the external micro SD card path the same for all devices? I am using a Samsung Tab 2.  There is a path: /mnt/external_sdcard/myfile. Here, I can save, read, or write my file to the external micro SD card.  I'm just wondering if this path is the same for all devices, or if it may be different.