CirquedeSQLeil (1/29/2010)

---

I was thinking that it could...

Assuming you are trying to delete from table1, try this:

delete from

dbo.table1

from

dbo.table1 as source

where

...

The only way I have successfully defragged my mdf/ldf files that reside on our SAN is to do it while SQL Server was shutdown. And in a couple of...

Good idea, midway in the season, and everyone has the same bye week.

Question, are you trying to return todays date at 17:30 as part of this query? If so, you could do the following:

select dateadd(mi, 1050, dateadd(dd,datediff(dd,0,getdate()), 0))

Your dateformat is probably dmy. Your code worked for me, to get it to fail I had to set dateformat to dmy.

Try the following, it creates the string in...

Bill Gates-870674 (1/29/2010)

---

Nothing is jack of All AND nothing is master of ALL.

One has to be more specific and specialist in one area.

So i want to re-question that

DBA having good...

I seem to remember reading something somewhere (twitter maybe?) where...

With INNER JOINs I don't think it really matter where you put the filter condition. Where it matters is when you are converting old style outer joins to ANSI-92...

It depends. If the number of rows of data in the table variables is small, then they work well. If the number of rows increases, then temp tables...

As you are new to SSC, may I please suggest that you read the first article I reference below in my signature block regarding asking for assistance. Flow the...

Matt Miller (#4) (1/29/2010)

---

keep in mind that getting the same results stops being true when those inner joins turn into outer joins.

Jack - what's non-ANSI compliant in Query 1? ...

IMHO, I personally would not attempt to restore the system databases (master, model, msdb) from the 32 bit environment to the 64 bit environment.

01/28/2010 12:15 AM 1,433,088 CycleTime_backup_201001280015.trn

01/28/2010 12:31 AM 124,249,600 CycleTime_backup_201001280030.bak <-- Full BAckup

01/28/2010 02:15 AM 34,797,056 CycleTime_backup_201001280215.trn <-- Why is this so big?

The transaction log backup taken at 2010-01-28 02:15 contains...

You "might" be able to restore the msdb database, but I'm pretty sure that you couldn't do that for the master database (but then again I could be wrong). ...