sp_who2

Technical Article

RE: Pet Peeves

  • Reply

Hey Sandman, quote: People who put on their emergency flashers when it rains. I can see that it's raining, thank you very much. So turn off your flashers, put out your cigarrette (use the ash tray ), hang up your cell phone, and just drive please. just a note on this. I too was agrevatied […]

You rated this post out of 5. Change rating

2003-09-12

Technical Article

RE: Pet Peeves

  • Reply

The American and the Japanese corporate offices for a large multi-national corporation decided to engage in a competitive boat race. Both teams practiced hard and long to reach their peak performance. On the big day they felt ready. The Japanese team won by a mile. Afterwards, the American team was discouraged by the loss. Morale […]

You rated this post out of 5. Change rating

2003-08-22

Technical Article

RE: MS. Access to SQL Server 2000

  • Reply

Another thought... Most of the comments have suggested that moving the data will be the easy part and that recreating the queries and code will be where to work comes in. While it is very easy to recreate Access tables in SQL and move the data, this is also where (if you look closely) you […]

You rated this post out of 5. Change rating

2003-08-21

1 reads

Technical Article

RE: Building Business Intelligence Data Warehouses

  • Reply

Definitely a high level (somewhat academic) review of Data Warehouses. The clients my company interacts with don't have "steering committees" but do have business needs that we are solving. Sometimes the road to the Enterprise or large Departmental Data Warehouse is through Data Marts that conform through dimensions. I am not slamming the article but […]

You rated this post out of 5. Change rating

2003-07-14

Technical Article

RE: Best practice how to calculate row size

  • Reply

Hi Dale, quote: This may be what you are looking for: quote: Estimating the Size of a Table The following steps can be used to estimate the amount of space required to store the data in a table: Specify the number of rows present in the table: Number of rows in the table = Num_Rows […]

You rated this post out of 5. Change rating

2003-07-14

1 reads

Technical Article

RE: One or more databases are inaccessible

  • Reply

I get this message when I take a database off-line and then access a login's properties. (My development server is a very basic machine and this can help to conserve resources.) This will not cause a problem when you are setting up the login except that you cannot give it permissions on the off-line database […]

You rated this post out of 5. Change rating

2003-07-14

1 reads

Technical Article

RE: QOD - RAM available to SQL 2000 Standard

  • Reply

Yes, and this is actually true of any app. Unless the OS was booted with the /3GB switch or the /PAE switch and the app has been configured properly to use AWE memory, all applications are limited to 2 GB. The /3GB allows an app to expand to use 3 GB (provided there's memory available). […]

You rated this post out of 5. Change rating

2003-06-30

1 reads

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