Click to download new music, completely free, brought to you by your music loving friends at Windows. You'll see (but not hear) some ads on your screen in addition to the album's cover art, which is how we (they) keep your new tunes from costing you a cent. Well worth a listen to checkout some new bands and artists…. Listen online, download MP3 or WMA http://sponsoredsongs.reverbnation.com/windows?utm_source=windows_myspace_page&utm_medium=button_link&utm_campaign=ms_windows&utm_content=thousand_more
I have been doing some more looking at SQL Server indexes lately and came across a great script that may be of use to others as well. So what can this index defrag script do? Schedule it to run with the default settings; it works “right out of the box” with no additional configuration necessary Run this one script from a centralized database for all databases on a server Run this script for a specific database or table Configure custom threshold limits...
declare @dt datetimeset @dt = getdate() print 'Now'print @dtprint ''print 'Today - no time'print dateadd(D, 0, datediff(D, 0, @dt))print ''print 'Today – 23:59:59.997'print dateadd(ms,-3, dateadd(D, datediff(D, 0, @dt),1))print ''print 'Start of this week - Starts on MONDAY'print dateadd(wk,datediff(wk,0, @dt),0) print ''print 'End of this week - Starts on MONDAY 23:59:59.997'print dateadd(ms,-3, dateadd(wk,datediff(wk,0,@dt),7))print ''print 'Start of this week - Starts on SUNDAY'print dateadd(wk,datediff(wk,0,getdate()),-1) print ''print 'End of this week - Starts on SUNDAY 23:59:59.997'print dateadd(ms,-3,dateadd(wk,datediff(wk,0,@dt),5)) print ''print 'Start of Month'print dateadd(mm,datediff(mm,0,@dt),0) print ''print 'Last day of current Month - 23:59:59.997'print dateadd(ms,-3, dateadd(mm,datediff(mm,0,@dt)+1,0))print ''
Here is a simple break...