sp_send_dbmail

Technical Article

RE: Question of the Day for 21 Jul 2004

  • Reply

I found the following quote on the MSDN site at:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_6b3k.asp"Using AWE Memory on Windows 2000Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support very large amounts of physical memory. SQL Server 2000 Enterprise Edition can access amounts of memory approaching 8 GB on Windows 2000 Advanced […]

You rated this post out of 5. Change rating

2004-07-21

Technical Article

RE: Optimizing takes too many disk spaces

  • Reply

You said: Data file grows to 71 GB, Transaction log file grows to 57 GB, are those the actual SQL Server files (.mdf and .ldf) or are they the backup files? If they are the backup files, then you probably did not set your maintenance plan to OVERWRITE (WITH INIT). -SQLBill

You rated this post out of 5. Change rating

2003-07-01

2 reads

Technical Article

RE: Handling "optional fields"

  • Reply

When one customer is modifying their extended table, would we see locking issues on the primary table for customers other than the one modifying the extended table? In other words if customer A is modifying ext_tableA and customer B does a join of primarytable to ext_tableB, would customer B experience locking/contention issues? Also, this would […]

You rated this post out of 5. Change rating

2003-06-16

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers