Forum Replies Created
Viewing 15 posts - 6,631 through 6,645 (of 7,499 total)
-
RE: Restore chain
Do I really need to wait 4 hours until I can start differential backup? Yes
Do I need to check error code (probably, yes, and how to do this) after 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
-
RE: How to script Indexes on SQL server DB?
Keep in mind some of them are created by implementing a constraint and need to be removed by drop constraint.
Here 's a little testcase to show how you can do...
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
-
RE: Backup Query
yep
Check sqlagent master-server
I cannot test it right now, but if i remember correct, it would for...
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
-
RE: Backup Query
in queryanalyser run :
restore headeronly FROM DISK = 'path\yourbackupfile.BAK'
I hope this helps.
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
-
RE: Login
from BOL :
Use sp_denylogin to explicitly prevent users from connecting with SQL Server, regardless of their Windows NT group memberships
With revoke you "drop" the user's login-id from the login's...
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
-
RE: Low Priority SQL?
I don't know of any executionpriority you can set, but you can set deadlock-priority.
set deadlock_priority low -- I wish to be the victim in case of deadlock !
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
-
RE: High CPU usage - Who?!
Guess what : I found this litle article ...
The waittype and lastwaittype columns in the sysprocesses table in SQL Server 2000
available at http://support.microsoft.com/default.aspx?scid=kb;en-us;822101
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
-
RE: Problem with a TSQL statment with Subquery
how about :
select ft.fno as DocGestao,
,round(sum(fi.ecusto*fi.qtt),2) as ValorGestao
,ml.adoc as DocCTB
-- ,(select (case when sum(edeb)=0 then sum(ecre) else sum(-edeb) end)
-- from ml ml1 (nolock)
-- inner join ft ft1 (nolock)...
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
-
RE: sql7sp4-server (winnt4sp6a) to much paged
Thanks for the reply, but the thread is over 1 year old
The sp-recompiles is what we've worked on, as well as ram-extention.
We've...
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
-
RE: Subquery problem
I think you only need this :
SELECT
a.fieldname,
a.Code,
CASE a.fieldname
WHEN 'Thing1' then b.Thing1
WHEN 'Thing2' then b.Thing2
WHEN 'Thing3' then b.Thing3
ELSE 0
END As Description
FROM ATable a
left join Thing1...
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
-
RE: is there a "Clean" funcion in SQL?
if you can handle the bit typework you might consider using the replace sql-function.
check BOL.
-- use select for POC-test
-- later alter to update-statement
select myalfanumber, replace(replace(upper(myalfanumber),'A','') ,'B',''),.... as mynumber
from mytable
where...
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
-
RE: High CPU usage - Who?!
As you might have found out, there is litle info regarding sysprocesses available on the web. (many using it, but none describing it)
So I fallback to sybase :
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
-
RE: High CPU usage - Who?!
You could also use sysprocesses for a quick ref.
This is a system-table, NOT to be modified/updated by anyone but the system !!
But you...
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
-
RE: Why To Reboot the Server?
I guess your reboot-policy comes from an NT-4 era
We only reboot if fixes are planned and installed or if our production-plant has a...
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
-
RE: How to capture taskmgr data ?
I've used PSTAT.exe from the Wk2 resource kit to capture the data,
then transfered the intercepted output to a central place
, imported them into SQL and ran a filterquery to...
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
Viewing 15 posts - 6,631 through 6,645 (of 7,499 total)