Viewing 15 posts - 5,416 through 5,430 (of 8,416 total)
Lynn Pettis (3/13/2010)
March 13, 2010 at 7:43 pm
CREATE TABLE dbo.AAATable01
(
K1 INTEGER NOT NULL,
...
March 13, 2010 at 6:43 am
david_wendelken (3/13/2010)
I'm sorry some of you can't see it and that I'm failing to explain it well enough for you to do so.
It is not that I cannot see the...
March 13, 2010 at 6:13 am
djrgreene (3/12/2010)
March 13, 2010 at 6:08 am
lmu92 (3/13/2010)
your nonclustered index is unlikely to be used since it has the same leading column as your clustered index.
The NC index can support seeks over the three keys it...
March 13, 2010 at 4:28 am
GilaMonster (3/13/2010)
The error has to do with parsing, the parser doesn't execute the code and sees the same table been created twice, hence the error.
Lutz...:laugh:
March 13, 2010 at 4:24 am
The design, as has been said, is pretty ordinary.
To avoid many horrible problems in future, I recommend you read the following, carefully:
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx
Paul
March 13, 2010 at 4:19 am
GoGreen (3/12/2010)
I am trying to import data from file(txt, xls) using multiple Insert statement.Is there any limitation on query size that SQL server can handle at one time?
That looks more...
March 13, 2010 at 4:15 am
If INSERTs do not normally occur in the logical order specified by the clustered index, you will eventually start to suffer from excessive page-splitting, which will slow INSERT operations significantly....
March 13, 2010 at 4:08 am
stelianx (3/13/2010)
it is designed by updating totals with triggers and it's working quite well.
I used to use triggers for this before there was an alternative. Indexed views are superior...
March 13, 2010 at 3:51 am
Mike,
Hoping that it will be helpful to you, I have tidied up your script and implemented Gail's suggestion for the UPDATE.
-- Drop any existing test tables
IF OBJECT_ID(N'tempdb..#Customer', N'U')
...
March 13, 2010 at 3:43 am
BEGIN TRY
BEGIN TRANSACTION;
SAVE TRANSACTION [DoInserts];
IF NOT EXISTS
(
...
March 13, 2010 at 3:24 am
GTR (3/13/2010)
Yes, that is why, what if mdf and ldf files are corrupt while attaching detaching databases? That is why we have best practices am i wrong?
You need to read...
March 13, 2010 at 3:15 am
Lynn Pettis
I would not store the total of the Invoice Lines in the Invoice Header record. This can be computed as needed when the header record is read.
This is...
March 13, 2010 at 2:56 am
stelianx (3/10/2010)
...in production, sometimes the invoice total is different then the sum of all the invoice lines. How can I stop this happening?
Get SQL Server to do the hard work...
March 13, 2010 at 2:52 am
Viewing 15 posts - 5,416 through 5,430 (of 8,416 total)