Forum Replies Created
Viewing 15 posts - 5,836 through 5,850 (of 7,499 total)
-
RE: Quality Control with SQL Server
just wanted to ref to the sp2a article by Andy Warren : http://www.sqlservercentral.com/columnists/pressrelease/2906.asp
and its comments :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=112&messageid=349577#bm351006
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: granting create proc / func to create dbo objects
I guess a DDL-trigger might be the easyest way to do 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
-
RE: granting create proc / func to create dbo objects
thank you all for the replies.
I'll test the proposed paths.
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: Scripting SP2 & Cumulative hotfix (build 3152)
Be sure to make backups of _ALL_ databases !!
With sp1 you could use
SQLServer2005SP1-KB913090-x86-ENU.exe /quiet /allinstances
The same can be done for sp2.
Check SQL2005SP2_SETUP_sqlhotfix.chm. The parameters are described.
You can apply the HF...
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: Are these two Same ?
Your exists queries should do just fine !
And chances are they would be performing better.
Compare the execution plans ! and runtimes
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: Object id changes when columns are re ordered
probably someone use EM to change the table or used a script generated by EM.
It basicaly renames the old table, creates a newone, load the data, drops the old one...
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: Load Balancer and Connection Pooling
- I've got no experience on this matter but ....
- can you give us an idea of the number of connections you're expecting (x/min)
- what TPM are you expecting ?
-...
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: case sensitive sorting
your Q should be another thread, but this article contains some nice refs.
http://www.sqlservercentral.com/columnists/nboyle/speed_select.asp
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: function scope and how to call with ::fn_myfunction
that does rings a bell overhere
"If you don't use it , you tend to forget it"
Also...
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: case sensitive sorting
maybe clarifies collations and casesensitivity a bit for Bakr Ben Ayad
This was what we were refering to in our replies.
Putting all 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
-
RE: case sensitive sorting
or make the column case sensitive ...
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: function scope and how to call with ::fn_myfunction
...EXEC master.dbo.sp_MS_upd_sysobj_category 1 .. isn't a best practise !
Why marking a propriatary proc as system proc ?
I don't think it works the same way for...
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: SP Performance Difference
Start sqlprofiler for a while to captura all the load.
It shows the connection and execution settings !
You can load it into a table and analyse later 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: restore SQL 2005 on different server
Indeed you have to synchronise these local windows groups (created at install time of your sqlserver instance) when you restore master or if you granted them explicit on userdbs.
yourServerName\SQLServer2005MSSQLUser$yourServerName$yourInstanceName
yourServerName\SQLServer2005SQLAgentUser$yourServerName$yourInstanceName
yourServerName\SQLServer2005MSFTEUser$yourServerName$yourInstanceName
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: SP Performance Difference
also search your xml-execution plan for "CONVERT_IMPLICIT" . This can ruin your execution !
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 - 5,836 through 5,850 (of 7,499 total)