You...

I would say that on a typical database, you can expect around 60%-70% compression, but it depends on the data. In general, the more string (char, varchar, nchar, nvarchar,...

I think the selection criteria below will give you a much more accurate result, especially taking into account birthdays like Feb 29.

select

birth_date

into

#juvenile

from

( --Test Data

select birth_date = convert(date,'1994-10-03')union all

select birth_date =...

sql-lover (10/3/2012)

---

Faced 1st challenge (dumb error)

I can't use "n" option with BCP or re-inserted from source table. Source has "int" on that column. Target table already has the new "bigint"...

foxxo (10/3/2012)

---

What about adding a new BIGINT column with NULL default so theres no locking, populate with values via script in batches.

Then have a short outage while the new...

select

Max_Value =

(

select max(a.x)

from

(

select x = t.value1 where t.flag1 = 1union all

select x = t.value2 where t.flag2 = 1union all

select x = t.value3 where t.flag3 = 1union all

select x = t.value4...

I am trying to imagine a real world situation where IF/ELSE nested so deeply would be the way to go, instead of some other logical construct.

You should post the code...

I originally wrote...

You can use the function on the link below to find the age:

Age Function F_AGE_IN_YEARS

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

sqlfriends (9/24/2012)

---

Recently I tried to restore a database to a point of time using SSMS, for this case I would want to restore to Last Friday status.

I select the database,...

kingdonshel (9/21/2012)

---

I have server Admin password, however even when I choose the AdventureWorks Database from the dropdown and run the below query I get an errror messg.

eg select *...

Another short one.

select day('')

David Moutray (9/20/2012)

---

GilaMonster (9/20/2012)

---

I can think...

This is short and obscure: :satisfied:

select cos('')

Results:

----------------------

...

This isn't that short, but at least it's obscure. :ermm:

select power('','')

Results:

...