Viewing 15 posts - 2,866 through 2,880 (of 7,506 total)
Steve Jones - Editor (9/9/2010)
Jack Corbett (9/9/2010)
And that would be The White Shadow, right?The White Shadow? That's you isn't it? I can still (almost) dunk a basketball.
I thought it was...
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 10:26 am
GilaMonster (9/9/2010)
ALZDBA (9/9/2010)
Or maybe even contact Allen White via LinkedIn.Or just think about him really hard and he'll appear. 😀
Shall I demistify the magic ?
No ... we'll talk it...
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 10:19 am
Or maybe even contact Allen White via LinkedIn.
Send him my regards 😀 and buy him a good beer :w00t:
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 7:29 am
Did you try SQLserver BooksOnline ?
another must is the white paper at http://technet.microsoft.com/en-us/library/dd578580%28SQL.100%29.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 9, 2010 at 12:57 am
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
Viewing 15 posts - 2,866 through 2,880 (of 7,506 total)