Viewing 15 posts - 5,521 through 5,535 (of 18,926 total)
Never ever heard of @@version returning the wrong value.
How much did they charge vs the correct price?
June 7, 2011 at 5:43 am
Get a trial of sql 2008 R2 and run compression (you don't have that proc in 2005 so you just have to get 2008 to do this).
There's a proc that...
June 7, 2011 at 5:38 am
I know how to do that.... I was under the impression that you also did the time conversion?
As you might know... I don't run ALL my jobs at midnight FLAT...
June 6, 2011 at 11:11 am
Also I use this that I put on a report... could be better but it does the job nicely.
IF OBJECT_ID('tempdb..#enum_job') > 0
DROP TABLE #enum_job
DECLARE
...
June 6, 2011 at 10:48 am
Look up alerts and notification tabs in the job property window.
June 6, 2011 at 10:47 am
Nope I don't have that UDF.
I find it very hard to believe that nobody, ever, tried to solve this with a script.
The "good" news is that I only have 15-20...
June 6, 2011 at 10:44 am
My personal favorite is to run in profiler and choose the statement completed. So even for 1 proc you can see which statment is really hurting performance.
I like statistics...
June 6, 2011 at 10:12 am
tfeuz (6/6/2011)
The plan was included in the previous post -- I was simply posting a pitcture to get Wayne's comfirmation that I was looking in the same area...
June 6, 2011 at 9:57 am
The image of a plan is useless... we always need the actual .sqlplan file.
June 6, 2011 at 9:48 am
Here's the script and sample output.
SET IMPLICIT_TRANSACTIONS ON
SET DATEFORMAT YMD
SET STATISTICS IO OFF
SET NOCOUNT ON
--------Instructions----------
-- SET datetime of restore
-- You can exclude full backup file if they are corrupted at...
June 6, 2011 at 7:42 am
forsqlserver (6/6/2011)
June 6, 2011 at 7:20 am
An simple way to do this is to do a restore with norecovery. Even if that takes 1 day to do the move and restore it doesn't matter. ...
June 6, 2011 at 7:08 am
forsqlserver (6/5/2011)
Checkpoint command has no side effect so u can once run.
wft?
R u sure about that last comment??????????????????
June 6, 2011 at 2:50 am
Ludo-TRX850 (6/6/2011)
It's a long story of having to keep old huge Databases and going Live on a new one so a lot of the disks were used. This exercise was...
June 6, 2011 at 2:49 am
Viewing 15 posts - 5,521 through 5,535 (of 18,926 total)