Viewing 15 posts - 5,821 through 5,835 (of 7,505 total)
..Now I have to go find out why all our upgraded master databases are set to a compatbility level of 80...
If you've upgraded, the compatibility level has not been changed....
April 19, 2007 at 11:45 pm
maybe this can help you out ....
create table #PhoneCalls (CallId int not null identity(1,1) primary key, CallTime datetime not null, CallEnd Datetime not null default ('9999-12-31 00:00:00.000'), CallDuration int not...
April 19, 2007 at 5:33 am
as you will have noticed, SSIS is not cluster aware. What I mean is SSIS is not member of a cluster group, unless you install it yourself.
This means, you'll have...
April 18, 2007 at 1:34 pm
In short :
The delete query :
DELETE t1
FROM
(
SELECT
ROW_NUMBER() OVER
April 17, 2007 at 10:48 am
this works for me ...
I've created a table (csv_test) with 256 columns , saved the xls as csv and used this statement :
BULK
April 17, 2007 at 5:35 am
I've tested the # ways on a testbox singleproc 1,8mhz / 1GbRam with 10,000,000 rows per table and cleared buffers to begin with ...
April 17, 2007 at 4:39 am
I thought I just might add some refs regarding choices for SSB - MSMQ - Biztalk, ...
http://blogs.msdn.com/rogerwolterblog/archive/2006/02/28/540803.aspx
and even a middleway : http://weblogs.asp.net/gsusx/archive/2005/09/26/425989.aspx
April 17, 2007 at 4:22 am
- did you execute your dbmaintenance (dbcc dbreindex(yourtable) ) ?
April 17, 2007 at 3:02 am
1) Why are you using dynamic sql or this ?
2) there is something wrong itn the last innerjoin what are you innerjoining with ? (there is no match with the...
April 16, 2007 at 2:41 pm
select ...
from table1 T1
inner join table2 T2
on T2.servername_loginname like '%' + T1.Loginname
or
select ...
from table1 T1
inner join table2 T2
on substring(T2.servername_loginname, charindex('_',T2.servername_loginname) + 1, len(T2.servername_loginname) = T1.Loginname
April 16, 2007 at 8:55 am
Isn't that one of the goals of this kind of forums ?
No only to be creative, but being creative in an reasonable way
April 16, 2007 at 6:37 am
choosing will not be difficult at all ... compare execution plans !
If they are equal : pick one
If they are not equal, the choice is obvious
April 16, 2007 at 5:35 am
DELETE t1
FROM yourtable t1
inner join (select AccountID , max(MyDateTime 
as MaxDateTime
FROM yourtable
group by AccountID ) t2
on...
April 16, 2007 at 4:10 am
This thread contains a very good syntheses regarding Clustering. ![]()
Also keep in mind that for best practise , you should check that your clustering...
April 13, 2007 at 12:56 am
Viewing 15 posts - 5,821 through 5,835 (of 7,505 total)