Is it possible to send queries involved in a deadlock via db mail alert in SQL Server 2005 on mail?  If it is possible, then what is the best way to do this?
SQL Servers has Traces and XEvents. These are used to capture and analyze what is going on with our SQL Server Instances. Events are stored in the stack for later analysis. For example,  If I decide to monitor any dead lock in the database, I just query the trace file to see the history of deadlock for a period of time. Here is my question:  While events occur, in our example deadlock event, is there a way to get an email notification using msdb.dbo.xp_send_dbmail?
Explaining to laypeople why bootstrapping works I recently used bootstrapping to estimate confidence intervals for a project. Someone who doesn't know much about statistics recently asked me to explain why bootstrapping works, i.e., why is it that resampling the same sample over and over gives good results. I realized that although I'd spent a lot of time understanding how to use it, I don't really understand why bootstrapping works.  Specifically: if we are resampling from our sample, how is it that we are learning something about the population rather than only about the sample? There seems to be a leap there which is somewhat counter-intuitive.  I have found a few answers to this question here which I half-understand. Particularly . I am a "consumer" of statistics, not a statistician, and I work with people who know much less about statistics than I do. So, can someone explain, with a minimum of references to theorems, etc., the basic reasoning behind the bootstrap? That is, if you had to explain it to your neighbor, what would you say? Moving set of polygons in ArcGIS Pro? I am very new to mapping and I have loaded a set polygons from a shapefile into ArcGIS Pro. They appear correctly however they have clearly lost (or didn't have in the first place), their longitudinal and latitudinal information as they are currently placed in the middle of the ocean, which I believe is the 0 lat, 0 long position.  I can manually move these polygons but it won't let me save the moves, so when I click 'select', it moves back to the original location. Both of the 'save' and 'discard' buttons are greyed out and cannot be clicked. If I click 'finish' on the move tool then it will snap back to the original location too.  Does anybody have any ideas? Finding the limit of $(1-\cos x)/x^2$ I would like to take a picture of a street during the day to depict how much traffic and cars there are on the street.  Is there anyway to do this with a long exposure photograph?  I have a Nikon D90 and I set the f stop down to 1/16 (the lowest of my lens) and set the time to 2 seconds. Doing this, the exposure is almost saturated when taken around 5pm with the sun setting behind a tree. Doing this, the cars passing by were very hard to make out against the stationary background, being visible as a blur in the color of the car.  Perhaps this is not possible and I should just do this at night where the cars lights are much brighter than the background.  Please suggest how else I might depict the traffic in a photograph?  Are daytime long exposure photographs even possible? I want to do calculations with dates and use 'current year' in a formula condition. When I tried to manipulate dates in a formula I always receive an error of incompatibles types; NUMBER AND DATE.   Because of that I had to convert the date fields into numbers in the dataflow. It worked but I didn't resolve the issue of current year because it is impossible to convert a field that change with time. The condition and the formula is the following:  case     when  'Date_Month'+'Date_Year'*12&gt; 2+'current year'*12 then 0 when ('current-'Date_Year')*12+(2-'Date_Month')) % max('Billing_Periodicity') == 0 then 'Parcel_Bill' else 0    Many Thanks for your attention and help Is there any way to tell Google to display the updated title instead of displaying the old blog title in search results? How do you reindex an array in PHP but with indexes starting from 1? Any help would be appreciated.  If $n$ is a natural number $\ge 2$ how do I prove that any graph with $n$ vertices has at least two vertices of the same degree? How do you reset timers? How to use different domains for multilingual sites and keep users logged in? I have a site that is in French and English. I am able to successfully setup so that users can switch back and forth between the two domains to view either language, however I cannot seem to keep users logged in. When they are logged into the english domain and then switch to the french domain they are required to login again. However if they switch back to the english domain they are still logged in.  As an example we'll use www.english-domain.com as the base (default) domain and www.french-domain.com as the secondary domain  In settings.php I have modified the following, however it doesn't seem to be keeping them logged in. Am I missing something?  /**  * Drupal automatically generates a unique session cookie name for each site  * based on its full domain name. If you have multiple domains pointing at the  * same Drupal site, you can either redirect them all to a single domain (see  * comment in .htaccess), or uncomment the line below and specify their shared  * base domain. Doing so assures that users remain logged in as they cross  * between your various domains.  */ $cookie_domain = 'english-domain.com';   Note: That I have also flushed both site and browser cache as well as deleted any cookies left on my machine.  Update:  Here are my language settings: What does the explicit keyword mean? What does the explicit keyword mean in C++? How can I prove that $n^7 - n$ is divisible by $42$ for any integer $n$? I can see that this works for any integer $n$, but I can't figure out why this works, or why the number $42$ has this property. Let $x_{1},x_{2},\cdots,x_{n}$ be real numbers. Show that     $$\sum_{i,j=1}^{n}|x_{i}+x_{j}|\ge n\sum_{i=1}^{n}|x_{i}|.$$   I think this problem may be solved using nice methods, but I can't find them yet; I know this may be of use: $$|a|+|b|\ge |a+b|.$$ But I can't make it work. Thank you everyone. Downloading US Census data? Why are we using the squared residuals instead of the absolute residuals in OLS estimation?  My idea was that we use the square of the error values, so that residuals below the fitted line (which are then negative), would still have to be able to be added up to the positive errors. Otherwise, we could have an error of 0 simply because a huge positive error could cancel with a huge negative error.  So why do we square it, instead of just taking the absolute value? Is that because of the extra penalty for higher errors (instead of 2 being 2 times the error of 1, it is 4 times the error of 1 when we square it). How to install import_3dm add-on properly? Integral of $\sqrt{1-x^2}$ using integration by parts Below you find the design for our business cards. The triangles are yellow, as you can see outside of the canvas. However, inside the canvas, only when I set the Color Mode to CMYK, they appear pink. When I switch the Color Mode back to RGB, they appear yellow as expected. However, when I print them, in both cases they turn out pink...   I would just like to know what is going on here and how I can change them back to the right colors?  CMYK Colors: Let $H$ and $K$ be subgroups of a group $G$, and let $HK=\{hk: h \in H, k \in K\}$, $KH=\{kh: k \in K, h \in H\}$. How can we prove that $HK$ is a subgroup iff $HK=KH$? What are the alternatives for storing client side encrypted data? I want to store client side encrypted data in Drupal 7, so that it is encrypted on the client end, and stored and transmitted in encrypted form. The password is never transmitted or stored on the server. The only modules I have found which do this are  and  but they are for Drupal 6. I need something that is user specific, so that different users can use different keys, rather than a single key or a set of keys used on the server end. Are there any similar modules for Drupal 7?