May I create not unique clustered index?

Hi,
When create clustered index, the column must be unique? Or
I can do Create Clustered index index_name ON table
(column_name)?
Any input much appreciate!
JennyThere is nothing that stops you from having a clustered index on a
non-unique column. By having your clustered index on a unique column we get
a narrowed selectivity when quering on that column ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Jenny" <jyu@.iseoptions.com> wrote in message
news:0cfc01c3a473$01686900$a301280a@.phx.gbl...
> Hi,
> When create clustered index, the column must be unique? Or
> I can do Create Clustered index index_name ON table
> (column_name)?
> Any input much appreciate!
> Jenny|||The column does not need to be unique.
"Jenny" <jyu@.iseoptions.com> wrote in message
news:0cfc01c3a473$01686900$a301280a@.phx.gbl...
> Hi,
> When create clustered index, the column must be unique? Or
> I can do Create Clustered index index_name ON table
> (column_name)?
> Any input much appreciate!
> Jenny|||no, they do not need to be unique
CREATE CLUSTERED INDEX IXNAME ON TABLENAME(COLUMNLIST)
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Jenny" <jyu@.iseoptions.com> wrote in message
news:0cfc01c3a473$01686900$a301280a@.phx.gbl...
> Hi,
> When create clustered index, the column must be unique? Or
> I can do Create Clustered index index_name ON table
> (column_name)?
> Any input much appreciate!
> Jenny

Maximum Number of Input Parameters

We created a report with 42 parameters in it. While in VS, it
previewed fine. Then in our preferred browser Firefox, it rendered
fine as well. Only after we had to test different platforms did we
realize that it did not work in IE 6 or 7, using our interface, or
even the MS Report web interface. This seemed really odd as we are
able to run this report through Firefox.
We then created a test report with nothing in it and just started
adding parameters to it, uploading it, and used the MS Report web
interface to view it. At 36 parameters, it stopped working...
We removed shortened up the length of the names of the parameters to
see if it was a GET/POST issue, but the same limit happened.
Anyone else with this issue? Any suggestions?On Mar 1, 12:12 pm, "dmcnamer" <dmcna...@.gmail.com> wrote:
> We created a report with 42 parameters in it. While in VS, it
> previewed fine. Then in our preferred browser Firefox, it rendered
> fine as well. Only after we had to test different platforms did we
> realize that it did not work in IE 6 or 7, using our interface, or
> even the MS Report web interface. This seemed really odd as we are
> able to run this report through Firefox.
> We then created a test report with nothing in it and just started
> adding parameters to it, uploading it, and used the MS Report web
> interface to view it. At 36 parameters, it stopped working...
> We removed shortened up the length of the names of the parameters to
> see if it was a GET/POST issue, but the same limit happened.
> Anyone else with this issue? Any suggestions?
I've never used this many parameters; however, it sounds like it is
related to a limitation in IE 6/7 page rendering. Is there not a way
that this report can be split up into more than one report?
Enrique Martinez
Sr. SQL Server Developer|||On Mar 1, 10:05 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 1, 12:12 pm, "dmcnamer" <dmcna...@.gmail.com> wrote:
> > We created a report with 42 parameters in it. While in VS, it
> > previewed fine. Then in our preferred browser Firefox, it rendered
> > fine as well. Only after we had to test different platforms did we
> > realize that it did not work in IE 6 or 7, using our interface, or
> > even the MS Report web interface. This seemed really odd as we are
> > able to run this report through Firefox.
> > We then created a test report with nothing in it and just started
> > adding parameters to it, uploading it, and used the MS Report web
> > interface to view it. At 36 parameters, it stopped working...
> > We removed shortened up the length of the names of the parameters to
> > see if it was a GET/POST issue, but the same limit happened.
> > Anyone else with this issue? Any suggestions?
> I've never used this many parameters; however, it sounds like it is
> related to a limitation in IE 6/7 page rendering. Is there not a way
> that this report can be split up into more than one report?
> Enrique Martinez
> Sr. SQL Server Developer
we are not able to split up the report, as it is a summary report
which requires all of the input parameters. we contacted MS tech
support and, for some reason, they were able to get this to work.
however, we gave them access to our machines and it did not work for
them. they spent a while trying to figure it out with IE and SQL RS
people on the line and were not able to figure out which setting
combination made this not work. our guy got tired from staying on the
line. instead, we created a bit string to represent all of the binary
options get around this limitation and then parse the bit string in
the report.

Maximum INput that a BCP utility can take

Can any one help me out form this... I just want to know the maximum input a bcp utility can take.... its a direct insert from one table to another but contains millions of data
...How many millions? The last largest bulk insert I've done (it's running daily, and no, I don't do TRUNCATE TABLE before it ;)) varied between 800 million and 1.6 billion. The width was around 4K characters, and the job execution varied between 3 and 5 hours. I suspect you'll run into OS limitations before you start having problems with bulk load.

max width for input fixed width column

Is there a maximum width for fixed width column?

I'm trying to read in a flat file (which, admittedly, has one very wide column), and it keeps breaking because of truncation when it tries to read in the file.

Any ideas?

Jim Work
What is the error exactly?|||Error: 0xC02020A1 at Data Flow Task, Flat File Source [1]: Data conversion failed. The data conversion for column "Column 1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

Error: 0xC020902A at Data Flow Task, Flat File Source [1]: The "output column "Column 1" (157)" failed because truncation occurred, and the truncation row disposition on "output column "Column 1" (157)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Error: 0xC0202092 at Data Flow Task, Flat File Source [1]: An error occurred while processing file "C:\data\sampleDepositFile1.txt" on data row 1.

Does that help?

|||Yes, it does.

Sounds to me like there are characters in the data that don't have a match in the codepage you are working with. Could be a non-unicode/unicode issue. Are there NULLs in the data? NULLs truncate strings as well.

What codepage are you using? 1252? What kind of data do you have in the file?|||1252 (ANSI - Latin I )

This is what the connection manager defaulted to, and I believe it matches up with my source data. Should I change it to (and go back and save the source data as) UTF-8?

Thanks for any insight you can give me!
|||How big is your column in the source file, and what have you defined in the flat file source? Pull it up in the advanced editor and ensure that the columns are the correct size there.