Viewing 15 posts - 3,736 through 3,750 (of 7,499 total)
In your OP you state you are running SQL 2005.
Can you post the version info?
Select @@version
Can you also post the result of this ?
select MKP.*
, D.name as DbName
from sys.master_key_passwords...
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
May 7, 2009 at 12:33 am
psangeetha (5/6/2009)
We are facing this critical issue, I need some help from you experts. I ran the encryption and decryption procedures on prod db and created a new...
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
May 6, 2009 at 8:05 am
As MarkusB showed, dynamic sql is the solution if you want to do it using TSQL.
vbs or powershell using SQLSMO is an alternative.
FYI I use this script to add a...
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
May 6, 2009 at 4:05 am
It must be a bug.
I've tested in on SQL2008 SP1. (10.0.2531.0 (Intel X86) )
It gets even worse if you explicitly use the ID column in the filtered index definition.
(tested...
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
May 6, 2009 at 3:53 am
I wouldn't advise this kind of operation to a less optimal data type.
You lose all datatime functions and validations !!
Chose your level of detail !
declare @dt datetime
Select @dt =...
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
May 5, 2009 at 8:06 am
Adi Cohn (5/4/2009)
arun.sas (5/4/2009)
Hi Adi,Fine for the convert into varchar, but
OP shows convert to timestamp
ARUN SAS
Timestamp has nothing to do with date. Timestamp is just a binary column...
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
May 5, 2009 at 7:54 am
great article.
Thank you for pointing the known issue and the ref to connect.
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
May 5, 2009 at 12:16 am
FreeHansje (4/30/2009)
Have you ever benchmarked this MS_ForEachDB? I have, it's not good. And basically it's just another loop.
But as I mentioned before: it is not about a 'realistic' situation,...
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
May 4, 2009 at 2:41 am
also keep in mind when migrating an existing data system, you will have to deal with legacy short comings, data or data structures that doesn't make sense, but is those...
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
April 30, 2009 at 7:41 am
sam (4/29/2009)
ALZDBA (4/28/2009)
Not if you restrict it to only use 2.
Let me clarify - we have 8 processors and one instance right now. We will add an additional instance...
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
April 30, 2009 at 12:08 am
with ssis/dts you would have to check the packages connection data and queries. With each connection, you would also have to search for linked server queries,...
Same goes for .exe of...
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
April 29, 2009 at 1:07 pm
we just use sqlagent to take scheduled backups.
Because dbs are implemented according to a prepared schedule, we just refresh the needed jobs and allerts (% log full for incremental log...
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
April 29, 2009 at 12:59 pm
Not if you restrict it to only use 2.
Also keep in mind to restrict the "audit" instances max 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
April 28, 2009 at 11:54 pm
Thank you for the feedback.
Let us know if the hotfixes helped.
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
April 28, 2009 at 11:51 pm
aahh yes ... security granularity with SQL 2005 and beyond...;-)
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
April 28, 2009 at 1:35 pm
Viewing 15 posts - 3,736 through 3,750 (of 7,499 total)