Viewing 15 posts - 4,591 through 4,605 (of 7,499 total)
For the moment we are using vbscript to gather WMI information.
You may as well put that into a clr module and get your info that way.
Keep in mind you'll need...
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 7, 2008 at 3:12 am
X64 is not Itanium, but is 64 bit.
64-bit can directly address way more than 16Gb http://techreport.com/articles.x/8131/2 or http://en.wikipedia.org/wiki/X86-64
Thats why you don't need to enable AWE anymore on 64-bit.
You need 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
September 7, 2008 at 2:57 am
you could deny a user access to a table using:
DENY { ALL [ PRIVILEGES ] }
| permission [ ( column [ ,...n ] )...
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 6, 2008 at 11:31 am
There are articles at SSC regarding db ownership.
e.g. http://www.sqlservercentral.com/articles/Advanced/understandingobjectownership/1966/
We don't use sa for login, but have all databases owned by sa.
All sysadmin stuff is being performed using our windows-admin-accounts. (dbas...
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 6, 2008 at 11:28 am
You could offer the dba a weeping tissue because he's the one messing up. They will have to modify their code.
As already stated : If you want order, you need...
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 6, 2008 at 11:20 am
MS has released a Upgrade assistant for Access.
(free tool)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
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 6, 2008 at 7:20 am
Warren Peace (9/5/2008)
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 5, 2008 at 12:40 pm
As usual, security has been optimized in sql2005 !
For a proc to work in a database context, it needs to be in that database,
except for procs (residing in master...
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 5, 2008 at 12:34 pm
marco.crescini (9/5/2008)
...ten mnutes ago i rechanged the transaction log model to simple(minimun)...
- How big is your transaction log file ?
- what's the growth size for the log file ?
- is...
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 5, 2008 at 7:45 am
Everything will still work, but will only use a single db-thread to accomplish the queries.
So it may need more time to complete, but your error will nolonger occur.
You may 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
September 5, 2008 at 6:06 am
Can you apply the workaround (i.e. disable parallelisme) ?
from KB319184
WORKAROUND
To work around this behavior you can either:
•Use the query hint (MAXDOP=1) to avoid a parallel query plan.
-or-
•Set the max degree...
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 5, 2008 at 4:11 am
Did you read and apply the hotfixes mentioned in KB918483 http://support.microsoft.com/kb/918483
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 5, 2008 at 3:32 am
are you using AWE ? http://support.microsoft.com/kb/899761
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 5, 2008 at 3:09 am
8.00.2039 is the regular SP4
Is this a multi processor or multi core box ?
if yes: IMO your should apply the cumulative hotfix I mentioned earlier.
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 5, 2008 at 2:23 am
Chandu (9/4/2008)
Then, multiple instances will occupy huge space.. right ?.. i mean 2 instances will occupy double space
Your extra software will need space, your extra databases will need space, your...
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, 2008 at 11:53 pm
Viewing 15 posts - 4,591 through 4,605 (of 7,499 total)