Viewing 15 posts - 3,736 through 3,750 (of 7,506 total)
As shown in my previous reply a password encrypted master key can only be modified using the path of:
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'TestEncryption31' ; -- old...
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 3:16 pm
So this proves you actually have NULL s in the designated date column !
Since you didn't order the first time, these rows will have been some where random in 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
May 7, 2009 at 2:56 pm
Your variables content must match the predicates conventions.
In this case the conventions for Like.
Did you test this :
SET @Value = N'%My[_]Matching[_]Value%';
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 2:53 pm
skjoldtc (5/7/2009)
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 7:14 am
[
pp.pragnesh (5/7/2009)
I totally agree with you, many of the developers are using meaningless aliasing and that would be very tough to debug in future and waste of time. even...
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 5:51 am
I advise to use aliasses in all queries that involve more than one table, view, ...
This is really not a comparable issue for using leading commas, upper / lower case...
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 1:22 am
Please test this scenario (based on my previous post).
In my test it works on the second server.
edited this warning from BOL topic "ALTER MASTER KEY"
The REGENERATE option re-creates the database...
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:59 am
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
Viewing 15 posts - 3,736 through 3,750 (of 7,506 total)