Each client tool has it's own connection and maybe even different connection settings. For example different values for ANSI_WARNINGS, ANSI_NULLS, QUOTED_IDENTIFIER, etc. can result in different execution plans. Some settings...

Mike Byrd (9/13/2010)

---

At first reading I thought that was a neat idea, but on reflection (and sadly experience), what runs on one machine and one set of data does not...

Jeff Moden (9/12/2010)

---

The "best plan" is dictated only by four things and only two of those really matter where performance is concerned...

4. Code - This is where the true...

The more enlightened economists point out that recessions are a perfectly natural part of long term economic cycles, and it always preceeds some transition to a new paradign. Companies...

When it comes to installing SQL Server Standard and Enterprise edition for a corporate IT groups, these installations are typically performed by a DBA who is familiar with the options...

The following query should give you the last 3 backups for each database and include the columns: database_name, recovery_model, backup_type, size_gb, backup_start_date, backup_finish_date, and duration_minutes.

select * from

(

select...

If Information Technology ever stopped being fun and rewarding, civilization would soon collapse.

What makes the TRUNCATE statement more efficient is that it...

If one is distributing something like a shareware application, where there are potentially thousands of installs with a local instance of the database and you can't field even a small...

kennethje (9/8/2010)

---

thought this was a joke to be honest...

but I've read the articles and must agree that the 2008 R2 story is unfortunate at least.

however...

ever tried to install Oracle?

or worse

create...

This has to do with peer reviews. As IT developers, or any other engineering field in general, we can't judge our own sanity. Also, neither can the client or end...

miki_home (9/2/2010)

---

Oh I feel your pain. We have a free-form "Occupation" field on one of our main Sales applications, so I've just spent weeks building a lookup table to make...

LIYA (9/1/2010)

---

Hi Peter,

At present the testing table have 1628430 records. its' only a 5 month data. but in production it will be 5 time higher. It's a access control...

david_wendelken (8/31/2010)

Yep. You can also end up in jail after asking the officer "Is this a joke?" after he informs you your driver's license was suspended almost 50 years...

anudata (8/31/2010)

---

Thanks for your post. i am facing a similar issue. i have a table which is having the following fields and samle data

empid Transacttiondate ...