Viewing 15 posts - 1,306 through 1,320 (of 7,503 total)
Thank you for the feedback.
Now I get it too :w00t:
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
September 4, 2012 at 7:22 am
I only see that column being non-zero for sproc
msdbsp_delete_job_references
At this moment I cannot tell you what that actually means or why it defers from the others.
did you have a look...
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
September 4, 2012 at 2:55 am
calling the sproc with different settings on you connection will be enough for sqlserver to generate another plan. ( ansi settings )
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
September 3, 2012 at 8:24 am
from Books online : http://technet.microsoft.com/en-us/library/ms178615.aspx
STANDBY =standby_file_name
Specifies a standby file that allows the recovery effects to be undone. The STANDBY option is allowed for offline restore (including...
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
September 3, 2012 at 8:18 am
As long as you stay on the same SQLInstance, it should be OK.
Just:
1) create another DB ( enable ownership chaining )
2) create the table you need
3) grant the account being...
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
September 3, 2012 at 8:12 am
way to late ( due to summer holidays ) but here are the results on my dev server ...
I loaded 1000000 rows is MytestTable;
use SSC_Test
/*
DECLARE MytestTable TABLE ( col1 INT,...
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
August 29, 2012 at 7:26 am
Great thinking pattern !
Marvelous results !
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
August 23, 2012 at 5:33 am
You'll need to be granted
VIEW SERVER STATE
and
VIEW DATABASE STATE
to be able to use the mentioned DMO in Glens script.
We grant these privileges to our devs (dev and qa instances)...
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
August 23, 2012 at 4:07 am
Have a look at the wonderful scripts Glen provided for us .
SQL Server 2005 Diagnostic Information Queries by Glenn Berry
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
August 23, 2012 at 12:37 am
Both queries look the same to me ...
Except for the cast clauses used with the second one !
Are you sure your @varriable-content isn't longer than 10 characters ?
where SetupDetailsId...
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
August 23, 2012 at 12:28 am
Apparently you didn't want to do a one by one approach, just generate your stuff !
Select 'ALTER LOGIN ['+ name + '] DISABLE ; '
from sys.server_principals
/* exclude disabled accounts, sysadmins...
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
August 22, 2012 at 12:10 am
Just disable the logins and the engine won't let anybody in !
It works as well for SQLUsers as for windows logins and groups.
ALTER LOGIN [AnySQLUser] DISABLE ;
ALTER LOGIN [yourdomain\your_windowsgroup_EXEPT_SQL_ADMINS] DISABLE...
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
August 21, 2012 at 11:54 pm
We always use Gert Drapers' solution mentioned at : http://www.sqlservercentral.com/Forums/FindPost368228.aspx
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
August 21, 2012 at 3:06 am
"auto close on property set to true"
If this is a production box, I recommend setting "auto close on" property to false.
This way sqlserver will bring the db online when 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
August 20, 2012 at 11:45 pm
You've seen the message:
The log for database 'Commun' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
it says ...check the eventlog...
I...
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
August 19, 2012 at 1:12 am
Viewing 15 posts - 1,306 through 1,320 (of 7,503 total)