S_Kumar_S (6/19/2012)

---

Hi

Here is my table and sample data:

create table tab1(id int,oldId int, InsertedOn datetime)

insert into tab1 values (99,NULL,getdate()-7)

insert into tab1 values (17,14,getdate()-9)

insert into tab1 values (14,12,getdate()-14)

insert into tab1 values (12,null,getdate()-15)

Now...

snigdhandream (6/19/2012)

---

Yes I know, but my problem is... we have a whole DB's tables to be migrated and client is reluctant to creating extra identity columns for DB size issues...

I would think making use of the DATEPART function with week to get the range of dates for each week would be trivial. You would need to know or...

mattech06 (6/8/2012)

---

Hi,

is there a general sql query section in these forums?? Wouldn't say I'm a newbie but wouldn't say I'm that great at sql either...anyhoo 🙂

I have this query

SELECT dbSchCnt...

LOL.. MySQL and replication. /Shudder.

michael vessey (6/8/2012)

---

Since you don't know anything about RDBMS, then get a copy of the simplest...

Oracle does not have a TOP clause, but they finagle it with a rownumber method. Attunity is the best way to go.

It would be best to have one table with name and email, foreign keyed to another table that had the values as rows for each name and email. This...

David.Poole (5/31/2012)

---

It's probably worth mentioning that if you are using NOLOCK then you should be making the switch to using READUNCOMMITTED as this is the replacement for NOLOCK.

The problem with...

I use the hint liberally in a data warehouse environment used for reporting. Using it bypasses most of the locking checks and most importantly doesnt escalate locks even from...

Besides the WTF'ery about the ORDER BY... the lack of indices is more troublesome.

A clustered index should really be considered mandatory, and then supporting indexes as necessary by the needs...

richardmgreen1 (5/23/2012)

---

If it's only a select query you're running initially, try putting :-

set transaction isolation level read uncommitted

as the first line of your query. I've noticed it helps to...

Examining the query plans shows the same result. That was the big hint when I tested this out a few years ago.

When in doubt, check the plan!

Yup, on same server, no issue.

There is a LOT of confusion about primary keys and clustered indexes.

Primary keys are the minimum number of columns to identify a unique row. If you are...