Viewing 15 posts - 496 through 510 (of 631 total)
I know this is not an answer to the question you've actually asked, but if your report is required to be accurate, remove the NOLOCK hints.
They're not a magic 'go...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 20, 2012 at 5:22 am
If you're looking for 'self-service' reporting, have you consifered using SSAS and SSIS for this, rather than building your own solution?
It's a lot more intuitive for most end-users
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
October 12, 2012 at 3:55 am
Does it run OK if you add with recompile?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 28, 2012 at 5:56 am
SQL Server backups of all types are an online operation. Having people working while they occur is no problem ta all. Are you taking log backups throught the...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 30, 2012 at 4:10 am
Personally, rather than regenerate it like that for every query, I'd take the output and put it into a Date Dimension table
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 8, 2012 at 2:57 pm
ColdCoffee (5/7/2012)
I cant think of any way other than putting all those 50 columns in a WHERE clause.Lets wait for the heavyweights to throw their thoughts on this
Err- Lynn...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 2:14 pm
ColdCoffee (5/7/2012)
I cant think of any way other than putting all those 50 columns in a WHERE clause.Lets wait for the heavyweights to throw their thoughts on this
Ah also...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 2:13 pm
ColdCoffee (5/7/2012)
I cant think of any way other than putting all those 50 columns in a WHERE clause.Lets wait for the heavyweights to throw their thoughts on this
Might be...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 2:09 pm
L' Eomot Inversé (5/2/2012)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 1:59 pm
TravisDBA (5/1/2012)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 1:29 pm
majorbloodnock (5/1/2012)
Eric M Russell (5/1/2012)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 7, 2012 at 1:13 pm
Are the filenames for the logs on both servers the same?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
May 1, 2012 at 4:03 pm
Have you tried checking that the appropriate permissions are in place? Does the login being used actually have access to that directory?
Just a gut feeling - never used C...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
April 30, 2012 at 4:43 pm
Have you tried taking the Access query and refactoring it appropriately as a SQL Server stored procedure and calling that from access instead?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
April 30, 2012 at 4:37 pm
As far as I'm aware, you cannot take a table snapshot (but there are rather talented people on here who may prove me wrong). If I were you I'd...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
April 30, 2012 at 4:23 pm
Viewing 15 posts - 496 through 510 (of 631 total)