You really and absolutely need to have a clustered index on that table, and you should really have a primary key. If you leave the table as a heap,...

Derrick Smith (9/29/2010)

---

Michael Valentine Jones (9/29/2010)

---

Derrick Smith (9/29/2010)

---

Michael Valentine Jones (9/29/2010)

---

Normally, you do not want to overwrite a prior backup, because it leaves you without a backup file if something...

jackimo (9/30/2010)

---

Micheal that doesn't work for me because the column is a datetime column so I need a conversion to get only the date, unless I'm missing something?

IE the date...

Really bad idea:

WHERE

CONVERT(DATETIME,LEFT(CONVERT(VARCHAR, b.event_time, 120),10)) >= '20100901'

and

CONVERT(DATETIME,LEFT(CONVERT(VARCHAR, b.event_time, 120),10)) <= '20100930'

This will be much better if you have an index on event_time, because it allows you to use the index.

where

b.event_time...

Derrick Smith (9/29/2010)

---

Michael Valentine Jones (9/29/2010)

---

Normally, you do not want to overwrite a prior backup, because it leaves you without a backup file if something goes wrong while you are...

Normally, you do not want to overwrite a prior backup, because it leaves you without a backup file if something goes wrong while you are running a backup.

There is a good chance that setting your database to read_committed_snapshot (row version isolation) will resolve your deadlock issues, and will eliminate most blocks created by long running selects without...

This is probably the easiest, and it works with all versions of SQL Server from 7.0 on:

select * from INFORMATION_SCHEMA.COLUMNS

adev 1388 (9/27/2010)

---

Hi All,

Actually I have got a task to match all the tables of 2 servers (QA and PROD) and add tables to which

ever database doesn't have one or...

Have you verified that the table is not a heap (has a clustered index)?

From SQL Server 2008 Books Online:

"Configuring and Starting the Transact-SQL Debugger

...

...

The requirements to start the Transact-SQL debugger are as follows:

SQL Server Management Studio must be running under a...

I see what the error is:

SQL Server 2000 (compatibility mode 80) does not allow functions to be used as input parameters for table valued functions, while they are allowed in...

DB_ID() has been a valid function since at least SQL Server 7.0

I think these people learned that:

Death by Delete

http://thedailywtf.com/Articles/Death-by-Delete.aspx

"...Unfortunately, the single delete query proved to be far more...

This function returns age in years, and handles the specific cases you mentioned.

Age Function F_AGE_IN_YEARS:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74462