jimbobmcgee (2/11/2011)

---

I might be fuelling the fire here, as I'm merely playing devil's advocate rather than agreeing wholeheartedly with the approach...

But, for the people who say that the DBAs/analysts should...

Thank you for the link. The posts in the link that you provided above has 5th Nov 2009 as its first post date....

I just thought I should share an article[/url] by Thomas LaRock (SQLRockstar) on possibly a better & way more practical option to avoid SELECT *. Keywords: sysdepends & PBM.

I usually choose ADO and loop through it...and it works. Give me my 2 points!

All,

Thank you for the feedback and comments. Keep 'em coming. Appreciate it!

This article was meant to suggest a possible way, as an idea (a rude one perhaps) to prevent the...

Do you get any error messages? If not, it's possible that you had moved the window the last time you used it and it is still around but unseen easily....

Like some have already pointed out, WHERE 1=1 is helpful while trying out additional conditions only since it seldom adds value if it's part of the final code. Code generators...

Here's one way...

If you use the command line utility dtsexec, you could create a batch file. The batch file would do 3 things:

- Delete any old log file

- Rename the...

Shailesh Chaudhary (6/26/2008)

---

I have two tables in SQL server 2005

Sensors

SensorDetails

Sensors has two records for sensorID

0000000000805080

12345

SensorDetails has lots of records that comes online and dumped into the table e.g

SensorID ...

zubamark (6/13/2008)

---

Hi,

It should work on SQL2005 and 2000.

id name

-- -----

1 John

1 Bill

1 Marc

4 Jack

I need:

id name

-- -----

1 ...

Try giving the initial size as the amount of space it would need during the first load.

You could keep the initial size as say 100 MB or 500 MB...just an...

Interesting one. The reason could be due to the rounding off. BOL says:

"datetime values are rounded to increments of .000, .003, or .007 seconds"

Thanks GSquared & GilaMonster

If you are looking only for data differences, redgate's SQL Data Compare is an awesome tool for data compare & update.

freephoneid (6/9/2008)

---

Hi,

I've a column Event_Desc(255)nvarchar in a table. If I insert a record in it through stored procesure which is more than 255 chars, it gives error.

Can any one...