Viewing 15 posts - 4,936 through 4,950 (of 7,499 total)
Jeff Moden (4/21/2008)
No, no... it DOES work correctly. The examples can all be converted to some form of numeric data type including the ones I just showed which are...
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 21, 2008 at 7:09 am
Jeff Moden (4/18/2008)
Matt Miller (4/18/2008)
I'd think it's because you're using an example that doesn't require materialization.
I agree... even with a CTE, I'll try to return as few rows 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
April 21, 2008 at 2:12 am
Jeff Moden (4/20/2008)
Here's why I say NOT to use ISNUMERIC as an "IsAllDigits" function...
Indeed, I forgot about the currency signs. :crying:
Thank you for providing the faulty example.
They'd better remove ISNUMERIC...
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 21, 2008 at 12:06 am
Indeed, you'll need to add the index yourself.
This script can help:
http://www.sqlservercentral.com/scripts/Indexing/61391/
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 20, 2008 at 12:52 pm
how about adding a "calculated" column wich contains the actual sort-value.
This way it will take some space, but you can index the column and you don't have to figure 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
April 20, 2008 at 12:50 pm
When implementing "remote foreign keys" keep in mind that if the other instance/db is down (or in maintenance), your instance will suffer as well !
Maybe you'll be better off replicating...
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 19, 2008 at 9:38 am
- with sql2005 you can only see the data you are entitled to.
- you need to grant 'view system state' to see it all.
Do you realy...
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 19, 2008 at 9:36 am
- keep in mind "hostname" is data the client needs to provide.
- with e.g. access, when creating a linked table, it keeps the hostname data that has been provided by...
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 19, 2008 at 9:34 am
- I think you've posted in the wrong forum (sql2005 backup)
- what kind of isolation level are your applications using.
avoid repeateble read as much as you can.
sp_blocker_80 shows 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 19, 2008 at 9:31 am
- did you try just adding the correct date to both columns ?
- and then just query
datediff(MINUTE , startdate, enddate) as elapsttime_Minutes
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 12:55 pm
well ... maybe the are ...
try to add an "order by 1,2,3 " at the sqlserver side as wel as at the access side.
Maybe then you'll see the data is...
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 12:51 pm
- is that database configured "autoclose on" ?
- if yes, it needs a restore-step to be opened again.
(keep in mind SSMS doesn't autorefresh the object-browser pane)
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 11:11 am
- is your sqlserver "member" object a view or a table ?
If it is a view, can you post the ddl ?
-Are you using a linked table 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
April 18, 2008 at 11:09 am
did you check http://www.sqlservercentral.com/Forums/Topic459602-148-1.aspx ?
or
http://www.sqlservercentral.com/Forums/FindPost328227.aspx
or http://www.sqlservercentral.com/articles/OpenDataSource/61552/
or http://www.sqlservercentral.com/Forums/Topic475347-8-1.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
April 18, 2008 at 5:11 am
I'm glad you found the issue and were able to fix it.
You could also have granted full control or the service account to the folder that contains the logfiles.
But 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 5:05 am
Viewing 15 posts - 4,936 through 4,950 (of 7,499 total)