Viewing 15 posts - 4,846 through 4,860 (of 7,502 total)
- that setting can have the effect of >30 seconds.
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...
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...
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...
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...
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...
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 !
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...
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
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...
May 15, 2008 at 12:41 pm
I'm running sql2005 sp2 cu6 (client) and I also have the impression the first start takes longer than before.
btw:
did you disable the InternetExplorer settings / advanced / Security "Check for...
May 15, 2008 at 12:37 pm
- take a look at your maintenance plan execution history !
(rightclick maintenance plan)
- have a look at SQLServer errorlog.
May 15, 2008 at 6:00 am
No doubt about it. The methode Michael Earl proposed is the simplest !
- Simple
- Straight forward
- complete
- no log overhead
- the space you need = the space of your prod...
May 15, 2008 at 5:59 am
This would mean the column's value must exist in both "parent" tables ?
IMO that doesn't feel like it should.
A key is just a key and should represent nothing else...
May 14, 2008 at 8:02 am
If I'm correct, this is one of the features SQLCMD has.
You can use DOS-variables with it!
Check SQLCMD in BOL !
May 14, 2008 at 7:38 am
Viewing 15 posts - 4,846 through 4,860 (of 7,502 total)