"The argument was that with no stored procs, only the C# code has to be changed even if the database design changes or even if we went to a different...

How about something like:

select

@@servername as ServerName,

name as [Database],

...

Probably wanted

ORDER BY

CAST(Column AS int)

or

ORDER BY

CONVERT(int,Column)

If there is nonnumeric data in the column

the ISNUMERIC function might be handy.

/rockmoose

Try:

update DT_Users

   set Firstname = A.givenName

     , LastName = A.sn

     , Company = A.company

     , Title = A.title

     , Email = A.mail

  from DT_Users U

     , TMP_Accounts A

 where U.Login =...

Good approach Gregory.

Make a small set of high level Database Administration Standards.

Covering the setup of Sql Servers and Databases, including the following:

Security

Backup

Size, growth and placement of Data & Logfiles (not...

Hi Martin,

The main reason for getting an even Worse result when executing the loop is that the results are being displayed in the resultspane...

Which client tool are You using to view the data ?

Using unary operators only tells AS how the data is to be summarized, not whic dimension members or levels are...

My answer would be:

A) The Database Administrator.

The person responsible for defining the names and meaning of business entities is B) DA

In the absurd case the naming standard for database tables...

MartinCross,

Write a loop in QA retriving all the 54k records one by one, and time it.

See how long SQL Server has to work in doing that, might help you determine...

sp_tableoption is an alternative to DBCC PINTABLE ( does the same thing )

use either one that suits the needs.

/rockmoose

Jim,

Order By is not allowed in views the way you proposed.

To order the rows I would suggest Clustered Index on the table.

The view approach would definitely not be faster unless...

Hi,

First make sure that the UID column is indexed.

Also the bottleneck might not be Sql Server, but could be the network or the app.

For the IMDB option You can look...

Would something like this help...

select 'xmlroot>' as Xml_Data

union all

select

'name>'+ltrim(name)+'/name>'+

'id>'+ltrim(id)+'/id>'

-- .........

from dbo.sysobjects

union all

select '/xmlroot>' as Xml_Data

The tags get messed up.. but you get the idea.

/rockmoose

There is a FAQ on this subject here:

http://www.sqlteam.com/item.asp?ItemID=986

/rockmoose

Hi,

Could be 1434 as well.

http://www.microsoft.com/sql/techinfo/tips/administration/port1434.asp

/rockmoose