Viewing 15 posts - 4,951 through 4,965 (of 7,499 total)
The little test ...
/*
use master
alter database SSC_TestBU set read_only with rollback immediate;
drop database SSC_TestBU;
alter database SSC_TestRcvr set read_only with rollback immediate;
drop database SSC_TestRcvr;
...
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 18, 2008 at 3:56 am
- What do you use to read the xls file ?
- did you try using DTS ?
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 18, 2008 at 3:00 am
- keep your head cool ( if you don't, no one else will do it for you !)
- have a look a sqlserver errorlog file and search for anomalies
- take...
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 18, 2008 at 2:58 am
- off course you cannot apply previous log-backups to the new full backup.
- every full backup starts a new recovery "cycle".
- For SQL2005 there is this new "copy_only" parameter that...
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 18, 2008 at 2:49 am
Marios Philippopoulos (4/17/2008)
...invoked from a SQL job ....
Especialy in that case, put it in a effective .net application or SSIS package and don't poison your db-server with it !
Prepare 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
April 17, 2008 at 7:54 am
you may want to have a look at fn_split kind of functions .
Maybe they may provide what you look for without using dynamic sql.
have a look at :
http://www.sqlservercentral.com/scripts/Miscellaneous/30225/
http://www.sqlservercentral.com/scripts/String+Manipulation/61509/
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 15, 2008 at 1:26 pm
Is someone using the "copy database" wizard ?
It proposes a "detach - attach" scenario. :sick:
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 15, 2008 at 6:29 am
Be happy it's only the clr going down.
I've had a whole instance going down when activating a memory hog CLR function.
http://www.sqlservercentral.com/Forums/FindPost457289.aspx
IMO This is one of the reasons to avoid CLR...
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 15, 2008 at 6:25 am
This is the way we implemented it ...
http://www.sqlservercentral.com/articles/Security/3203/
maybe that can be a good starting point for 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
April 15, 2008 at 12:09 am
Why materialize it in two tables ?
- I prefer small objects
- Adaptability.
Maybe there are even other columns that may be related to the relationship.
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 14, 2008 at 11:50 pm
- one problem is that most of the time there will be two parents :blink:
some kind of biology or tube issue.. 😉
- build a "parent2Child" table having a double...
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 14, 2008 at 10:49 am
Thank you for pointing to this "flaw".
That may be one of the reasons _not_ to use information_schema stuff.
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 14, 2008 at 6:03 am
or use the "multi brand" version:
INFORMATION_SCHEMA.ROUTINES
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 14, 2008 at 5:10 am
no way to get around it.
btw if a user add a column to a table, you must recompile the view if yo want that column to be available using 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
April 13, 2008 at 8:03 am
Actualy... since you're starting ... maybe better to be using join syntax.
SELECT L.drinker -- (drinker likes beer)
FROM likes L
inner join serves S -- (joins drinker...
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 11, 2008 at 12:18 am
Viewing 15 posts - 4,951 through 4,965 (of 7,499 total)