Viewing 15 posts - 2,866 through 2,880 (of 7,502 total)
If you design it well, it may.
That's why you should especially take care of your indexes to be alligned.
This is one of the reasons why you must first read about...
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 9, 2010 at 12:26 am
classic answer : It depends.
In some cases partitioning may be a great solution (ent edtn only)
The problem will always be : how does sqlserver detect "date range" to filter its...
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 8, 2010 at 2:00 pm
AndrewSQLDBA (9/8/2010)
...The picture shows how I really feel at times ...
Welcome to the club :hehe:
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 8, 2010 at 1:53 pm
Is this a level 90 database ?
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 8, 2010 at 1:48 pm
- We create the backup file on the production server.
- Copy that file to safezone. (next step of the backup job)
This is scheduled at 19:30
On some of our dev...
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 8, 2010 at 1:42 pm
SKYBVI (9/8/2010)
RESTORE DATABASE XYZ
FROM DISK = 'E:\xyz_backup_201009022015.bak'
WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',
MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',
STATS=5
I recevied error:-
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving...
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 8, 2010 at 8:03 am
GilaMonster (9/8/2010)
Now here's an interesting question...Which is going to reach 20 000 posts first, me or the Thread?
Hurry up 😀
must be a photofinish :hehe:
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 8, 2010 at 7:58 am
Hi Steve , I hope you're not on the run for the forrest fire issues near Denver.
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 8, 2010 at 7:01 am
Thanks. Just making sure I didn't misinterprete it.
So, Ioana there is still a aftermath to do after the db got back online.
The provided urls should get you on track.
Simplefied steps:
--...
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 8, 2010 at 6:54 am
Did you try your restore using the "restart" parameter ?
I've had a similar issue with a bak file >99Gb.
If I'm correct, it was related to some W2003 32bit bug...
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 8, 2010 at 6:28 am
Hi Gail, Sorry for hopping in but would this be a typical case of VLF fragmentation ?
ref: Monitoring SQL Server Virtual Log File Fragmentation
Performance impact: a large number of...
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 8, 2010 at 6:20 am
- what kind of size are we talking about (current , target) ?
- how long did you wait for it to complete ?
- check (b)locking when you run dbcc shrinkfile...
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 7, 2010 at 12:04 am
You mean in the DDL of these objects ?
check database triggers !
e.g. http://www.sqlservercentral.com/scripts/DDL+Triggers/64536/
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 6, 2010 at 12:45 am
If it's a huge database you can add the "restart" parameter to your (original) restore statement, and it will pick it up where it got killed.
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 4, 2010 at 2:16 am
Make it "foolproof" and they'll come up with a better fool 😀
Thumbs up for the new job ...
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 3, 2010 at 5:01 am
Viewing 15 posts - 2,866 through 2,880 (of 7,502 total)