Isn't there any way to quickly find my recent posts?  Like click one button.

"There seem to be so few ER diagrams in the real world, especially from vendors, who should always produce one for clients."

Taking this further, I have seen very...

"In SQL Server, the page is an 8KB block of contiguous disk space."

A page in SQL Server is an 8 KB block whether it is in memory or on...

It amazes me when they make a movie of an old TV series that I thought was terrible even when I was a kid.

Lost in Space

The Brady Bunch

Charlies's Angels

Car 54,...

You can backup to a network URL:

\\MyServername\MySharename\MyFoldername\MySubfoldername

The windows login that is running the maintenance plan must have permission to the write to the target folder.

Divide 231,379,468,288 by 1,073,741,824 to get 215.5 GB

If the result set returned by the second procedure is more than a few rows, the performance impact is likely to be large, since you would be processing a row...

snomadj (3/5/2015)

---

I have a column in a docave table (timecreated) that is typed bigint.

I cannot for the life of me figure out how to convert this into a sensible datetime...

Jeff Moden (2/28/2015)

---

kennethrinderhagen (2/27/2015)

---

Yes/NoA logical field can be displayed as Yes/No, True/False, or On/Off. In code, use the constants True and False (equivalent to -1 and 0). Note: Null values...

You should consult DBArtisan documentation and technical support because the software is trying to do something with an incorrect setting of QUOTED_IDENTIFIER.

As a workaround until you have this resolved, you...

You can use the function on the link below to calculate Age using @START_DATE = birthdate and @END_DATE = today.

Age Function F_AGE_IN_YEARS

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

You should consider setting the database to Read Committed Snapshot.

That would probably eliminate the need to use NOLOCK, because readers would not be blocked, and you would be returning consistent,...

I have done this in order to avoid having to create an index on the string column.

Since this column is a unique identifier, you would probably still need a unique...

You should determine the minimum time that a backup could take to run by running a test backup to the NUL device.

This will give you the shortest possible time that...

cphite (2/24/2015)

---

Does anyone know of an easy way to get notifications from specific steps in a SQL job?

I have a nightly job that fills reporting tables, and I...