Analysis Services (SSAS)

Technical Article

RE: Question of the Day for 29 Jan 2004

  • Reply

I didn't know that you could license SQL Server to a person.  I thought there were only two licensing options.CALPer processorIn my case I deal exclusively with systems accessible via the web so only per processor applies to me.Most people don't give a pair of fetid dingos kidneys about licensing until FAST come knocking at […]

You rated this post out of 5. Change rating

2004-01-29

Technical Article

RE: Encryption

  • Reply

Are you sending encrypted data or looking to encrypt the data stream? SSL will encrypt the stream, but the data will be text in the server. If you encrypt on the client, then you don't need to owrry about the stream.

You rated this post out of 5. Change rating

2004-01-27

Technical Article

Best Practice - Copy Database

  • Topic

Wondering what the best practice or best approach would be to solving a problem.  We are currently migrating from IIS to Sun Java Web Server.  This is being done to address various security flaws in IIS.  So the plan is to move all the applications and database to a development / test environment and run […]

You rated this post out of 5. Change rating

2004-01-27

1 reads

Technical Article

RE: Bulk Insert

  • Reply

Thanks for the input.i have added a secondary file group and set the non clustered indexes on it.Primary file (-group) is auto-growing.The application is basically a for data-mining. We have given the facility to query the data while it is being loaded; loading is a continuous process with a bulk-insert batch size of 100,000. Hence […]

You rated this post out of 5. Change rating

2004-01-22

Technical Article

RE: Transaction/sec performance counter

  • Reply

Hi,In the sysperfinfo table there is a value  Transactions/sec in the column counter_type. So you would need to probably check the cntr_value corresponding to this row. you would need to check the cntr_value for object_name SQLServeratabases, counter_type Transactions/sec,   instance_name <database name> and counter_type 272696320correct me if i am wrongCheers

You rated this post out of 5. Change rating

2004-01-20

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

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...

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