Viewing 15 posts - 4,891 through 4,905 (of 7,499 total)
If you can figure out wich filenumber it is writing to, you can load it up to the lower filenumber.
Don't use the "default" keyword, because that will try to load...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 2:27 pm
how about
Select Region
, sum(case Closed when 1 then 1 else 0 end) as Closed
, sum(case Closed when 1 then 0 else 1 end) as NotClosed
from [dbo].[hdRequests]
group by Region
order by...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 9:16 am
You may have to perform this proc more than once because sqlserver can
only shrinkt op to the last active log part.
Source urls are included.
Play it safe, take a full...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 9:11 am
You would have better posted this in the sql2000 forum.
- You could enable "audit login" for all. This reports logins to sqlserver errorlog. (Serverproperties page (Security) in EM)
- you could...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 9:08 am
juts a first glimps:
- alter
select distinct Trust, InitialReview = ISNULL(convert(varchar(10),initialReview),0)
,ReReview = ISNULL(convert(varchar(10),reReview),0)
,TotalReview = ISNULL(convert(varchar(10),TotalReview),0)
--,Approval = ISNULL(convert(varchar(10),Approval),0)
--,QA = ISNULL(convert(varchar(10),QA),0)
,[TotalQAApproval] = ISNULL(convert(varchar(10),[TotalQA/Approval]),0)
,[TotalProcessed] = ISNULL(convert(varchar(10),TotalProcessed),0)
from vW_total_numbers
--where left(trust,8)...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 7:42 am
Thank you for highlighting this valuable feature.
Saving +60% is certainly worth investigating it to the bone, considering the vase amount of backup data we produce.
Nowadays we compress the backup by...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 5, 2008 at 6:33 am
just to add:
It's not mandatory to have diff backups.
Differential backups can help out if you have a huge log-backup load.
In that case,by using diff backup, you can skip restoring log...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 2, 2008 at 2:17 pm
- as already mentioned, IO is probably the most slowdown factor.
- do you rebuild indexes (clix / nci) on a regular bases ?
- check your db for "auto update statistics"....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 2, 2008 at 2:10 pm
...requires a unique key column to display the data....
Keep in mind you'll not be able to use that key column to go back to the db !
Isn't a combination of...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 2, 2008 at 2:03 pm
- Write the message to a proprietary message table and let the job that is started by the alert read that table and cleanup the data.
- SQLServer Service Broker can...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 2, 2008 at 7:51 am
Get rid of the cursor !
use this instead:
update P -- I supposed you want to modify UsgSvcMultiProvision.StatusID
SET StatusID = @ProvStatusID
FROM UsgSvc U
inner join Customer C
on U.CustID...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 2, 2008 at 7:27 am
Job well done ! :smooooth:
Now determine what kind of backups you want to take, what kind of recorvery timeframe you need,...
(also re-evaluating your db-recovery-settings (simple/bulk logged/full)
Read books online for backup...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 1, 2008 at 3:06 pm
your information schema check executes in context of the current database you are connected with !
If you are not connected to the @dbname, you are validating other data !
So
If...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 1, 2008 at 2:57 pm
Be carefull when removing builtin\administrators.
First of all grant your dba(-group) sysadmin (windows) rights for the sqlserver instance !
for windows accounts, you'll have to grant serveraccess and access to the needed...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 1, 2008 at 2:52 pm
at least a fetch should have an into section
FETCH NEXT FROM Employee_Cursor into @colvar1,@colvar2
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
May 1, 2008 at 2:45 pm
Viewing 15 posts - 4,891 through 4,905 (of 7,499 total)