quote:

---

I don't believe you can use NULL with DATETIME or SMALLDATETIME datatypes. DATETIME and SMALLDATETIME have defaults so that means NULL isn't...

You can insert the result set from a SP that returns one into a table by using the INSERT INTO...EXECUTE... syntax. It's covered in BOL under INSERT (described). ...

You can indeed set constraints to 'NOCHECK' but that will not allow table truncation.

You'll need to drop the foreign key constraints in order to truncate the tables they...

I suggest using neither bitmap nor separate columns. You admit that this may need to be extended...

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16423

--Jonathan

Edited by - Jonathan on 10/27/2003 09:14:04 AM

This doesn't need to be a stored procedure, as it's just one query:

USE Northwind

go

SELECT n.dow, ISNULL(SUM(o.Freight),0)

FROM Orders o RIGHT JOIN 

(SELECT 1 dow

 UNION ALL SELECT...

Perhaps something like this?

SELECT c.Item_No, c.Item_YesNo, c.Item_Date

FROM CheckList c JOIN

(SELECT Item_No, MAX(Item_Date) Item_Date

 FROM Checklist

 GROUP BY Item_No) m ON c.Item_No = m.Item_No AND c.Item_Date =...

quote:

---

I have read BOL numerous times... and all transactions are very short in duration. What I see happening is completely contradictory....

quote:

---

Here's what was given to me for my recommendations:

Idea before DBA input:

Our environment includes 3 Web Servers(IIS) which are load balanced, 2...

Read BOL entry on Checkpoints and the Active Portion of the Log.

If you have the recovery interval set to the default of zero, then (unless you're using the simple recovery...

If you're seeing a lot of these messages, perhaps you've got one or more of the databases set to AUTO_CLOSE...

--Jonathan

My guess is that AWE is not set up properly. What is SQL Server's memory usage? (SQL Server: Memory Manager: Total Server Memory (KB) or just Mem Usage...

Yes, you do. The only type of disaster recovery (DR) server that doesn't need its own license is the non-active server in an Active/Passive failover cluster.

--Jonathan

quote:

---

Here's a user defined function that does what you need. You will have to create tblHolidays and populate it with all...

That's normal but not guaranteed.

It's best to explicitly order any result set that should be ordered. It doesn't cost you anything but the extra typing.

--Jonathan

quote:

---

Thansk for all this great info.

I am sorry I neglected to provide some pertinent information about our server farm concept.

It appears that...