Viewing 15 posts - 511 through 525 (of 529 total)
Maybe this is not the best place to ask for basics 🙂 But we all got to learn sometime!
Try to read BOL (Books Online). It (they) are included in SQL...
March 24, 2003 at 12:39 pm
Why not do a Profiler trace and see if SQL server AUTO-STATS?
March 24, 2003 at 11:03 am
Please specify a little more detailed your problem.
quote:
insert correctly the date in a register
March 24, 2003 at 8:15 am
But with HIGH selectivity of the clustered index, you would narrow down that problem hugely. Since we don't know the uniqueness of the 'FDIS_CLAIMSET.CLAIMSET_ID' column, it could very well become...
March 24, 2003 at 1:53 am
Chris, wouldn't a clustered index on 'FDIS_CLAIMSET.CLAIMSET_ID' column (depending on the selectivity) would contribute hugely even if he uses a function?
A clustered index on 'FDIS_CLAIM.CLAIMSET_ID' would probably not be so...
March 24, 2003 at 1:28 am
quote:
access memory objects Pager/Per Sec and Available bytes?
Not sure exactly what you are...
March 21, 2003 at 10:35 am
Excuse me for also wanting to put my feet in the hot tub 😉
Michael,
In SQL 2000, in exactly what way does you feel that the query optimizer separates these two...
March 21, 2003 at 7:33 am
But if you don't have access to the Apps, how are you suppose to do your
quote:
Insert into table (Val,MyAddedField)...
March 20, 2003 at 11:00 am
Solution:
--Create a view that contains all columns from the base table.
CREATE VIEW InsteadView
-- Do the Cast so can specify the TYPE of what you want to 'insert'
AS SELECT Val, CAST(''...
March 20, 2003 at 4:34 am
Could it be a conversion problem into DateTime? That you are converting VARCHAR data that contains a 'date' (from your Regional settings point of view) which cannot any longer be...
March 20, 2003 at 4:17 am
Remember that the idea behind the set orientated way of SQL is very different from 'normal' programming. Probably you do not need arrays or trees. But if you really do...
March 20, 2003 at 4:07 am
Just a small suggestion, I hope I didn't totally misunderstand the question.
Why can't you create an IDENTITY? It is only for generating an increasing number.
* Start a TRANSACTION,
*...
March 18, 2003 at 2:22 am
You are right. Nothing can be assumed for all time but for MS SQL to change it's implementation of clustered indices into something new would be like a total migration...
March 17, 2003 at 8:08 am
How about this:
1) Turn on identity for that column.
2) Do your inserts (Will start doing IDs' from your MAX INT that currently exists in your column)
3) Turn off identity 🙂
Does...
March 17, 2003 at 7:52 am
Let me clarify a little.
Since a clustered index specifies how SQL server should physically sort a table, use one of those.
For example:
--First create the table
CREATE TABLE MyStuff (
...
March 17, 2003 at 7:40 am
Viewing 15 posts - 511 through 525 (of 529 total)