Viewing 15 posts - 3,466 through 3,480 (of 7,506 total)
or use the ever lasting exists with a correlated subquery.
SELECT Q.*
FROM qtral Q
WHERE exists (SELECT 1
FROM qtral Qx
where Qx.tral_no = Q.tral_no
and Qx.tral_pd = Q.tral_pd
group by Qx.tral_no, Qx.tral_pd
having...
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
September 19, 2009 at 11:17 am
The big problem with functions that perform queries, is that they cause hidden joins, hence should be transformed to (well tunable) regular joins !
Functions aren't always visible at first sight...
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
September 19, 2009 at 11:02 am
have a look at Allens article : http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/
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
September 18, 2009 at 5:50 am
afaik size doesn't matter, unless you have a sqlexpress instance.
There has been a limit regarding the number of files when using sp_attachdb.
Best is to use "create database .... for...
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
September 18, 2009 at 12:47 am
There are only two reasons why one should stop and restart a sqlserver instance:
- to apply a servicepack/hotfix
- to have tempdb to its original or set starting size ( in...
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
September 18, 2009 at 12:42 am
- commit and overwrite .. yes , SHRINK ... No !
- things that can cause your log files to grow with simple recovery :
-- long running transactions
-- huge...
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
September 17, 2009 at 4:32 am
Gail posted a very explanatory article on this subject !
http://www.sqlservercentral.com/articles/64582/
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
September 17, 2009 at 2:58 am
start with the Upgrade advisor for sql2005 !
It will point you to potential issues with your db.
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
September 17, 2009 at 2:56 am
- if a filegroup gets filled up and cannot auto extend any files , you'll get an errormessages stating "filegroup full".
So you nolonger can add data to it, rebuild indexes,...
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
September 16, 2009 at 2:37 pm
- also, with these ndf files, it is best to know if they are all allocated to a single filegroup or not. Having multiple files allocated to a filegroup would...
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
September 16, 2009 at 1:11 pm
As always, it depends 😉
- For small files, rarely requested, you could use a dbmail solution and mail the query result as attachement.
- another alternative is to use a sqlagent...
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
September 16, 2009 at 3:31 am
2 things:
- there is a faulty path in your script !
SET @FileName = 'd:aveen.txt'
Should be SET @FileName = 'd:\aveen.txt'
- has your sqlserver instance service account been granted read access to...
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
September 16, 2009 at 1:51 am
By default, there is no order in a set !
1 things you can do:
- Add an order by clause to your select statement.
Keep in mind order by follows the order...
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
September 16, 2009 at 1:44 am
for sure you can define your dns alias like "OurVeryNiceVirtualSQL" but to get to the actual instance (you may have many on your nodes), you'll also have to provide 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
September 15, 2009 at 12:00 pm
This will for sure get you on track : http://www.sqlservercentral.com/scripts/31797/
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
September 15, 2009 at 11:16 am
Viewing 15 posts - 3,466 through 3,480 (of 7,506 total)