Viewing 15 posts - 4,921 through 4,935 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 26, 2015 at 7:24 am
Nope. Only when they're on a join or where clause predicate which prevents index usage.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 26, 2015 at 5:28 am
What do you mean 'add drives'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 26, 2015 at 4:25 am
SELECT SUM(UnnamedColumn1) AS Total,
SUM(UnnamedColumn2) AS EmployeeCnt,
Parameter_3
FROM (SELECT DATEDIFF(s, MIN(CONVERT(VARCHAR(8), TRANSIT_DATE,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2015 at 9:48 am
Brandie Tarvin (8/25/2015)
GilaMonster (8/25/2015)
djj (8/24/2015)
GilaMonster (8/24/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2015 at 6:06 am
Viewing 15 posts - 4,921 through 4,935 (of 49,552 total)