Depends where you are.

Not all places in the world have bandwidth that's sufficient for this kind of thing.

sanjeev_krs2004 (10/8/2008)

---

Hi,

I have never deleted/archived anything from DB but when I ran DBCC shrinkfile command, size of DB has gone down from 80 GB to 45 GB. Could you please...

free_mascot (10/8/2008)

---

If performance is not a problem and by hook or crook you would...

What database are you trying to add the extended proc to?

On that one you'll have to wait until the portion of the log that's in use is at the beginning of the file. You can force that by creating a...

sahmad43 (10/7/2008)

---

ok its giving me error on any procedure I add . what could be the reason ? is the syntax wrong ?

exec sp_addextendedproc 'ABCAD', 'FADSFADFASF'

Server: Msg 2714, Level 16,...

Well, there's only 3% free space in the log, so I think the first thing that we need to do is figure out why the log is full.

Let me guess....

You sure about that? I can see an index scan been marginally faster than...

Oh I didn't buy an MSDN subscription. No way I could afford that...

I would, but there seems to be a bug with connect. I can only see...

tendayit (10/7/2008)

---

Hi,

Users can enter a full accountid, idnumber, etc and retieve an account but they can also do partial searches where they put in a string say on the account...

Lynn Pettis (10/7/2008)

---

Okay, off topic but I need to ask. Where did you purchase your copy of SQL Server 2008 Developer Edition, and how long did it take for...

Lynn Pettis (10/7/2008)

---

Actually, I believe that indexes will help. I can't remember where I read it, but I believe that there has been improvements in the query engine in...

No. Snapshots...

tendayit (10/7/2008)

---

A lock type HBT means that a lock is on a b-tree index or heap. How do i identify the table being locked or the procedures causing the...