Viewing 15 posts - 4,921 through 4,935 (of 49,571 total)
From the definitions you posted, CaseNo is second column in both of those indexes. Since CaseNo is the second column, neither of those indexes are seekable, so it will have...
August 26, 2015 at 7:24 am
Nope. Only when they're on a join or where clause predicate which prevents index usage.
August 26, 2015 at 7:03 am
I'm using two SUMs because you want two columns summed. The first (9+8+8+5) = 30, the second (1+1+1+1) = 4.
August 26, 2015 at 5:31 am
Fuel, rent, groceries, phone and internet access, insurances, retirement savings, medical expenses, etc, etc. Work out how much you have to spend per month, it's often more than you initially...
August 26, 2015 at 5:28 am
SELECT SUM(UnnamedColumn1) AS Total,
SUM(UnnamedColumn2) AS EmployeeCnt,
Parameter_3
FROM (SELECT DATEDIFF(s, MIN(CONVERT(VARCHAR(8), TRANSIT_DATE,...
August 26, 2015 at 4:24 am
Joy Smith San (8/26/2015)
however any suggestions for further investigation from that point of view ?
Yes. Don't try things at random.
Do your analysis. Identify the heaviest overall CPU-using queries. Tune them.
If...
August 26, 2015 at 4:17 am
High memory usage is by design. SQL uses memory, as much as you allow it to use, this is not a problem or something that needs to be fixed.
For high...
August 26, 2015 at 3:01 am
If you're talking about going solo:
Make sure you have 4-6 months income saved up. You'll probably need it.
Make sure you're comfortable with the non-technical side of things. Billing, finding work,...
August 26, 2015 at 2:49 am
joe.arias (8/25/2015)
DBCC FreeProcCache does clear sys.dm_exec_query_statsIf you are testing and tuning for performance, this can be invaluable way to save time.
It does, but it doesn't clear any other DMVs (other...
August 26, 2015 at 12:56 am
Correct.
There's no DMV which records usage, short of running every query with a traceflag on, it's very, very hard to tell that the optimiser found stats interesting.
You could, if you...
August 25, 2015 at 12:47 pm
In that case, this should work.
case when parts.ndc = '50242-0138-01' then CAST(labels.BAGSDISP AS Numeric(6,2)) *0.9 ELSE -1 end [Units Dispensed]
August 25, 2015 at 10:33 am
ChrisM@Work (8/25/2015)
cory.bullard76 (8/24/2015)
The values from labels.bagdisp range from 2-60. Is that what you are asking for?Gail's asking you to look at the table definition.
No, I wanted the range...
August 25, 2015 at 9:48 am
cory.bullard76 (8/24/2015)
The values from labels.bagdisp range from 2-60. Is that what you are asking for?
Half. Can you confirm there are *no* non-numeric values? (no 'abc', no '_', nothing except...
August 25, 2015 at 9:48 am
Brandie Tarvin (8/25/2015)
GilaMonster (8/25/2015)
djj (8/24/2015)
GilaMonster (8/24/2015)
August 25, 2015 at 6:06 am
Viewing 15 posts - 4,921 through 4,935 (of 49,571 total)