I am going to give you the standard answer, "It Depends". Some will tell you to move them to their own set of drives, others won't. On our...

If you are going to move the files from I to M and J to N, delete I and J, then rename M to I and N to J, the...

I'd check the attributes on your E-Drive and the sub-directories. Sounds like compression is turned on at the file-system level.

😎

I'd have to agree with Jeff. I did take your code, and after some adjustments (my system at home is case sensitive) I have the following working, except I...

A couple of things. One, is the interval time for the averaging fixed (ie 6:00 - 6:29, 6:30 - 6:59) or is it dynamic (one time it may be...

In addition to what Jeff said, it would also be nice to see what you have already tried to solve this problem. We don't want to start down the...

use [YourDatabase]

go

select count(*) from sys.tables

go

Looks like Jack beat me, but here is my code anyways.

declare @SQLCmd nvarchar(4000),

@TableNameOrig sysname,

@TableNameCopy...

tim.pinder (6/6/2008)

---

I posted...

K. Brian Kelley (6/6/2008)

---

blandry (6/6/2008)

---

I have never forgotten a guy I worked for who used to ask a good question - Is he/she an "expert" or "eckspurt" - the latter...

You also stated that [arrival date] and [arrival time] are both datetime fields, what does this data look like (sample values would be nice to see)?

😎

Here is some code from my backup process that provides a datetime stamp for my transaction log backup files.

declare @CurrDate datetime;

set @CurrDate = getdate();

select N'_' +

...

Okay, but 9999 is a four digit number....

That comes to this, do you have x years experience or 1 year experience x times over. I have seen both. I believe I am in the former...

I'll do a little digging. Second question, though, could you use a uniquely named global temp table (##Temp01)?

😎