sysprocesses is deprecated, will be removed in a future version and should not be used. Use sys.dm_exec_requests, sys.dm_exec_sessions and sys.dm_exec_connections instead.

aviadavi (3/3/2013)

---

I'm using NOLOCK because integrity is not that important for me and again - I want good timing and i want to avoid potential deadlock by not locking the...

Yes, you could google it. Right now...

Welsh Corgi (3/3/2013)

---

I have blocking going on between 2 different developers.

The blocking has been going on for nearly an hour.

I would have thought that there would have been a deadlock...

They're the same thing. They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

Require, no. Full and log can restore to a point in time. There are advantages and disadvantages to differentials, there are many places where they are useful.

Consider, for example, a...

mehta.saurabhj (3/2/2013)

---

GilaMonster (3/2/2013)

---

For SQL Server, this works as expected (as long as good performance isn't expected).

CREATE TABLE student ( name VARCHAR(20), age INT );

INSERT INTO student

VALUES ( 'ram',...

Corruption most likely, meaning something wrong with the IO subsystem. Can't say more without more info.

btw, checkDB is the last resort for fixing suspect databases, you should rather have restored...

For SQL Server, this works as expected (as long as good performance isn't expected).

CREATE TABLE student ( name VARCHAR(20), age INT );

INSERT INTO student

VALUES ( 'ram', 12 );

INSERT...

Lynn Pettis (3/2/2013)

---

mehta.saurabhj (3/2/2013)

---

The sql code to find odd number of records is:

select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);

But if I do the foll code...

Not true.

Differential backups are dependent on...

What exactly, step by step, did you do to that DB?

Recovery is the last phase of a restore, but I've never seen the state change before.

mickdunde (3/1/2013)

---

The affected database is part of a database mirror and therefore in full recovery mode, also edition is standard, so no online rebuild for me. At the moment there...

Multiple tempDB data files with limited growth isn't a bad thing, as long as the total size is enough for the app and as long as all files are the...

opc.three (3/1/2013)

---

@Gail, In thinking about this a little more, I think the example I gave is just a roundabout way of asking for TOP 1 without an ORDER BY, which...