Viewing 15 posts - 8,371 through 8,385 (of 49,571 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...
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.
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...
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...
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...
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...
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?
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?
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...
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...
July 22, 2014 at 5:19 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...
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...
July 21, 2014 at 5:43 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...
July 20, 2014 at 2:47 pm
Viewing 15 posts - 8,371 through 8,385 (of 49,571 total)