Viewing 15 posts - 4,501 through 4,515 (of 7,499 total)
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
Because of the way sqlserver log files work, you can only shrink up to the last chunck in use.
Considering the error you got, I'd say enlarge the log 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
September 15, 2008 at 11:06 am
- did you change e.g. sqlagent service account recently ?
- did you remove e.g. builtin\administrators from you sql instance before altering sqlagent service account ?
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:02 am
There can be any number of databases in sqlserver.
You have 4 system databases:
-master
-msdb
-model
-tempdb
(you can have some more in a distribution context)
All other databases are user databases.
So you need to...
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 9:42 am
dva2007 (9/15/2008)
Hi ALZDBA,I have found all invalid data. It is there for some reason. so i just need to ignore those particular records.
Thanks for your help.
This is typical abuse...
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 8:02 am
Dugi (9/15/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 15, 2008 at 7:24 am
http://www.sqlservercentral.com/articles/SQL+Puzzles/findinggapsinasequentialnumbersequence/2336/
http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/
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 5:17 am
I would say their windows firewall isn't opened to use the sqlserver ports.
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 5:15 am
Viewing 15 posts - 4,501 through 4,515 (of 7,499 total)