Viewing 15 posts - 3,451 through 3,465 (of 3,617 total)
quote:
Why was it called Port and Starboard? Does the ship only sail one way, keep the stars on the left(?)
May 27, 2003 at 2:22 am
I prefer to use a deleted date field that acts as a flag in the critical tables.
This means that I can also identify when a record was deleted. When...
May 27, 2003 at 2:07 am
quote:
I enjoyed it but the answer about changing the SQL Login has me confused.The answer says use an UPDATE query on the...
May 22, 2003 at 3:32 pm
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...
May 22, 2003 at 3:27 pm
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...
May 22, 2003 at 8:59 am
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...
May 22, 2003 at 3:50 am
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...
May 22, 2003 at 3:11 am
I use nested stored procedures for the same reasons.
I quite often have
IF .....
INSERT #Tbl (Fields)
EXEC usp_SelectProc1 @Arg1, Arg2...Argn
ELSE
...
May 22, 2003 at 2:07 am
quote:
Or, as I once heard "Squeeel"
This is how it's pronounced if you're a finance director...
May 22, 2003 at 1:54 am
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...
May 20, 2003 at 7:43 am
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...
May 20, 2003 at 7:26 am
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...
May 19, 2003 at 3:06 am
What exactly does N'string' do? Is it really necessary?
May 19, 2003 at 2:51 am
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...
May 19, 2003 at 2:47 am
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...
May 16, 2003 at 2:16 am
Viewing 15 posts - 3,451 through 3,465 (of 3,617 total)