Viewing 15 posts - 5,326 through 5,340 (of 7,499 total)
Oh yes, use table_aliases in your queries !
Advantages are obvious.
And a human may even succeed to interprete your query way faster because it will be readable.
One thing MS...
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
January 18, 2008 at 1:39 am
Adam Haines (1/17/2008)Read through the article because it gives great insight to how to setup logging and what it does for compliance.
My day started awfull with huge network problems and...
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
January 18, 2008 at 1:26 am
AFAIK the only way is by starting a trace and investigating it.
cfr SQL Server and SOX @ http://www.sqlservercentral.com/articles/Security/3203/
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
January 17, 2008 at 7:56 am
...I might leave the editor on. I had a few people say that it distinguished me from a regular user....
Shouldn't that be a new attribute in your entity ? :Whistling:
.......
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
January 17, 2008 at 7:48 am
When I'm on the net ...
Most of the time I spend in forums.
Most of the time I tend to forget the blogs.
Maybe the SSC startpage should also have a part...
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
January 17, 2008 at 6:14 am
the mighty BOL states :
Remarks EXP
The constant e (2.718281…), is the base of natural logarithms.
The exponent of a number is the constant e raised to the power of the number....
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
January 17, 2008 at 6:00 am
Nice article series :w00t:
btw the blog url is wrong !
It should be http://blogs.sqlservercentral.com/members/Andy-Warren.aspx
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
January 17, 2008 at 1:58 am
...
The following code will produce dates in a reverse order from the EndDate to the StartDate... no cursor... no explicit loop... runs nasty fast... on repeated use, generates...
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
January 17, 2008 at 12:57 am
- second first rule for any rdbms : tell the system what you know !
- If you can have 'yes' or 'no' why would you accept 'maybe' ?
- the fact...
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
January 17, 2008 at 12:36 am
Just my 2ct ...
changing username may cause some "broken" references in forum replies, etc.
(e.g. there a some replies like "to alzdba ...." If I change my username to JohanBijnens 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
January 17, 2008 at 12:01 am
- did someone execute dbcc checkident 'yourtable', reseed ?
- it should not be a problem if you use the identity column as a surogate key and therefor don't deduct...
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
January 16, 2008 at 11:51 pm
you can only set variables in the first select of your union-select
BTW how many rows do you expect from your select statement.
Maybe you're better off returning a rowset.
PROCEDURE [dbo].[KB_Search] @userid...
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
January 16, 2008 at 12:16 pm
- the 8060 limiet is for fixed length columns only !(in sql2005)
(and var length columns will be shifted off row if needed with the same impact as for text, image,...
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
January 16, 2008 at 12:16 pm
check the sqlserver errorlog file.
Maybe it contains the messages you need to take care of.
(you can also post its content)
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
January 16, 2008 at 12:05 pm
Just keep in mind you should get rid of the day , month and year columns to be safe for the future.
That may have heavy application impact, depending on how...
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
January 16, 2008 at 7:48 am
Viewing 15 posts - 5,326 through 5,340 (of 7,499 total)