Viewing 15 posts - 4,906 through 4,920 (of 7,499 total)
yes
That still may affect other database(s) if that db is being refferenced by one of your other databases.
(e.g. in a view , procedure, ...)
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 1, 2008 at 2:36 pm
- Only if he shuts down the sqlserver service, it is safe to perform a disk copy, unless you are using softwares like red-gate sqlbackup or veritas sqlbackup,.. ....
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 1, 2008 at 8:55 am
- because you always learn stuff you can implement immediatly for local benefit.
- and because it is big fun to meet your peers in and out of geek city 😉
-...
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 1, 2008 at 7:55 am
nkm129 (4/30/2008)
Only think what is left here How to copy my backup to another disk.. I tried xp.cmdshell but...
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
April 30, 2008 at 5:18 am
Mike Hinds (4/29/2008)
I act as though my fellow IT workers (especially "superusers") are my biggest danger.
And they are !
That the top reason to remove builtin\administrators from your sql...
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
April 30, 2008 at 1:49 am
Oh yes, there can only be one clustering index per table.
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
April 29, 2008 at 7:52 am
- dynamic ports in use ?
If an instance uses dynamic ports, it may receive another portnumber when it is (re) started !
Check your sqlserver errorlogs to figure out if 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
April 29, 2008 at 4:04 am
- do you use dynamic ports or fixed portnumbers ?
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
April 29, 2008 at 2:50 am
- do you rebuild the indexes on a regular basis ?
(if you have SQL2005 EE, you can do that online !)
- Check if you really need the 'distinct'...
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
April 29, 2008 at 12:35 am
- do you have more than one named instance on that server ?
- can you connect using the instances portnumber ?
- I have a similar issue with one server hosting...
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
April 29, 2008 at 12:33 am
I always use backup devices and withing a cycle (between full backups) have my log-bacups incremental.
Only very rare I've noticed backups failing because of the device.
We regulary test pit-restores and...
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
April 29, 2008 at 12:00 am
GSquared (4/28/2008)
just so long as only one of them is clustered.
It is not mandatory to have a clustering index, but I'd advise to always have one.
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
April 28, 2008 at 11:53 pm
did you try the "for each loop" container to get this doen (in stead of a script task)
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
April 28, 2008 at 10:49 am
peace2007 (4/26/2008)
Does it mean there's no tool to show that in diagram?:(
AFAIK you dan define logical relationships in ERwin in the logical model.
But I think that will be about 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
April 28, 2008 at 8:03 am
A PK is mainly for DA-purposes, to document the key that will be used to support FK-references to your table. ( http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/
)
Nowadays many rdbms systems only need 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
April 28, 2008 at 2:38 am
Viewing 15 posts - 4,906 through 4,920 (of 7,499 total)