I enjoyed it but the answer about changing the SQL Login has me confused.

The answer says use an UPDATE query on the SysLogins table and then also says manual updates...

Robert,

I don't have the specific example to hand as its in an archived project library.

From what I remember I wrote code to produce a paginated list of records from a...

How many users? In excess of 30,000.

What you could do is write your GUI so that your main user interface is in a bald HTML file and that file is...

I take it that you are talking about a web application?

I have found that tasks that are too small to affect the performance of normal apps become massive overheads on...

I use nested stored procedures for the same reasons.

I quite often have

 

IF .....

   INSERT #Tbl (Fields)

   EXEC usp_SelectProc1 @Arg1, Arg2...Argn

ELSE

 ...

quote:

---

Or, as I once heard "Squeeel"

---

This is how it's pronounced if you're a finance director...

I had a huge document on performance characteristics of ORACLE, SQL Server, MySQL, DB2 and one or two others that included JDBC performance.

I thought it was on http://www.mysql.com but I...

You should see the Russian for "restaurant". It can be rendered as "ÐÅÑÒÎÐÀÍ" in standard font but looks rather more complex in cyrillic. To add to the confusion...

It takes a special sort of genius to name a function so that is so short it qualifies for a noise word in search engines!

I can't see that anyone...

What exactly does N'string' do? Is it really necessary?

I liked the idea of developing and testing with your own "schema" before cutting across to a dbo implementation.

It is not a facility that I commonly use and I don't...

Reading through my old MS notes from SQL 6.5 days it appears that running UPDATE STATISTICS on a table will recreate all distribution statistics within an index. Moving forward...

Lee,

quote:

---

not every DBA -- not even every Oracle DBA 🙂 -- is so arrogant.

---

It...

I've used Notes. It is more of a document management system that an RDBMS.

If you are storing documents then, obviously Notes is the way to go. ...

Age old problem, age old solution.

There is never time to do it right but there is always time to do it over!