Viewing 15 posts - 4,501 through 4,515 (of 7,506 total)
here's another test with the timestamp datatype:
/****** test script timestamp ******/
set nocount on
go
/*
@@DBTS returns the last-used timestamp value of the current database.
A new timestamp value is generated when 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
September 17, 2008 at 12:34 pm
I'm sorry for the xpost.
I originally posted in the wrong forum (sql2005)
Please reply to the sql2000 forum at
http://www.sqlservercentral.com/Forums/Topic571090-48-1.aspx
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
September 17, 2008 at 9:24 am
select dateadd(wk,36,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))
, dateadd(wk,37,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))
, dateadd(wk,38,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))
, dateadd(wk,39,master.dbo.fn_ALZDBA_convert_date2WeekRangeALZDBA ('20080104', 'F'))
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
September 17, 2008 at 6:08 am
it depends ..... What's your week 1 ??
Microsoft starts week 1 at 1/1 :crazy:
In my company, week 1 is the week which containns Jan 4th.
So we always need to check...
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
September 17, 2008 at 5:44 am
Jason Selburg (9/16/2008)
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
September 17, 2008 at 3:29 am
Bulk will ...
But you recipient table may have a clustering index, needing to reorder the rows.
Will sqlserver retrieve in the same order than you've put it in the table.
Most certainly...
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
September 16, 2008 at 3:17 pm
the sqlserver service account needs to have access to the backup file location (so don't use a mapped drive, but use unc if possible)
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
September 16, 2008 at 2:36 pm
IMO it is IO related so I would say 8 pages (i.e. 64KB )
However a table should have a primary key (and most tables have)
Also keep in mind, a unique...
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
September 16, 2008 at 2:31 pm
Steve Jones - Editor (9/16/2008)
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
September 16, 2008 at 2:17 pm
I would have performed that leaving the stand alone up and running.
Just install an extra on your cluster env. and then copy the users (ssis task) and move all databases.
Are...
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
September 16, 2008 at 1:55 pm
Can you post version information of your sqlserver .
Select @@version
or
Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion
, Serverproperty( 'Collation' ) as Collation
, Serverproperty( 'CollationID' ) as CollationID...
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
September 16, 2008 at 4:42 am
This one takes way to long !!!
Select RIGHT(F.[Number]+1000000000,9) as TheMissingKey
from ( Select substring(T1.TheMeaningfullKey, 1,4) as YYRR , max(T1.TheMeaningfullKey) as max_TheMeaningfullKey
from @YourTable T1
group by substring(T1.TheMeaningfullKey, 1,4) ) M
cross apply...
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
September 16, 2008 at 3:47 am
Oh boy, I messed up pretty well :blush:
I'll get back on this if I find some time today ...
For sure this way it will work, although it may take 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
September 16, 2008 at 3:18 am
- Can you connect from the witness to the principal or mirror using management studio and just execute some queries ?
- can you do the same using the witnesses service...
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
September 15, 2008 at 11:53 pm
it is for a range of dates..
test with this and you'll find its begin and end values.
declare @startdate datetime, @enddate datetime
SELECT @startdate = dateadd(dd, (-6 - DATEPART (dw, getdate())),DATEADD(dd,DATEDIFF(dd,0,getdate()),0))
...
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
September 15, 2008 at 11:40 pm
Viewing 15 posts - 4,501 through 4,515 (of 7,506 total)