I agree that the craftsman approach is probably the best mind set from which to approach software development. The problem is that the demand for software is so high...

SQL Server runs only on Windows operating systems.

select

Order_10_Minute =

dateadd(mi,(datepart(mi,orderdate)/10)*10,dateadd(hh,datediff(hh,0,orderdate),0)),

Order_Count...

What is...

This works OK for me.

select

datediff( m, CHARDATE, '20090630' ), *

from

dbo.ComputeScalarProblem

where

...

At a former job, I requested purchasing to find me a chair that was built to take a lot more abuse because I had managed to wear out 2 chairs...

You can use the ROBOCOPY command in a job to mirror the backup directory to another server.

ROBOCOPY is a command line tool available as part of the Windows Server 2003...

It is possible to do a cursor loop with only a single fetch:

declare Cur_Cursor cursor local

for

select

MyData

from

...

Can you explain what you are trying to do? Are you trying to add leading zeros or remove leading zeros?

Just take the database offline before starting the restore:

use master

alter database MyDatabase set offline with rollback immediate

You can just raise an error in the CATCH block.

Lynn Pettis (7/23/2009)

You don't here on SSC. Many in this community believe that...

Service_Tag like

'[0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z]'

Run the script on the link below to see how much used and free space you have in each database file, and to see how much space is used by...

This is a farily simple method:

declare @files table (cmdout nvarchar(100) )

insert into @files ( cmdout )

-- Get filenames excluding directories

exec master.dbo.xp_cmdshell 'dir C:\ /b /a:-d'

select cmdout from @files where cmdout...