Viewing 15 posts - 2,161 through 2,175 (of 7,504 total)
just building forward from your query...
What's wrong with :
SELECT
@courseDate AS courseDate,
E.[DST_Start],
E.[DST_End]
FROM [DST_Extent] E
where E.[DST_Start] >= @courseDate
and @courseDate <= E.[DST_End]
this solution has the advantage of...
April 11, 2011 at 6:47 am
I hope nobody enabled drive (lun) compression for your disk(s) or folder(s).
(imo that would be noticable more than just with checkdb unless you realy have litte activity)
April 9, 2011 at 1:33 pm
Brandie Tarvin (4/5/2011)
Grant Fritchey (4/5/2011)
April 5, 2011 at 7:59 am
Congratulations Steve ! Uconn (Connecticut) did win the finals this year.
April 5, 2011 at 1:00 am
Jeff Moden (4/4/2011)
Dang... Johan beat me to the punch on the target thing. Since more than one of us said it, it must be true. 😛
He caught me in...
April 4, 2011 at 8:06 am
Stefan Krzywicki (4/4/2011)
ALZDBA (4/4/2011)
Stefan Krzywicki (4/4/2011)
Grant Fritchey (4/3/2011)
SQLkiwi (4/2/2011)
Got to meet heaps of great people including Grant and Stefan K!
If...
April 4, 2011 at 8:02 am
Roy Ernest (4/4/2011)
April 4, 2011 at 7:57 am
Stefan Krzywicki (4/4/2011)
Grant Fritchey (4/3/2011)
SQLkiwi (4/2/2011)
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like...
April 4, 2011 at 7:21 am
I would first start with enabling auto close for that database and see when it goes offline and if it comes back online.
Of course you need to take into account...
April 3, 2011 at 8:59 am
Roy Ernest (4/1/2011)
Forget about the tin, take good care of yourself !
April 2, 2011 at 1:24 am
Like I retweeted :
RT @AdamMachanic: Congrats to new SQL Server MVP Paul White!!! @SQL_Kiwi This is a blind RT, because if he wouldn't be in, nobody would !
Congrats Paul !...
April 2, 2011 at 1:21 am
phbarn (4/1/2011)
You made a good point with your reply and provided very good alternatives and how-to's,
however ....
please keep in mind this is an old thread ( Posted 1/21/2008 )
April 1, 2011 at 7:58 am
good feedback.
I ran across mrdennys article last night, but had quit a busy day today.
It's good you posted the ref for later forum users.
mrdenny is very frequent on Twitter (...
March 30, 2011 at 11:09 am
Do any of these queries result in rows ?
use msdb ; -- forwarded messages
go
SELECT '' as 'Q_000', *
FROM sys.server_event_notifications
order by name
go
select '' as 'Q_000a', *
from sys.server_triggers
select...
March 29, 2011 at 11:58 pm
As always ... Happy To Help 🙂
March 29, 2011 at 11:53 pm
Viewing 15 posts - 2,161 through 2,175 (of 7,504 total)