Viewing 15 posts - 4,351 through 4,365 (of 7,499 total)
what's the size of your indexes (pages) ?
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
November 5, 2008 at 10:28 am
seems to me like your data after exp is a date, so make it a datetime column !
pro:
- only date(time) values accepted
- the whole bunch of datetime related functions
con:
- no...
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
November 5, 2008 at 10:27 am
the original queries contained this where clause:
U.[user_id] = @original_user_id AND
U.[user_name] = @original_user_name AND
U.[user_surname] = @original_user_surname 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
November 5, 2008 at 5:17 am
Because of the parameter "DETAILED", it will perform like a dbcc updateusage with countrows....
BOL states:
.... The nonleaf levels of indexes are only processed when mode = DETAILED.
...
The DETAILED mode...
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
November 5, 2008 at 3:53 am
kubio (11/4/2008)
I had to write two separate queries to get what I want: that is, knowing the branchCode, get the email addresses from another table for two columns. 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
November 4, 2008 at 2:25 pm
did you resync the users ?
at db level execute this to get an overview of the actions you need to take:
print 'print @@servername + '' / '' + db_name()'
print 'go'
go
declare...
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
November 4, 2008 at 2:21 pm
best to do is compare the execution plans.
With sql2005 SSMS you can even save and post the .sqlplan if you want to.
using set statistics io on and set statistics time...
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
November 4, 2008 at 2:12 pm
FYI
When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.
(the altered columns maintained using...
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
November 4, 2008 at 1:39 pm
Best is to format all stuff in the front end application. (because this way you keep the datatime characteristics as long as possible)
Check out convert in BOL
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
November 4, 2008 at 1:01 pm
I advise to use aliasses in queries !
- a delete only operates on a single object !
so you should perform TWO delete statements !
Since you have DRI implemented (FK) ,...
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
November 4, 2008 at 4:05 am
That's even easier than I thought. (using the help/about in ssms) :hehe:
The WMI query results to :
Display Name: Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU...
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
November 4, 2008 at 12:33 am
Could you perform this query just as a test:
(=your query but used as a nested table expression)
Select *
from
(SELECT c.comm_id AS [ID],
...
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
November 4, 2008 at 12:17 am
you'll have to check the dll library of sql2005 at client level.
WMI softwarelist may also help out.
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
November 3, 2008 at 1:12 pm
Check out the ranking functions of SQL2005.
There are a couple of good articles at CCS.
- http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
- http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/sequentialordering/2261/
- http://www.databasejournal.com/features/mssql/article.php/3773091
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
November 3, 2008 at 1:11 pm
Especially because it is a 3th party product, I do not advise to add columns to tables.
To achieve the thing you want, create another logging table and populate that using...
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
November 3, 2008 at 1:02 pm
Viewing 15 posts - 4,351 through 4,365 (of 7,499 total)