Forum Replies Created
Viewing 15 posts - 6,751 through 6,765 (of 7,499 total)
-
RE: A bit stuck... xpert help needed! Joins and unions etc...
Is this what you mean ?
-- Begin Tran
-- update T
-- set end_date = MEdt.MaxEndDate
select T.*
, MEdt.MaxEndDate
, Mmog.Maxmemberofgroup
from mytable T
inner join
(
select person_id ,max( end_date ) as MaxEndDate
from mytable
group by person_id
)...
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: There''''s GOTTA Be a Better Way!
... (repeat 80,000 times)....
with waitfor delay '00:01:00' ?
Adjust the set rowcount ***
select dateadd(mi,80000,getdate()) - getdate()
results :
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: There''''s GOTTA Be a Better Way!
set rowcount 100
declare @ctr as int
declare @TOTctr as int
select @ctr = 1, @TOTctr = 0
while @ctr > 0
begin
delete from history_log where event_date < '1/8/05'
set @ctr = @@rowcount
set @TOTctr...
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: Server Crash
If you have reinstalled exactly to the situation like before the crash, then you can just copy all mdf, ldf, ndf files (also master and msdb if you have kept...
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: Kill without Rollback?
- Logical dataconsistancy is a user problem.
- Physical dataconsistancy is a sqlserver problem ! This means a transaction is OK or it must...
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: Help in joining three tables for COUNT
Is this executed on a sql2000 sp3a multiproc box ?
If yes : did you install the hotfix for count(*) ?
Microsoft Knowledge Base article number Q814509
"FIX: A Parallel Query with 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: Kill without Rollback?
No, because then you would have inconsistend data !
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: rescheduling sql job
keep in mind the security restrictions for job-alters. Don't run your app with sa-permissions!
declare @NewDate as int
declare @NewTime as integer
declare @dtNewTime as datetime
-- wait for 45 minutes
set @dtNewTime = dateadd(mi,45,getdate())
select...
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: Not Returning any records using CONTAINSTABLE
did you create a full-text-index ?
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: Clean up indexes.
- Are your stats up to date ? (can you execute sp_updatestats / dbcc updateusage )
- I'd start off with all indexes which have a minor filter ratio (cardinality).
- 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: memory
can you post the DDL for the table and the view so we can see what might be goin wrong ?
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: Frank''''s Addition to Family
Don't ask for my picture, WWF may might just publish me as "endangered species"
My Girls are 40
...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: SQL2000 Stored Procedures run WAY slower than straight TSQL Queries?
- did you take a look at locking ? maybe http://www.sqlservercentral.com/scripts/contributions/826.asp can help out.
- Maybe executing the sql with (nolock) hint will deliver sufficient data.
(be aware of uncommitted data...
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: Using a between statement within a case statement
case when yourcol between x and y then 'xy'
when yourcol between a ane b then 'ab'
else 'not between'
end
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: Update numbers in a field
update yourtable
set yourcol = replace(replace(yourcol,'2','"'),'1','!') --
where yourcondition
Check out "replace" in books online
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,751 through 6,765 (of 7,499 total)