dant12 (4/26/2011)

---

depending on the fill factor settings and table load, indexes can take awhile to actually get fragmented. getting an actual percentage of rows not currently compressed can factor in...

dant12 (4/26/2011)

---

Reading through this http://msdn.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx SQLCAT post, it is stated that under certain condititions a row in a PAGE COMPRESSED table can be ROW COMPRESSED instead of actually PAGE COMPRESSED.

My...

Work from home doesn't have to be impossibility for a management job.

A friend of mine worked from home full time and managed the IT infrastructure group for a large IT...

Brandie Tarvin (4/26/2011)

---

Ninja's_RGR'us (4/26/2011)

---

Michael Valentine Jones (4/26/2011)

---

Brandie Tarvin (4/26/2011)

---

Michael,

You're right. Totally my bad. I was working of a SQL 2000 assumption and by the time I figured out I was...

Brandie Tarvin (4/26/2011)

---

Michael,

You're right. Totally my bad. I was working of a SQL 2000 assumption and by the time I figured out I was wrong, I was rushing to correct...

There is no reason that someone working from home should be making less money just because they are working from home. It makes it seem that they are somehow...

You CAN do online indexing when in compatibility level 80.

The following code ran fine for me under 2005 Enterprise Edition; never hurts to test. 😎

USE [pubs]

select compatibility_level, name ...

You can't restore without a full backup to start with.

I think they should have been much more careful about letting you know that they were booking flights from two different airports. Depending on your hotel location, it could...

There is no default for the datetime datatype.

Probably what you are doing is inserting a zero-length string into a datetime column and that will get cast to a date of...

I'm just hoping to see someone use it in production code. :satisfied:

Actually, I started wondering if a function that returned a...

Craig Farrell (4/20/2011)

---

Actually, that part attracted me. Instead of some poor schlep working all day then being on...

terrykzncs (4/20/2011)

---

Just a quick comment.

Most of us still have SQL 2005 but will (hopefully soon) migrate to SQL 2008.

In SQL 2008 it will be alot easier to insert multiple...

This is sure to attract interest: "3rd shift rotation"

I doubt this is is a good idea, but you can return the value in a sql_variant.

create function dbo.F_TEST ( @MyValue int )

returns sql_variant

as

begin

declare @MyVariant sql_variant

if @MyValue is null set...