AFAIK, the answer is no, however, allowing users to develop extensive expressions embedded in reports is just asking for troubles. In enterprise environment I would recommend restricting expression code to...

Gabor, good point. I have no clue as to why first query uses constr_pk_318. Just to clarify, index_319 is a clustered index on renled_parent_id column (int) and constr_pk_318 is a...

Frank,

I think SQL Server optimiser deserves a little more credit. In the sample below I use real table from my database. Table contains about 80k rows and has a clustered index...

Stuart,

I do not believe it's possible - see INF: Frequently Asked Questions - SQL Server - SQL Mail for details. We've had the same issue on the client site and...

MrSQL,

average trigger it is not but trickiest part, IMO, is not multirow update - it's the fact that aggregates cannot be used as update values hence the subselect with grouping.

Mind you, just...

rstone,

hope you're referring to MrSql post, not mine - my version should work for 0, 1 or 10000 rows being inserted (with minor modifications it will work for updates as well)....

How about this

set nocount on
create table table1(
   Customer varchar(10) not null,
   [Date] datetime not null,
   RefNo int not null,
   TotalValue int null,
   constraint pk_customer1 primary key (Customer, [Date], RefNo)
)

create table...

Good question, bad answer and even worse choice of answers. From BOL:

RAID 1 provides fault tolerance and generally improves read performance (but may degrade write performance).

How degraded write performance...

Dave,

unless you can repave your server I suggest you contact PTS - looks like something's seriously wrong with SQL on your machine.

Cheers

--

georged

We had exactly the same problem and it's not related to SP3 (we experienced it after SP2). Try this:

1. Do a search for the file named ftsetup.exe on the SQL...

The easiest way to pinpoint the problem is to run Profiler and capture the exact command being passed to SQL Server. Can you post the command being executed?

--

georged

It would be even more helpful if it was available

quote:

---

Microsoft OLE DB Provider for ODBC Drivers erro '80004005'

[Microsoft][Driver ODBC para Microsoft...

quote:

---

sometimes the best solution is the simplest

...

a) easy to maintain - any novice in SQL can understand the code

b) the selects will...