Viewing 15 posts - 1,426 through 1,440 (of 7,499 total)
Everything is possible....
If you want to be able to have execution control, use a sqlagent job.
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
February 22, 2012 at 2:38 pm
just my 2ct in addition to Lowells reply which serves exactly your question.
Here's another way to avoid having to grant higher privileges ...
Have a look at help to tighten use...
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
February 22, 2012 at 2:06 pm
- 2GB is indeed the limit for SQL2000 MSDE
- did you detach this db ? If yes: Why ?
Can you post the errorlog.n file that was active at the 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
February 22, 2012 at 2:09 am
1) Lose the dynamic sql as this query sequence really doesn't need it !
2) collect your data using a join / group by combination ! Think set based in stead...
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
February 22, 2012 at 12:43 am
First of all, these are not the same queries as they may produce different results !
Refactored they look like this :
select PO.PurchaseOrderID
, PO.VendorID
...
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
February 22, 2012 at 12:15 am
- you posted on a sql2000 forum. Is your sqlinstance a sql2000 instance ?
- What's the size of the db ? ( sql2005 express -> max 4GB / sql2008r2...
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
February 21, 2012 at 11:45 pm
amod.professional (2/21/2012)
I have data of 182 GB and ram 16gb with 8 logical cpus(2 quad core)
and [erfromance is very poort due to 13.45 GB of RAM is in used with...
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
February 21, 2012 at 12:41 am
suppose your varchar(max) data is off row, that may cost you a extra io to get to the first address of your varchar(max) lob storage. Keep in mind IO 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
February 20, 2012 at 2:47 pm
Ronnie Jones (2/19/2012)
Currently, we have an instance with many databases some consisting of only two tables etc. Iām thinking about setting up a database to support some of those...
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
February 20, 2012 at 12:35 am
of course, Gail hit the nail on the head once more š
ref in BOL: Data Type Precedence (Transact-SQL)
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
February 19, 2012 at 12:02 pm
smallmoney has limits ! - 214,748.3648 to 214,748.3647
The engine will try to return a result in the same data type.
ref:http://msdn.microsoft.com/en-us/library/ms179882.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
February 19, 2012 at 8:51 am
Have a look at this little article for the refs: http://www.sqlservercentral.com/articles/powershell/76405/
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
February 18, 2012 at 6:41 am
Have a look how Grant summarizes it all:
http://www.sqlservercentral.com/Forums/FindPost684939.aspx
and here's another forum thread where I summed up my guidelines ( ... see how things match š )
http://www.sqlservercentral.com/Forums/FindPost1033453.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
February 18, 2012 at 6:32 am
This may not be the most optimal solution, but it may be a start ...
for ($i = 0; $i -lt $data.Length; $i += 4){
$name = $($data[$i] -split 'Found file ')[1]
$group...
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
February 17, 2012 at 1:07 pm
It depends.
A drop table removes the object from the database. (including indexes, grants, ...)
What would be the difference of using a temp table ?
A truncate only removes...
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
February 17, 2012 at 12:04 pm
Viewing 15 posts - 1,426 through 1,440 (of 7,499 total)