Viewing 15 posts - 4,846 through 4,860 (of 7,506 total)
always comming to the same problem, when not storing a column according to its natural datatype. :doze:
Declare @test varchar(15)
set @test = '9:08'
select REPLICATE('0',4 - datalength(replace(@test ,':','') )) + replace(@test ,':','')
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 18, 2008 at 8:40 am
- put a clustering index on that table ! (as tight a possible)
(or rebuild its clix)
Keep in mind, by setting a clustered index, it will need to rewrite the whole...
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 18, 2008 at 5:49 am
Indeed, the only way you can do this with the standard tools of sqlserver is by restoring the backup to another dbname, script the procs and functions.
Don't forget to script...
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 18, 2008 at 5:45 am
you can even avoid the splash screen by adding /nosplash to the shortcut statement.
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 17, 2008 at 9:31 am
keep in mind the "old" syntax (*= / =*) has been anounced for deprecation since SQL7.0 sp2.
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 17, 2008 at 9:29 am
- that setting can have the effect of >30 seconds.
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 16, 2008 at 7:21 am
The main difference with the join-syntax is that you have to know
the bases of your join.
e.g
select A.col1
, B.colz
from tablea A
, tableb B
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
May 16, 2008 at 6:54 am
Jason Clark (1/27/2005)
... renamed the new one,....
Just one remark:
Keep in mind that if you generate sql scripts for that db, because you renamed the sp, sqlserver did not change the...
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 16, 2008 at 3:31 am
You need at least CU1 if you have maintenance plans in use, because that one fixes issues with maintenance plans.
Currently we are installing CU5 to all our SQL2005 instances...
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 16, 2008 at 3:27 am
Indeed, you get the huge opportuninty :
- to meet your peers and discuss issues you experience.
- to meet the MS dev team(s) / PSS / SQLCAT and discuss issues 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
May 16, 2008 at 12:20 am
form the little experience I have with clr: I wouldn't use it with web services. Many forget a webservice is to be considered asynchronous.
If it needs to much of your...
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 15, 2008 at 1:26 pm
Minaz Amin (5/15/2008)
...I am applying SP2 now on the server ..hope this resolve. Please send me suggestions.
...
Be sure to also apply Cumulative update 5 !
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 15, 2008 at 1:00 pm
- Check your execution plans.
Compare both execution plans (SSMS query panel (Query / Include actual execution plan (Ctrl+M) )
- Do you have the needed indexes to support the join ?
edited:
on...
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 15, 2008 at 12:55 pm
--Query:
DECLARE @TempTable (IdTemp int, TempDate datetime)
INSERT INTO @TempTable (IdTemp, TempDate)
SELECT T1.Id, MAX(T2.Date2)
FROM Table1 T1
Left JOIN Table2 T2
ON T1.Id = T2.Id
GROUP BY T1.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
May 15, 2008 at 12:43 pm
Did you also apply Cumulative update 5 ?
I wouldn't advise CU6 because it has some start/stop issues with SSCM
(Unless you actualy want some fixes it contains)
- Are you using CLR...
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 15, 2008 at 12:41 pm
Viewing 15 posts - 4,846 through 4,860 (of 7,506 total)