Viewing 15 posts - 106 through 120 (of 216 total)
A couple lingering tabs in the new daylight savings calculation but otherwise working well. Thanks!
Ken
June 27, 2011 at 2:52 pm
Joe, definitely a useful script. Some weird things when in the formatting of indentations. I copied all the code out of the block and pasted it into SSMS. Won't compile...
June 24, 2011 at 10:34 am
They're not exactly holidays but the start and end of daylight savings time. Maybe I'll see if I can tack it on.
Ken
June 23, 2011 at 12:49 pm
Yes, thanks to Michael and others for this. Helped me quickly find an errant value in a field during a very large insert that failed.
Ken
May 25, 2011 at 8:43 am
That being said, I incorporate self-directed time into my tasks. For example, I will wait the appropriate task that is sent my way to hone my skills with the WITH-clause...
May 13, 2011 at 1:04 pm
Thanks Dan. This works in 2008 as well. I like that use of Fileproperty(). And most of the info comes from sysfiles.
Ken
April 13, 2011 at 1:12 pm
Row_Number() was introduced in SQL 2005. Are you on that or is your SQL Server 2000?
Ken
March 25, 2011 at 12:42 pm
Thanks everyone. There's obviously more to this than meets the eye.
February 23, 2011 at 9:32 am
Jeff Hamming (2/23/2011)
February 23, 2011 at 9:23 am
Most of the time it's users running reports out of our Crystal Enterprise environment.
February 22, 2011 at 2:22 pm
Select * From vExecutiveSummary, not that I'd ever do that :-D. Looks like the waittypes are CXPACKET. I'll get a better idea when some heavy user reports are run.
select s.spid,...
February 22, 2011 at 12:01 pm
Yes it's wrong. It was an error in an early version of that BoL page. The current up to date SQL 2008 BoL page (Moving System Databases) states that it...
February 14, 2011 at 1:26 pm
Ok, I don't know what you did there but this version compiles and executes (I took out the call to executing the actual backups in favor of printing out the...
February 14, 2011 at 9:53 am
Nice idea. But I'm getting error while trying to create the proc.
Msg 102, Level 15, State 1, Procedure USP_BackupDatabasesOnPr01, Line 32
Incorrect syntax near '?'.
Seems that there's something on the...
February 11, 2011 at 9:33 am
Wouldn't it be easier to hire the right person in the first place? Over the last few years I've had interviews where I walked away and wondered how the manager...
February 8, 2011 at 9:20 am
Viewing 15 posts - 106 through 120 (of 216 total)