DROP TABLE MYEXAMPLE

go

CREATE TABLE [dbo].[MYEXAMPLE] (

[EXAMPLEID] INT IDENTITY(1,1) NOT NULL,

[EXAMPLEFLAG] CHAR(1)...

The primary reason for over-engineering is “over-specing”, where business users demand features that are costly to deliver and provide little business benefit.

They have little understanding of what a feature actually...

Set the database that you are trying to restore over offline before doing the restore.

alter database MyDatabase set offline with rollback immediate

Use a backup compression utility that will also create encrypted backup files. I know that LiteSpeed will do this, and I believe Redgate backup will do it also.

This will...

Have you tried your check on the result_value column with a CASE statement?

where

id_type = 'MR' ...

select

a.DT_In,

DT_Out =convert(datetime,stuff(stuff(stuff(stuff(a.DT_In,15,0,'.'),13,0,':'),11,0,':'),9,0,' '))

from

( --Test Data

...

In any case, there is a lot worse advice out there than “Never use Cursors”. In the world of bad advice, it’s kind of fail-safe bad advice that probably...

Here is a great story about a "Spreadsheetized" design where all the companies data was stored in a single table.

Death by Delete

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

"...

One day, a developer was optimizing the database and...

Why do you want to limit the memory? SQL Server is designed to maximize performance by having as much data as possible in memory.

Matt Miller (7/10/2009)

---

Michael Valentine Jones (7/10/2009)

---

19000107 is Sunday, Jan 7, 1900.

The code finds the number of day since 1900-01-07, divides by 7 to get the number of weeks since than,...

1753-01-01 00:00:00.000 is the earliest possible SQL Server datetime value.

I believe that the reason 1753 is used is because that was the first full year that English speaking countries used...

19000107 is Sunday, Jan 7, 1900.

The code finds the number of day since 1900-01-07, divides by 7 to get the number of weeks since than, and adds that number of...

John Rowan (7/10/2009)

---

Ha! I'll have to second that one. Not just in forums, but this one...

The title of this thread reminds me of this book:

Real Americans Admit: "The Worst Thing I've Ever Done"

http://www.amazon.com/Real-Americans-Admit-Worst-Thing/dp/1561631574#

Maybe we need a new thread: "The Worst Advice I've Ever Given"

Advising people to always use a NOLOCK hint to prevent blocking, with no explanation of the potential problems or even an understanding of the problems.

It’s a real sore point with...