Forum Replies Created
Viewing 15 posts - 4,711 through 4,725 (of 5,356 total)
-
RE: Presentations/SQL queries
Hi Andrew,
quote:
Is there an alternaive way of creating graph/chart presentations based on queries other than using Crystal/Business Objects etc...? maybe VB etc..... -
RE: Option to see threads that I'm involved in?
Hi SQLBill,
quote:
I would like to see an option where I can select it and get a list of the forums that I... -
RE: Question on SQL 92 and 99
quote:
As for text link no. But you may not be familiar with Acrobat reader. If the data was text to begine with... -
RE: If PK is a GUID, what index type is best?
Hi James,
don't blame this on me. What I have written was taken word by word from a book about SQL Server Performance Optimization
Cheers,
Frank
-
RE: Question on SQL 92 and 99
Hi James,
quote:
I cheated. If you look at the link posted by Noel you will find on the first page the documents id.... -
RE: Best practice when to use an index
quote:
http://www.sqlservercentral.com/columnists/awarren/worstpracticesnotusingprimarykeysandclusteredindex.aspI'm going to read this first, before going any further
I must admit after reading that...
-
RE: If PK is a GUID, what index type is best?
quote:
As for a hidden clustered index that is not true. The table remains in a heap with no logic order. When the... -
RE: Best practice when to use an index
Hi Hans,
quote:
Well, don't get me wrong.I won't, your opinion is very welcome!
What a nice coincidence,...
-
RE: Best practice when to use an index
Hi Hans,
quote:
I don't understand your point? Why do you so forcefully express that your Identity column HAVE to be your primary key?
-
RE: How many records can SQL Server handle?
Hi Hans,
quote:
Interesting note:* When creating a non-unique clustered index on a table, MSSQL adds a UNIQUE value to the non-unique data to...
-
RE: write conflict
Hi alicejwz,
from what you have sent me off-forum, could it be you have a bit field in one of your tables without a default value? That's working in Access, but...
-
RE: write conflict
Hi alicejwz,
ahem, sorry maybe I am missing something, but what is the error message you get?
Cheers,
Frank
-
RE: updating data
quote:
As I suspected, tried with spcific columns but still the same error..............so are there any...
-
RE: updating data
Hi Andrew,
quote:
ive inputted the following:insert into customer
select * from clnpers
WHERE NOT EXISTS (
SELECT * FROM customer WHERE
customer.cust_id = clnpers.cust_id
AND customer.rec_fname...
-
RE: Question on SQL 92 and 99
quote:
I cheated. If you look at the link posted by Noel you will find on the first page the documents id. "ISO/IEC...
Viewing 15 posts - 4,711 through 4,725 (of 5,356 total)