Viewing 15 posts - 5,191 through 5,205 (of 7,499 total)
As you have noticed, SSIS can break at ## of places :crying:
And the wizard isn't as intuitive as the one for dts (sql7/sql2000)
You can enable ssispackage logging.
IMO SSIS is something...
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 19, 2008 at 12:18 am
the downside for the patterns is that you have to know them at front.
The downside for soundex is that it is language dependent !
(i.e. English)
btw just like DIFFERENCE(T1.LName, T2.LName)
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 19, 2008 at 12:04 am
If you want exact result, you need to specify exact predicates.
For similarity , you may want to experiment with soundex,...
There are examples at the SSC forums.
Read BOL for information on...
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 18, 2008 at 7:01 am
So the databases reside at the same server instance ?
Did you use DRI (Foreign keys) ?
For the first time only ! you could use this :
If yes :
- Did you...
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 18, 2008 at 6:55 am
I've created this little clr sproc.
You can easily profile it, but you need to select the storedprocedure
SP:Stmt... trace options to see what it is doing.
Kind of logical 😉
If 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 18, 2008 at 1:05 am
As Adam stated, the missing end statement with your case
statement is actualy the only thing I can find that would break your code.
I used SQL Refactor to parse 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 18, 2008 at 12:23 am
Maybe this script can help you a bit...
http://www.sqlservercentral.com/scripts/Miscellaneous/31808/
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 17, 2008 at 2:56 am
Just keep in mind to have your first aid kit available. 😀
Also there are # of articles/forumQ regarding CLR at ssc.
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 4:36 am
Very nice demo indeed ! 😎
Keep in mind CLR is a double edged knife.
You can easily cut your finger with 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 15, 2008 at 1:52 am
Well it certainly started with a great article, handling a fairly common issue 😎
And it resulted in a solution that worked a lightning speed and performed
the actual update in 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
February 15, 2008 at 1:38 am
Avoid providing sysadmin rights to non sqlserver applications !
Unless off course it is for a central configuration management system that
really needs to set sqlserver instance properties.
There are several other...
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 1:32 am
If DBCC opentran shows open transactions, these will be rolled back if you kill the connections !!!!
In that case you will loose data.
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:58 am
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
Viewing 15 posts - 5,191 through 5,205 (of 7,499 total)