rbalmf (8/1/2010)

---

Sure, we've invested so much money and 10 hard years learning this stuff that we just have to use it right?

You're entitled to your opinion of course, strange COBOL...

MIN/MAX Across Multiple Columns

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

This script demonstrates two methods for finding the maximum value in a row across a set of columns in the row when any or all of the...

It is a way to create an endless loop that you will exit using the BREAK command, instead of when the test condition is true.

while 1=1

begin

<Do something>

if <some condition is...

OP might just have SQL Server configured to not use more that 4 GB of memory.

Or the databases are small enough that SQL Server doesn't need more than 4 GB...

Steve Jones - Editor (8/12/2010)

---

SQLPing is a utility that can help with this as well. The site appears to be down now, but it's a nice utility.

Note that this only...

You could cast them to varchar(max) to do the join, or better yet, convert the columns to varchar(max).

A way you could speed this up is to create an indexed integer...

It is used by people who have a desire to know if their database is corrupt while they still have time to do something to fix it without a catastrophic...

Your trimesters...

I think you need to post a usable definition of exactly what a trimester is before someone can write code to give you a trimester.

Not SQL humor, but DBA humor:

A Few Good DBAs

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

The Silence of the DBAs

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

select

a.NUMBER

from

-- Function F_TABLE_NUMBER_RANGE available on this link:

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

dbo.F_TABLE_NUMBER_RANGE(5001, 5999) a

Results:

NUMBER

-----------

5001

...

According to Paul Randal' blog msdb.dbo.restorehistory is not populated by a restore from a snapshot, at least in SQL 2005:

http://www.sqlskills.com/blogs/paul/category/Database-Snapshots.aspx

"So how can I tell when the database was reverted? Books...

Did you see an entry in [msdb].[dbo].[restorehistory]?

You may be looking for:

select * from master.dbo.sysaltfiles

You can use the following script to get more detailed information:

Get Server Database File Information

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

Not using groups becomes impractical at a certain point.

Trying to add individual logins to SQL Servers when you have hundreds of servers, thousands of databases, and 20,000+ users is a...