XQUERY

Technical Article

RE: BI Naming conventions

  • Reply

I always run into issues as I have to name objects with the absolute in non-techie user in mind. Most database naming schemas won't work for BI end users. When I am asked to build a cube I work with a few of the users and build a template that includes all naming conventions for all dimensions and […]

You rated this post out of 5. Change rating

2004-02-18

1 reads

Technical Article

LOG FILE ERROR

  • Topic

Hello,I am new to SQL Server databases. We have an application that uses SQL Server2000 as the database.I have been getting the error "Log file full".  I have checked the AUTO GROW option and it is already enabled. Please let me know what other situations might lead to the system generating the LOG FULL error […]

You rated this post out of 5. Change rating

2004-02-16

1 reads

Technical Article

RE: FK to a View

  • Reply

You can use an INSTEAD OF trigger. -- Chris Hedgate @ Extralives (http://www.extralives.com/) Co-author of Best of SQL Server Central 2002 (http://qa.sqlservercentral.com/bestof/) Articles: http://qa.sqlservercentral.com/columnists/chedgate/

You rated this post out of 5. Change rating

2003-12-16

2 reads

Technical Article

RE: SQL Server User

  • Reply

Thank you AdiCohn for your comments. I am experiencing two problems in changing the application-user to Sql-user. 1) My system is too complex having almost 350 tables and 80 or more data entry screens, 200 more report screens. It is something like an ERP system. In Sql server I can give only table level permissions. […]

You rated this post out of 5. Change rating

2003-12-09

1 reads

Technical Article

RE: Linked servers query problem

  • Reply

If I understand you right, yes. My understanding of severity levels on errors isn't what it should be- I don't know if they error you are getting actually fails the batch/sp. Using string executes I would think it wouldn't matter though. Give it a shot unless someone more knowledgable gives a better solution.. fetch... begin […]

You rated this post out of 5. Change rating

2003-11-21

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