If you are having trouble with the transaction log file getting too large, set the transaction log backups to run much more often, instead of having one hour between transaction...

Paul White (5/17/2009)

---

Heh. We are not buying 2.5TB...

I forget the exact pricing but it was something like seven thousand (NZ) dollars for 160 GB. We would probably look...

I'm not sure they have worked out how to do RAID with the Fusion-io yet. They are (said to be) more dependable, but losing a drive is still a...

I saw this 2009-4-6 press release from Fusion-io:

Fusion-io Breaks Storage Performance Barriers, Exceeding 1 Million IOPS and 8 GB/s Throughput Within a Single HP ProLiant Server

http://www.fusionio.com/PressDetails.php?id=81

I think Fusion-io could be...

vickymae222 (5/17/2009)

---

This is the expression I have been looking for. I have a field called Plan End Date that I need to calculate the end of the month...

Why not just create a view in each database with the application ID hard coded in that view:

Create view vAppID as select AppID = 12345

Then use vAppID.AppID in all your...

I think 1.5 was a good guideline when servers had 4 GB of memory or less. I'm not sure if this is something that scales up. I'm trying...

RBarryYoung (5/14/2009)

---

Michael: because you are truncating the ID to 9 digits, I do not...

This will update your SSN column with 9 digit SSN numbers.

update MyTable

set

ssn = right(convert(bigint,convert(varbinary(7),newid())),9)

These are links to my original post of the function from the prior post on this thread, plus another that you might find useful.

Computing the age of someone is more...

The thread below has a stored procedure with my attempt at generating random passwords that can be remembered by a human but still meet complexity rules, along with some general...

A common way to handle this is to have a QA\Deployment team made up of senior level people that are in charge of making production deployments. Database changes often...

Have you verified that the database server and web server have the same time zone settings, and that the system clocks on both servers are set correctly?

It is often better to shrink database files in small increments so that it can make continuous, incremental progress, instead of trying to shrink by a large amount in one...

The most common and worst mistake is failing to develop a normalized data model that fits the real world data.

Most developers seem to just throw tables together with little thought...