Viewing 15 posts - 16 through 30 (of 216 total)
Being a DBA is not a 9-5 job, 5 days-a-week. You can't switch off when you leave the office, but unfortunately you do disconnect from your work place. ...
December 13, 2010 at 9:55 am
Steve,
I knew there would be a reason, it's just a shame it wasn't communicated as well, or as soon as it could have been - but hey, lots of companies...
June 28, 2010 at 9:27 am
OK- I'm just hoping now that someone at Red Gate has accidentally put live this test version of the OSQA version of ASKSSC.
The data import used is out of date...
June 25, 2010 at 4:39 pm
can't believe that ASK SSC wouldn't have met the minimum traffic requirements, or that Red Gate couldn't afford any subscription fees, or that we couldn't have competed against other SQL...
June 25, 2010 at 2:25 pm
Excellent stuff!
Have downloaded, installed, and now ready to play. Thank you for sharing these.
Kev
February 4, 2010 at 4:32 am
No it's not because you ran it in the master db - it will report activity across all databases.
It could be that nothing was actually running at that point. ...
December 11, 2009 at 9:11 am
Another update ... 7 months on....
have just updated SSMS to SQL2008 SP1 (10.0.2531.0), and now against a 2005 instance () highlight!
Kev
October 29, 2009 at 6:46 am
Grant Fritchey (10/22/2009)
October 22, 2009 at 6:27 am
Silverfox (10/22/2009)
scratch that, cannot make those times, bloody typical, how can you be expected to be there when the start times are part of BAU Hours. lol
I think they do...
October 22, 2009 at 6:12 am
Silverfox,
my local group is the Manchester SSUG, part of the UK SSUG - try their website www.sqlserverfaq.com - it's maintained mainly by Tony Rogerson. They also have meetings in...
October 22, 2009 at 5:21 am
Steve,
liked your blog post and editorial today about this issue, and couldn't agree more that there should be more transparency.
As a DBA in the UK, I feel very, very distant...
October 22, 2009 at 4:36 am
Mike Byrd (10/16/2009)
I ran it several times this morning -- everytime getting same error.
Mike, do you get an overflow error if you run
select @@cpu_busy
October 16, 2009 at 10:15 am
Bob Bobbity (10/8/2009)
If you'd given me the 18003 option, I'd have taken it
I must admit that would have been my favourite wrong answer if I was setting the question!
Wasn't sure...
October 8, 2009 at 4:45 am
simply reverse the process...
declare @yyyymmdd char(8)
set @yyyymmdd = '20070918'
select replace(convert(varchar,convert(datetime,@yyyymmdd,10), 10),'-','')
gives
091807
Kev
September 18, 2009 at 7:42 am
from the 2nd result set of sp_spaceused, you get
1313120KB data + 363376KB index + 91680KB allocated but as yet unused = 1768176KB reserved (as stated in first column)...
September 8, 2009 at 3:52 am
Viewing 15 posts - 16 through 30 (of 216 total)