Viewing 15 posts - 1,861 through 1,875 (of 7,502 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
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...
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...
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...
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...
July 18, 2011 at 6:44 am
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)
...
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
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...
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...
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...
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
-...
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 !
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...
July 14, 2011 at 9:52 am
check your maintenance plan log output (and sqlserver errorlog)
July 14, 2011 at 8:13 am
Viewing 15 posts - 1,861 through 1,875 (of 7,502 total)