Viewing 15 posts - 5,281 through 5,295 (of 7,499 total)
and whyle you're at it ....
Split user object and system objects.
Create another filegroup, set it to be the default.
Move all your tables/clustered indexes to it.
There will be no immediate profit,...
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
January 28, 2008 at 12:31 am
- use auto update stats in the database options. This way you can lower the frequency of your updatestatistics job
Is this a SQL2005 enterprise edition ?
also schedude online index...
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
January 27, 2008 at 12:58 am
yep.
That's how I would do it.
btw.you can install the instance using dynamic ports, up to the sp/cu level you want it to be and then fix the portnumber.
Maybe it isn't...
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
January 27, 2008 at 12:54 am
If you cannot convert to set-based inserts (preferable bulk inserts) ...
skip the "if exists" but use the new SQL2005 try catch methode and put a unique constraint at the field...
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
January 26, 2008 at 12:02 pm
just my 2 ct
- with mass deletes:
- limit the number or deletes per transaction to avoid (dead) locking.
- perform full table(s) maintenance after the operation 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
January 25, 2008 at 3:59 am
-if the cmdshell hadn't been actived, the exec would never work.
- put a print statement right befor the exec statement
print 'cmd: ' + @cmd
this way you'd...
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
January 25, 2008 at 12:16 am
well ... let's hope you are on SP2 with at least CU4.
- install MS performance dashboard (download free at MS):cool:
download it an install at as well client as server. 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
January 23, 2008 at 1:14 pm
By the way (almost forgot)... they haven't fixed the code windows on this forum, yet. If you just copy and paste, they come out all on one line.
If you...
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
January 23, 2008 at 8:15 am
I should also note that after I created the partitioned table, I created a clustered Primary Key Index that was NOT partitioned (since the PK is different than the partitioning...
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
January 23, 2008 at 6:35 am
saveguard the query. :rolleyes:
There's some nice data in the box.
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
January 23, 2008 at 5:32 am
probably access via cmdshell is prohibited.
I've seen installations that raise a system error and log it into an audit log.
Contact the sysadmin(s).
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
January 23, 2008 at 4:45 am
2008-01-17 19:59:53.000 2008-01-17 19:59:53.000 d:\t1.bak 65 24 3 T1 backup NULL 5000000040800001 5000000041100001 L
2008-01-18 16:01:40.000 2008-01-18 16:01:40.000 d:\t1.bak 56 24 5 t1 backup NULL 5000000040800001 5000000042700001 L
since these logbackups start...
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
January 23, 2008 at 3:34 am
as stated in your OP, DTA does not support SQLExpress !
So you cannot use DTA with an SQL2005 express edition instance.
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
January 23, 2008 at 3:11 am
I have the impression you would like to use a "general code table" kind of table to keep track of your "sequencenumbers".
That might work, but keep in mind you may...
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
January 23, 2008 at 3:07 am
can you post the results of this query ?
select BS.backup_start_date
, BS.backup_finish_date
, BMF.physical_device_name
--, BMF.logical_device_name
, BS.backup_set_id
, BS.media_set_id
, BS.position
, BS.name
, BS.Description
, BS.first_lsn
, BS.last_lsn
, BS.type
-- , BMS.*
from msdb.dbo.backupset BS
inner join msdb.dbo.backupmediaset BMS
on BS.media_set_id =...
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
January 23, 2008 at 3:03 am
Viewing 15 posts - 5,281 through 5,295 (of 7,499 total)