Viewing 15 posts - 5,086 through 5,100 (of 7,502 total)
k.przewozniak (3/12/2008)
And how will I know that "verify"...
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
March 12, 2008 at 7:21 am
if you tick "verify backup integrity" it performs this:
BACKUP DATABASE [admin] TO [adminFull] WITH NOFORMAT, NOINIT, NAME = N'admin_backup_20080312141909', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId...
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
March 12, 2008 at 7:20 am
- I would advise to use a datetime variable in stead of a smalldatetime.
- probably the other sql2000 run on another servicepack as the one where it fails.
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
March 12, 2008 at 7:10 am
did you test the scripts we provided ?
They may be your starting point.
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
March 12, 2008 at 3:18 am
$sanjayattray (3/11/2008)
USE [master]
GO
ALTER DATABASE [xyz] SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [xyz] SET ...
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
March 12, 2008 at 3:15 am
Suppose your filegroup contains 3 files,
data is balanced over these 3 files.
If you empty one file, the data will be spread over the remaining
2 files within the same filegroup.
Keep in...
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
March 12, 2008 at 3:12 am
- another thing to keep in mind is that you need more authority to
be able to use truncate compared to delete.
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
March 11, 2008 at 9:13 am
Well, since this is sql2005 right ?
As from sp2 you can use login triggers.
So if your application logges into the server connecting to the appropriate database, you might update...
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
March 11, 2008 at 8:21 am
- I'm glad to see you've set the max server memory for this instance !
This is a must for large systems.
- did you configure the os best performance for programs...
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
March 11, 2008 at 7:54 am
btw you can exclude a table for autoupdate statistics by using
sp_autostats [ @tblname = ] 'table_name'
[ , [ @flagc = ] 'stats_flag' ]
...
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
March 11, 2008 at 7:44 am
- So does the proc reside in every individual db ?
If not, make sure you've installed it in master, called it sp_*** and marked it as systemobject (database transparency)
e.g. exec...
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
March 11, 2008 at 7:24 am
Per current performance data it has executed the delete 787x and has take 45s CPU, 52s duration, and 21093244 Logical Reads.
Yep, that's what occurs with delete.
A truncate is only...
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
March 11, 2008 at 7:11 am
Truncate is the fastest way ! (minimal logged)
Delete is a logged operation and will cause the most locking overhead as well as logging overhead (db-logfile)!
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
March 11, 2008 at 6:14 am
For the non catalog files you can use:
DBCC SHRINKFILE ( file_name , EMPTYFILE )
and later on
alter database xyz REMOVE FILE logical_file_name
Read BOL for more...
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
March 11, 2008 at 1:36 am
Oops, I missed the reconfigure statement.
That's why not all config options show up.
exec sp_configure 'show advanced options' , 1
reconfigure
exec sp_configure -- information (extended info activated please)
Can you post again...
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
March 11, 2008 at 1:21 am
Viewing 15 posts - 5,086 through 5,100 (of 7,502 total)