Viewing 15 posts - 4,876 through 4,890 (of 7,499 total)
You will have to execute the script with a connection to the dodgy database !
If that user was the actual database owner (<> member of db_owner group), it will not...
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 8, 2008 at 11:44 pm
This material seems quit interesting ...
- http://www.sql-server-performance.com/articles/per/2000io_config_sannas_p1.aspx
- http://sqlserver-qa.net/blogs/perftune/archive/2008/01/28/3300.aspx
- http://blogs.msdn.com/benjones/archive/2005/09/12/463964.aspx
- http://www.dell.com/content/topics/global.aspx/power/en/ps3q01_muirhead?c=us&cs=555&l=en&s=biz
- http://h71028.www7.hp.com/ERC/downloads/4AA0-2948ENW.pdf
(started at http://whitepapers.zdnet.com/abstract.aspx?docid=166254 )
Some of them are based on SQL2000, but I think the top basic rules are...
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 8, 2008 at 2:53 pm
keep in mind in this context "temp table" is an #-named table.
Don't create normal tables in tempdb ! You'll loose them at sqlserver restart time!
Create table #tmp (A int not...
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 8, 2008 at 2:41 pm
this script generates "user synchronisation" statements.
Maybe this will help out:
print 'print @@servername + '' / '' + db_name()'
print 'go'
go
declare @username varchar(128)
declare @Musername varchar(128)
declare @UserType Char(1)
declare @sql_stmt varchar(500)
declare @ExcludeWindowsAccounts Char(1)
set @ExcludeWindowsAccounts...
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 8, 2008 at 2:37 pm
- can you provide DDL for the objects (including indexes) ?
- many or-s, many functions for filtering (leftx,3) in (...)
may discourage index usage !
Post the execution plan...
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 8, 2008 at 2:33 pm
to see if you have IO problems regarding the tempdb you can offcourse always use:
/* track sqlserver IOstall time*/
set nocount on
SELECT ' use ['+ name +']
go'
+ case dbid when 1...
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 8, 2008 at 2:25 pm
-We record this at the sqlinstance itself and only grant insert access to that particular table of our "admin" db.
- This just to avoid having issues if your central audit...
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 8, 2008 at 7:23 am
:humble:
I'm not worthy to even read this article, but I've been a bad boy and did just that. 😀 Mea culpa.
Clear, to the point, no rocket science involved, practical, very...
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 8, 2008 at 4:59 am
Maybe this can help out:
- Beware this uses xp_cmdshell (should only be used by sysadmins)
- yep it uses a cursor, but in this case that's perfect.
- TEST IT - TEST...
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 8, 2008 at 12:25 am
Indeed, you can use UNC, as long as your service account/proxie account of your backup job has the rights to read/write at that location.
This also works on sql2000. (been using...
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 7, 2008 at 1:13 pm
IMO this union-part is far better readable/interpretable and less fault sensitive than the total of union parts provided in your script.
What you need to figure out is if 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
May 7, 2008 at 6:35 am
...more the apps hitting this table the ID seems to be the best candidate to be use as a primary key...
Setting a primary key by itself, is a conceptual issue.
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
May 7, 2008 at 1:47 am
If this is a "single user" database, you can also use the db option "auto close". This way you will free up system resources, the db is still available 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
May 6, 2008 at 1:47 am
Simon Facer (5/5/2008)
that script you published, I spent months getting rid of that very script from our production servers. You really need to add a line that categorically states that...
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 6, 2008 at 1:26 am
Isn't there a primary key / unique key missing ?
I mean, every row should have a unique pointer if possible at all.
My guess is your [id] column may be just...
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 5, 2008 at 2:38 pm
Viewing 15 posts - 4,876 through 4,890 (of 7,499 total)