Viewing 15 posts - 8,371 through 8,385 (of 49,552 total)
My question still stands. Why are you retrieving all 4 million rows and sending them to an application. Is there no filtering or aggregating that can be done in the...
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
July 22, 2014 at 9:29 am
Start by ignoring the CX packet wait. CX packet tells you queries are running in parallel. That is all.
Query please, plus table definitions, index definitions and execution plan.
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
July 22, 2014 at 9:26 am
truncate only is not a valid option when shrinking a log. If you don't specify a size, it will shrink as far as possible, probably requiring you to grow it...
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
July 22, 2014 at 6:31 am
New Born DBA (7/21/2014)
GilaMonster (7/21/2014)
Do you have scheduled test restores? Agent alerts? Job failure alerts?
We do get alerts time to time but its mostly because space issues or sometimes network...
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
July 22, 2014 at 6:29 am
Missing brackets around an OR? That will do it, AND has precedence over OR, so anytime you have OR and AND, you need to use brackets to ensure that the...
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
July 22, 2014 at 6:26 am
Table definitions, index definitions, query and execution plan please.
If it's just a SELECT * FROM Table, why? Why would you return every single row and column to the application? What...
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
July 22, 2014 at 5:37 am
1 out of three...
What's wrong then with just
WHERE [DATE] < '2014/06/30'
if all it's supposed to do is return rows with a date before the 30th June this year?
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
July 22, 2014 at 5:37 am
Table definition and easily usable sample data please (set of insert statements)
Exactly what is the query supposed to do?
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
July 22, 2014 at 5:30 am
ChrisM@Work (7/22/2014)
Something like this?
DECLARE @MinPeriod intSELECT @MinPeriod = MIN(a.period)
FROM agr.dbo.atrans a
CROSS APPLY (
SELECT CutOffTid = ISNULL(MAX(ccas_id),0)
FROM dbo.fbs_trans
) x
WHERE a.agrtid > x.CutOffTid
As Chris said, and then just wrap that...
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
July 22, 2014 at 5:21 am
Measure Up and the like copyright their questions, since they are a business. They have demos you can download, otherwise if you really want a practice test (and they're not...
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
July 22, 2014 at 5:19 am
Some bits from SQLBits
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
July 22, 2014 at 4:26 am
Doubt it has anything to do with the data type. Probably lack of parameter sniffing since SQL can't sniff the value of variables.
Will this be a procedure eventually? Will that...
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
July 22, 2014 at 4:19 am
Do you have scheduled test restores? Agent alerts? Job failure alerts?
Have you been practicing restores? Can you recover the system within your SLAs?
Are you capturing and reviewing performance metrics? Extrapolating...
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
July 21, 2014 at 5:43 pm
What do you mean by 'in sync'?
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
July 21, 2014 at 12:14 pm
And to re-enforce, I would be hesitant to take on a DR project for a critical DB as it's not something I'm incredibly familiar with. It's not something to be...
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
July 20, 2014 at 2:47 pm
Viewing 15 posts - 8,371 through 8,385 (of 49,552 total)