Viewing 15 posts - 16 through 30 (of 45 total)
Not 100% convinced I should jump back into this thread now but I have been watching since the start and its certainly made an interesting read.
I just wanted to...
November 20, 2009 at 6:26 am
Jason,
I missed that line totally in Jeff's post. sorry to have broken the rules ... 🙁
Jonathan
November 16, 2009 at 8:14 am
Guys,
Rather than get over concerned about collation for choosing the character to replace the 2nd space you can use any string, so you could use
SELECT LTRIM(RTRIM(
...
November 16, 2009 at 6:54 am
kgerde - Can you confirm that the registry change is carried out on the backup location server?
Thanks
Jonathan
October 7, 2009 at 4:42 am
Steve, Jeff,
I see your points on asking an expert and understand what you are saying but speaking as someone who is, on balance, a user of forums rather than a...
September 8, 2009 at 3:34 am
Hi,
I'm a little late to this but am trying to get a baseline CPU trace of one of my servers and found the thread.
Can anyone advise me whether the dm_os_ring_buffers...
September 1, 2009 at 7:05 am
Another thank you Adam.
I have always wanted something like this but have been unsure how to implement it (and more than a little concerned about busting something!). This is a...
March 5, 2009 at 3:51 am
no worries!!
did have a wry smile about maybe creating a How To Post Answers article!
immediate problem solved, just need to get some time to schedule in changes to DB to...
January 20, 2009 at 8:33 am
Ramesh,
firstly thanks very much for the code, I have converted it to fit our table and it works perfectly. I hadnt seen the problem as something that UNPIVOT would fix.
With...
January 20, 2009 at 6:20 am
Sorry to be a pain but I have read through several PIVOT articles (BOL etc) but cant see how that will help where I need to logically decide between Null,0...
January 20, 2009 at 2:53 am
OK, thanks for the conclusion. I am pleased its not my db and pretty confident its not the network - our web apps are working without any user complaints.
One last...
January 8, 2009 at 9:28 am
Just to clarify:
SQL Response is showing a query taking in excess of 15s to complete. The same offending query is coming from a number of our offices where the application...
January 8, 2009 at 9:04 am
Guys, posted the execution plan now.
Thanks very much for your rapid replies - hopefully I'll learn a bit about reading these plans from your comments.
I agree that a scan is...
January 8, 2009 at 8:47 am
SELECT OrgID ,
OrgName
FROM Organisation
ORDER BY OrgName
Clustered Index Scan on Primary Key - 95%
Sort (on Indexed OrgName column) -...
January 8, 2009 at 8:37 am
Christopher;
1 - Its SQL made on the fly in the VBA I would expect. (I didnt write the App!)
**** The 15s is being reported as time to run the...
January 8, 2009 at 8:32 am
Viewing 15 posts - 16 through 30 (of 45 total)