Viewing 15 posts - 1,861 through 1,875 (of 7,499 total)
lists the top 50 statements by input/output usage. This script requires Microsoft SQL Server 2005.
http://gallery.technet.microsoft.com/scriptcenter/f3a4dd6d-c521-4fc6-b047-bfad68f59556
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
July 18, 2011 at 11:11 am
You are never to old to change to whatever !
Why would someone be to old to acquire new knowledge ?
Co-workers that don't encourage you in your choice probably envy...
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
July 18, 2011 at 11:06 am
why would you want to do that using TSQL ??
Why would you want to make an in-transaction sql statement dependent on a file system copy ?
Can't you do it 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
July 18, 2011 at 11:00 am
- can you elaborate on what you are actually trying to accomplish ?
- why are you using xp_cmdshell ?
- why aren't you using sqlcmd or bcp ? (maybe even just...
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
July 18, 2011 at 10:51 am
hoanglong88i (7/18/2011)
Place_ID AllAvai Today Tomorrow
1201
2211
3000
4000
Hi Alzdba,
I'm taking time on functions DATEADD and DATEDIFF. Yes, really I also feel my...
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
July 18, 2011 at 6:44 am
have a look at my little SSB troubleshooting script 😉
"Troubleshooting Service Broker (SSB)"[/url]
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
July 18, 2011 at 4:38 am
How about this:
SELECT Place_ID
, ReceivedDate
, COUNT( case when ReceivedDate >= DATEADD(DD, DATEDIFF(dd,0, GETDATE()) ,0)
...
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
July 18, 2011 at 4:27 am
The log backups is a must to keep control over the log file size.
Managing Transaction Logs by Gail Shaw[/url]
and
Why is my transaction log full?[/url]
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
July 17, 2011 at 6:20 am
SQLkiwi (7/16/2011)
I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:...
+1 because of the lack of 'create...
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
July 17, 2011 at 6:16 am
edited: Almost posted code in The Thread .:blush:
For those interested ...
Just in case anyone could use a little hand slipstreaming SP1 into his SQL2008R2 ... 😀
and SSC doesn't have a...
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
July 15, 2011 at 8:13 am
As already stated by Jayanth_Kurup those numbers depend on the datefirst parameter of your instance !
Doublecheck it.
Also have a look at the second query I provided, it will return 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
July 15, 2011 at 1:05 am
Mind me tossing in my all time favorit when it comes to what the log is all about and why your choice of recovery model matters ?
- Managing Transaction Logs[/url]
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
July 15, 2011 at 12:43 am
Since we're at it, can you convert your scalar value function to a table value funtion.
That should give you a noticable performance gain, but requires query modifications !
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
July 15, 2011 at 12:36 am
can you relate your case with this SP1 fix ?
649391 DBCC corruption errors occur during SQL Server 2008 R2 collations when strings that have Jamo sequences that follow the Japanese...
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
July 14, 2011 at 9:52 am
check your maintenance plan log output (and sqlserver errorlog)
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
July 14, 2011 at 8:13 am
Viewing 15 posts - 1,861 through 1,875 (of 7,499 total)