Viewing 15 posts - 3,406 through 3,420 (of 18,926 total)
Eugene Elutin (8/10/2011)
Ninja's_RGR'us (8/10/2011)
... but I wouldn't spend 1 year refactoring an app without more proof of the benefit...
seriously, as a contractor, in a such economy hardtime, I definitely would...
August 10, 2011 at 11:55 am
Am I clearer by saying this instead?
sp_updatestats AND updatestats X keep the current sampling rate
UDPATE STATS WITH <fullscan or smapling rate> overwrites the old setting and saves the new one.
August 10, 2011 at 11:44 am
doug 40899 (8/10/2011)
Ok so I was told just a moment ago that both hour and minute would need to be included in my SP. What's the syntax for that?
SELECT
--removes ms,...
August 10, 2011 at 11:41 am
Here's a formatted version. If you want us to help with this please post the actual execution plan. We can do a few things to help, but not...
August 10, 2011 at 11:37 am
doug 40899 (8/10/2011)
Gila,Ok I'm not sure where to put that in with the SP. I assume because it's a declaration, that it goes before my SELECT statement. Correct?
Yes.
--making sure you...
August 10, 2011 at 11:34 am
rajeshn29.dba (8/10/2011)
Thanks Gila
This can help you have a much better understanding of what's going on (doesn't replace asking around, but helps a lot).
This is what activity monitor runs. You...
August 10, 2011 at 11:30 am
duncfair (8/10/2011)
Thanks.I had misunderstood and thought the setting effected future rebuilds.
Maybe just understood for the wrong object.
Statistics have this behavior. If you use sample 50% this time, then the...
August 10, 2011 at 11:27 am
Another PS. union = SELECT * FROM <2 queries> GROUP BY * (or select distinct).
This can be a very costly operation. If this is not the behavior you...
August 10, 2011 at 11:23 am
Something like this?
Full backup (I don't verify here because I do a test restore + checkdb())
DECLARE @Today DATETIME
DECLARE @BackupTime DATETIME
DECLARE @BkName AS VARCHAR(250)
DECLARE @Cmd NVARCHAR(1000)
SET @Today = DATEADD(D , 0...
August 10, 2011 at 11:17 am
Guras (8/10/2011)
We keep daily back ups of the database but unfortunately we don not keep the msdb history.
Well you could at least stop deleting it... In the mean time...
August 10, 2011 at 10:18 am
The reporting with this is minimal, but easily expandable.
http://www.red-gate.com/products/dba/sql-monitor/
You can check out a live demo of this site's sql servers.
August 10, 2011 at 10:15 am
mw112009 (8/10/2011)
And also in my situation the "Sub Report" is inside a Group.
What is happeneing is, I am passing a ID (...
August 10, 2011 at 10:14 am
jcrawf02 (8/10/2011)
Ninja's_RGR'us (8/10/2011)
For the next time around, you can use this tool, it generates the insert statement for the sample data. Takes only 2-3 secs per table...
It does? Didn't...
August 10, 2011 at 10:11 am
Do you take regular backups and do you keep the full history of msdb? If so I can give you a pretty darn good estimate of the growth based...
August 10, 2011 at 10:04 am
What application do you use to run this? Sql version (@@version)?
August 10, 2011 at 9:52 am
Viewing 15 posts - 3,406 through 3,420 (of 18,926 total)