it does provide the number of rows but i'm not sure whether it picks up the results from the statistics or the actual count. If it provides result from the...

use WAITFOR

http://msdn.microsoft.com/en-us/library/ms187331.aspx

it works even in 2008 but will show only the disk space used in the table.

not sure on this, but i think once a particular step is running, modifying it wont break. however, if the step has not run yet, it may process as per...

i'm not sure but see if updating statistics of the table helps...

No this doesnt break the job. The entire file is loaded into memory...

select colA, colB, colC, colD=colA+colB+ colC from mytable where colD=123

You should google it. There are plenty of sites on the net.

I would first check whether TCP/IP is enabled as Vishal said in earlier post.

TCP/IP is dynamically assigned and is not asked during installation.

Timothy Ford (7/29/2009)

---

I suggest backing up directly to the location you plan on copying the files to. Is that not an option? You should be able to backup...

Refer this BOL link to know about fill factor.

http://msdn.microsoft.com/en-us/library/ms177459.aspx

A fill factor of 30 means 30% of space within the...

since all the 16 files are a part of single filegroup, they'll be written proportionally which means all tables will span all files. you can have multiple filegroups and can...

Declare @str varchar(100)

set @str='myDatabase_Diff_' + convert(varchar, getdate(),112) + left(convert(varchar, getdate(),108),2)+'.BAK'

backup database myDatabase to disk=@str1 with differential

see if the above code runs.

Place the code in a job and schedule it...

Remember that truncating a log will break the log chain.

Also shrinkfile will require the name of ldf file....

Change the MaxDOP setting to 1 or 2 and see if you're...