Viewing 15 posts - 241 through 255 (of 758 total)
Lynn Pettis (3/25/2013)
A bit expensive, but the following works:
declare @string varchar (100)
set @string = 'x:\folder1\folder2\folder3\test.txt'
select @string
select @string,reverse(right(reverse(@string), len(@string) - charindex('\',reverse(@string),1) + 1));
Thank You
March 25, 2013 at 12:46 am
. The differences are odd but are nothing that I expect will ever affect how I admin or develop for SQL
I agree - More than anything else, I just...
March 12, 2013 at 8:07 am
opc.three (3/12/2013)
Where did you learn about SPA/MPA?
Web mostly
March 12, 2013 at 7:30 am
Regarding this post, based on what I'm seeing - I am more concerned about whether my understanding of SPA/MPA is correct.
Maybe I'm missing something here..
Thanks
March 12, 2013 at 7:17 am
opc.three (3/12/2013)
March 12, 2013 at 7:01 am
opc.three (3/12/2013)
March 12, 2013 at 6:20 am
opc.three (3/12/2013)
SQLSACT (3/12/2013)
This is why I'm confused because when I query sys.dm_os_memory_clerks - I see all the allocations happening at the single page allocator and nothing at MPA
And you are...
March 12, 2013 at 5:51 am
This is why I'm confused because when I query sys.dm_os_memory_clerks - I see all the allocations happening at the single page allocator and nothing at MPA
March 12, 2013 at 4:12 am
Thanks
So does that mean that those (86) plans were allocated though MPA ?
March 12, 2013 at 3:20 am
Thanks OPC
During times of the low PLE - I am noticing some nasty selects coming through.
I suppose my next move is to try and optimize the queries ?
Thanks
March 11, 2013 at 12:24 am
Hi Guys
I know this post is getting old, I figured this response would help someone else as much as it did me
http://blogs.msdn.com/b/craigfr/archive/2006/08/10/687630.aspx
Thanks
March 8, 2013 at 12:12 am
Meet George Jetson (3/6/2013)
However, if you are up for a taking a risk, I recall the...
March 6, 2013 at 10:50 pm
What do you mean by 'looks after'?
When the Lazy Writer wakes up, it checks the size of the free buffer list - Does it also check the status of the...
March 6, 2013 at 1:34 am
Viewing 15 posts - 241 through 255 (of 758 total)