Comments
-
Hi James, can you please provide a bit more detail about the situation? Did this error cause an actual issue?
-
Hi Rafael, Are you just experimenting or do you actually want to be inundated with useless, noisy email notifications? At first glance to what you have here, it looks like your condition will not fire for any value 5.00 or less. But your query returns values that are no less than 15 all the way up to 93. So it looks like a…
-
Yes, you can indeed monitor old and unsupported versions of SQL Server going back to SQL Server 2008. However, I wouldn't recommend it. The reason, of course, is that while we monitor those old version, we do not offer support on those older versions. So if you ever encountered unusual or erroneous behavior on DPA when…
-
This request is going to take a bit of time to decode. What is the main driver for this? Is it personal use or something that your team or someone higher up the chain is requesting? The reason I ask this is that the requirements you mention are a bit of jumble and it's hard to tell which are highest priority from those…
-
Hi Eric, let me investigate this further. Sidebar - have you already talked with Support? Many thanks, -Kevin
-
How do you define "large" in this context? Are you interested in a fixed threshold, say anything >= 100k rows? Or are you interested in a dynamic threshold, say 25% of a table?
-
Btw, some more details would be useful, especially what version and edition of SQL Server. SQL Server has become markedly better with each new release and what's a problem in an older release, say SQL2016, is solved in a recent one.
-
Fwiw, when you see a WHERE clause containing an evaluation like "1=1" or "2=2", that clause is invisible to the query optimizer because 1=1 or 2=2 always evaluates to TRUE. So, as you say, it's basically a nifty trick to get the query optimizer to say "Move along folks. Nothing to see here. Move along." It also doesn't add…
-
Is this request for a ETL / ELT / Data pipeline dashboard, by any chance? Just trying to work through a few mental gymnastics on the topic. Thanks!
-
You're embarking on one of the key questions of 21st century IT, @"KMSigma.SWI" . Most of the Big4 consultancies along with the big management consultancies (e.g. McKinsey, Bain, BCG, et al) spend a lot of time and energy researching exactly your hypothesis. Here's an example of a very recent and informative report from…
-
Hi Darian, this is a perennial question and always worth a discussion. :-) In order to give you the best answer, it helps us a lot to know what your end-goal is for this learning plan. For example, do you want to know enough to act as a junior DBA? This would mean learning to handle issues of disaster recovery (DR, a.k.a.…
