I think the way Microsoft has positioned SQL Server in the market place has a lot to do with this. The idea is to make a full featured database...

I think that younger people can have a different view of technology than people that are a little bit older. They may be past the point where it is...

This script is used to shrink a database file in small increments until it reaches a target free space limit.

Shrink DB File by Increment to Target Free Space

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

Object permissions are stored in system tables in each database, so it isn't really possible for the permissions to be different, because they are restored along with the rest of...

Well, it is up to them to make the decision. Just tell them your opinion, give them the facts, and let them make it.

If it all goes wrong, they...

Fraggle-805517 (9/30/2009)

---

Mark Marinovic (9/30/2009)

---

For...

Fraggle-805517 (9/30/2009)

---

Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database without disturbing the...

Ask the vendor to write up in detail exactly how they would do a database recovery to a specific point in time to a new database without disturbing the old...

The problems that I see with generalizations is that they tend to conform to the opinions and prejudices of the author, and are rarely backed up by meaningful data.

Even if...

If you post 5 or 6 number/datetime pairs, there is a good chance someone could figure it out. Numbers over a large range of time would be best.

It's hard to speculate what is wrong with code you didn't post.

Maybe it has nothing to do with dynamic SQL. Maybe the query is just not returning any rows.

When you divide 1 by 2 (1/2) you are doing integer math, so the remainder is dropped. Cast the values to numeric first if you want numeric results.

Example:

select A...

321 MySQL (9/29/2009)

---

GSquared (9/28/2009)

---

Tobie-189314 (9/28/2009)

---

Forgive me for being simple... LOL! Had to read the question a couple of times, but, isn't it easier just to do the following? Or did...

You could also have it do almost nothing.

declare @a int , @b int, @c int

select @a=0,@b=0

if @a=0 and @b=0

set @c=@c

else

select * from table1 where id=@id

If you come to SSC or other site just looking for a quick answer and are not prepared to test them yourself, you are setting yourself up for trouble.

It’s no...