Forum Replies Created
Viewing 15 posts - 6,421 through 6,435 (of 7,499 total)
-
RE: Dual Xeon 3.8GHz x64 processors with SQL Server 2000 + Windows Server 2003...performance hits
did you use sql-profiler to look what's going on ?
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
-
RE: Dual Xeon 3.8GHz x64 processors with SQL Server 2000 + Windows Server 2003...performance hits
offcourse .... your previous reply got me back to hinking ....
use yourdb
go
DECLARE @TableName nvarchar(261)
DECLARE @SQLStatement nvarchar(4000)
DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
SELECT
QUOTENAME(TABLE_SCHEMA) +
N'.' +
QUOTENAME(TABLE_NAME)
FROM
INFORMATION_SCHEMA.TABLES
WHERE EXISTS
(
...
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
-
RE: Dual Xeon 3.8GHz x64 processors with SQL Server 2000 + Windows Server 2003...performance hits
count_rows : my mistake.
I mixed up DBCC UPDATEUSAGE ('yourdb') with count_rows. which should be done after the reindex as well !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
-
RE: Dual Xeon 3.8GHz x64 processors with SQL Server 2000 + Windows Server 2003...performance hits
You've run sp_updatestats.
Did you try to dbcc dbreindex('Yourdb') with count_cows ?
Be carefull, this will invoke heavy locking, so plan it to run in "easy" times.
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
-
RE: Removing BUILTIN/Administrator Login
You're no alone ...
With this site, you'll never walk alone
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
-
RE: Removing BUILTIN/Administrator Login
Thanks for the confirmation, Brian.
We did some testing regarding the clusterserviceaccount about 3 years ago.
It works just fine with these minimal rights (login 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
-
RE: Removing BUILTIN/Administrator Login
it even doesn't heed any rights but login because your clusterservices heartbeat uses it.
At our clusters the clustering service only was added as login for the server and it works...
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
-
RE: Dual Xeon 3.8GHz x64 processors with SQL Server 2000 + Windows Server 2003...performance hits
use profiler to intercept the activity and analyse !
especialy look for hints in statements. You could use a trace-flag for the system to disregard hints and see what th effect...
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
-
RE: Backing up Remote MSDE databases.
you could schedule a job at you "regular" sqlserver and have the steps execute OSQL
to backup the needed databases and then copy them to your safe place.
all steps would...
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
-
RE: how to avoid circular references using CTE ?
Thanks for the link, wich is a nice article.
The problem with these circular references is that I would need to exclude all "new" items that would already be in 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
-
RE: Role & Permission
oops .. overlooked that because we don't use it in that way 
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
-
RE: Role & Permission
- with SQLServer2005 you can perform this by granting at schema level.
- In sqlserver2000 you can only add the user to the db_owner group of the database. But then 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
-
RE: Row size limits
just my 2ct
nvarchar(..) is double byte so nvarchar(1000) takes max 2000 bytes + length indicator.
making it ntext will allow you to store up to 2G for that column.
Downsides 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
-
RE: Upgrade SQL2ksp4 to SS2005 keeps master dblevel 80 ??
globSMOSrv = the smo.server
as stated in the first of this thread :
oDatabase = globSMOSrv.Databases.Item("master")
in VS2005 immediate window
?oDatabase.CompatibilityLevel
Version80 {80}
?globSMOSrv.Information.VersionString
"9.00.1399.06"
Now what's the point of not having at least the system...
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
-
RE: Upgrade SQL2ksp4 to SS2005 keeps master dblevel 80 ??
The strange thing is that I can implement storedprocs that use e.g. CTE's and execute them without a problem or warning
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
Viewing 15 posts - 6,421 through 6,435 (of 7,499 total)