Forum Replies Created
Viewing 15 posts - 16 through 30 (of 61 total)
-
RE: Default order of rows without order by clause
Short question
There is no default order of rows without an Order By clause. You may get the rows always sorted the same way,...
-
RE: Partition in SQL Server 2005
You "hear" to many things. Read the BOL instead, it's a free download.
Partitioned views and table partionning are 2 different beasts. Of course it knows where to store/get the data....
-
RE: Hash Joins and Point based Joins
Your "heard" half right. SQL2k AND SQL2k5 both support hash joins (among others). Everybody use them, although most people don't know it
The query...
-
RE: ELT vs ETL
It depends. ETL is much faster and can handle much more complex logic. DTS (now renamed SSIS I think) are specialized for it.
ELT is a good choice when the amonount of...
-
RE: For each record execute stored procedure
With SQL2K there is the unsupported xp_execresultset that was handy. With SQL2k5, you may have to rewrite it in C# I think.
Example (doing an insert but you get the point):
-
RE: COALESCE Vertically??
Noeld,
If you read the entire thread, you will notice that:
- the triggers are indeed logging only changes*
- a TRANSACTIONID** (the RECVER column) is indeed used in the log table for the PK.
- there is NO...
-
RE: COALESCE Vertically??
Datetime is an imprecise datatype. You always have +-3ms.
Try this:
Select cast('2006-05-15 23:59:59.999' as
-
RE: COALESCE Vertically??
Here it goes:
/*
For performance reasons, I am using a RECVER (record version) column instead of the update timestamp.
That column exists to support optimistic concurrency across n database vendors
It...
-
RE: COALESCE Vertically??
Ryan,
In did not forget the example. While coding it I discovered a flaw in my logic (I can end up with a data anomaly with the "first" row, i.e. the...
-
RE: COALESCE Vertically??
Sorry about the lack of examples Ryan. I posted the table structure but I had so many alternatives I had tried it would have been confusing. Some of them worked...
-
RE: COALESCE Vertically??
Thanks for replying. I am doing a delta instead of a full copy because copying the full row would kill the server. We get thousands of tran per minutes. Some...
-
RE: Question of the Day for 26 Apr 2006
I got it right by guessing, since the choice of words was misleading. The OVER clause is a CLAUSE, not a FUNCTION. And the DENSE_RANK* answer was almost right by...
-
RE: Does Commenting Degardes performance of SQL Server
No effect on execution time. No effect on compilation time either but I suppose you should have some effect on parse time. It is also consuming some additional amounts of...
-
RE: Can I store object or object''''s information in database (SQL Server 2005)?
Please do not cross post to multiple forums.
You can store anything in SQL (anything that can be expressed digitally I mean
) .... -
RE: Long, long data rows , what to do?
The question doesn't make much sense. Please provide some DDL if you want help. A "row" width is not calculated is number of characters, so I suppose you are refering...
Viewing 15 posts - 16 through 30 (of 61 total)