Viewing 15 posts - 5,206 through 5,220 (of 7,502 total)
OT
As you will have noticed, readability is always an issue :doze:
Start using table_aliases in your queries !
e.g.
select you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .mycolumn
from you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too
inner join the_other_schema.the_other_object_name
on you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .PK = the_other_schema.the_other_object_name.theFKcol
...
will become
select...
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
February 15, 2008 at 12:39 am
In fact, schemas are menth to avoid this kind of actions.
SQL2005 wright ?
Schema should be a container for logicaly related objects.
check out ALTER SCHEMA schema_name TRANSFER securable_name
and ALTER AUTHORIZATION
...
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
February 15, 2008 at 12:30 am
I you honor your dba, give her/him a braek !
A cellphone and a decent laptop should do just fine.
Most companies would be better of by planning their IT actions,
this...
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
February 15, 2008 at 12:17 am
fwiw it searches for startup procedures...
... Are there startup procs ?
What kind of stuff do they perform ?
If I'm correct the $300 PSS is refunded if it is confirmd as...
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
February 14, 2008 at 2:41 pm
Today I've received this link and found it to be very to the point !
Windows ITPro
Best Practices for Backup and Restore in SQL Server 2005
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
February 14, 2008 at 12:34 pm
indeed the service account needs write rights to your unc folder \\Server\inv
That's why most of us use a simple sqlagent job to create backups.
Also if I were to use VB6...
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
February 14, 2008 at 12:30 pm
indeed, you _must_ use roles ( if you don't want every user to be full SSAS system administrator :crazy: ), but the level of granularity is something you'll have 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
February 14, 2008 at 7:06 am
I was under the impression that to view the advanced config required SQL to be restarted?
An instance restart is certainly not needed to view the advanced config settings !
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
February 14, 2008 at 5:43 am
Name Min Max Config_value Run_value
----------------------------------------------------
clr enabled 0 1 0 0
confirms CLR is not activated
Would you mind alowing to view all configs ?
That can be done with
-- enable advanced options
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
February 14, 2008 at 4:03 am
- can post the results of sp_configure ?
- does your server's windows eventlog mention (memory)bank issues ?
- do you have other issues with this server ?
-What's the minimum server memory...
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
February 14, 2008 at 1:55 am
There are many levels you can grant read access.
I'm afraid I cannot guide you through it at this time because I haven't played
around with it to know it to 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
February 14, 2008 at 12:44 am
- What's the size of the database ?
- what's the fragmentation level of the objects in the database?
- do you rebuild indexes often ?
- did you perform full database maintenance...
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
February 13, 2008 at 10:46 am
EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'CMDShellPROXY'
, @login_name=N'thejobowner'
(jobonwer as stated in the job!)
Also keep in mind the windows account that you provided for proxy
needs to have rights to read/write to the path you want...
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
February 13, 2008 at 7:44 am
join the club :w00t::alien:
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
February 13, 2008 at 6:31 am
USE [master]
GO
CREATE CREDENTIAL [CMDShellSQLAgentPROXY] WITH IDENTITY = N'awindowsdomain\account', SECRET = N'itspassword'
GO
USE [msdb]
GO
/****** Object: ProxyAccount [CMDShellPROXY] Script Date: 02/06/2007 11:30:44 ******/
EXEC msdb.dbo.sp_add_proxy @proxy_name=N'CMDShellPROXY',@credential_name=N'CMDShellSQLAgentPROXY',
@enabled=1,
@description=N'Provides CMDShell functionality...
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
February 13, 2008 at 5:34 am
Viewing 15 posts - 5,206 through 5,220 (of 7,502 total)