Eric M Russell (7/14/2011)

---

Craig Farrell (7/14/2011)

---

Eric M Russell (7/14/2011)

---

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a...

In memory databases don't do well when the power goes off.

Facebook is a good way to slightly interact with relatives and others that you don't really want to have that much to do with while keeping up the illusion that...

The statement fits in nvarchar(max) OK, you just can't see all of it using the PRINT command.

If you really need to print the entire statement, you can use the SUBSTRING...

All the links seem to say that the database limit is 4 GB (or 10 GB on some links), but I haven't seen anything that says your application has a...

You run this query in your database to calculate the number of striped backup files to create so that all can fit within the 4 GB limit. Then use...

YSLGuru (6/27/2011)

---

Thanks for the link. I have a possibly dumb question though. When testing the code out I ran...

If you mean UPDATE STATISTICS WITH FULLSCAN, weekly or monthly is probably enough for most situations.

However, I often setup a job to run nightly to run EXECUTE SP_UPDATESTATS in active...

Sounds like a software vendor worried that someone may look at their database design and stored procedure.

Backing Up and Restoring Databases in SQL Server

http://msdn.microsoft.com/en-us/library/ms187048(v=SQL.100).aspx

Get Server Database File Information

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

A CASE expression can only return a single data type, so you will always get a NUMERIC(13,3).

You should be able to do the conversion "inline" in your code without a UDF.

select

a.*,

NewDT = convert(datetime,left(a.DT,23)),

NewDTPlusOffset=

case left(right(a.DT,6),1)

when '-'

then convert(datetime,left(a.DT,23))-convert(datetime,right(a.DT,5))

else convert(datetime,left(a.DT,23))+convert(datetime,right(a.DT,5))

end

from

( --Test Data

select DT = '2011-06-15T23:13:02.000-04:00'union all

select DT = '2011-06-15T23:13:02.000+06:00'

)...

I doubt more regulations would do any good.

Any new regulations are likely to be written in such a way as to increase the profits of various vendors selling security consulting...

The Dixie Flatline (6/22/2011)

---

However, my real reason for posting was to point out the true complexity of coding a CASE based solution with a large number of columns vs. the...