Viewing 15 posts - 4,936 through 4,950 (of 7,502 total)
With sql2005 the (sqlproc) debugging stuff has been shifted towards BI-dev studio.
This feature is NOT available if you only install the BIDS version MS ships with SQL2005.
Open BIDS
open the server...
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 22, 2008 at 2:29 pm
grant VIEW SERVER STATE to xyz ;
Check "GRANT Server Permissions " 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
April 22, 2008 at 6:04 am
This is SQL2005 Right ?
Have a look at the rank functions that can be embedded in the sqlstatement.
Then you would only have the e.g.
Select *
from (
SELECT Rank() OVER (PARTITION...
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 22, 2008 at 12:31 am
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
Viewing 15 posts - 4,936 through 4,950 (of 7,502 total)