Looking for suggestions on some good books for Reporting Services that will
get me up to speed on its functionality. A book with a good index, good for
beginners, good reference book; that will hopefully get me up to speed pretty
quickly on utilizing Reporting Services.
Thanks in advance for your help.
wnfisbawnfisba,
I bought Wrox's Prof SQL Server 2005 Reporting Services book a month ago,
and I was disappointed.
I was very disappointed when I tried to learn about the ReportViewer
control. There were only a few pages that dealt with it, and it really didn't
get into the good, stuff.
I wanted to use the control on remote servers, and it didn't explain the
issues on setting the credentials.
I would have re-titled this book - - Beginner SQL Server Report Server, for
it really only touches high level topics regarding the SSRS 2005. However, if
you want a lesson in developing WinForm application, this is your book.
-rwiethorn
"wnfisba" wrote:
> Looking for suggestions on some good books for Reporting Services that will
> get me up to speed on its functionality. A book with a good index, good for
> beginners, good reference book; that will hopefully get me up to speed pretty
> quickly on utilizing Reporting Services.
> Thanks in advance for your help.
> wnfisba|||Don't overlook the usefulness of the "Dummies" books. I've found the "SSRS
for Dummies" book very helpful, especially for context and concept (how the
pieces fit together and why).
elinde
Showing posts with label index. Show all posts
Showing posts with label index. Show all posts
Sunday, March 25, 2012
Bookmarks
Hi,
How I can create an index in a report which are referencing bookmarks in the
report?
I would like to have this format:
[Name / Title of bookmark] [Page Number]
...
[Name / Title of bookmark] [Page Number]
Can I get the page numer with an expression?
ThanksThis is something I asked for in the early days of RS2000,
it was a problem that could only be resolved by using two passes.
Generate the data, save it into a data table adding a row number to
each record. If you know how many rows fit a page you can then generate
the report then construct an index at the end using the row number.
I'm aware this is far from ideal, but I can't think of another way.
The reason it's difficult is that the different rendering methods all
have different ideas about what a page is.
Cheers
Chris
Eric wrote:
> Hi,
> How I can create an index in a report which are referencing bookmarks
> in the report?
> I would like to have this format:
> [Name / Title of bookmark] [Page Number]
> ...
> [Name / Title of bookmark] [Page Number]
>
> Can I get the page numer with an expression?
> Thanks|||Thanks Chris,
But this is not an option because the report isn't based on one dataset or
table, the report format is mixed.
"Chris" wrote:
> This is something I asked for in the early days of RS2000,
> it was a problem that could only be resolved by using two passes.
> Generate the data, save it into a data table adding a row number to
> each record. If you know how many rows fit a page you can then generate
> the report then construct an index at the end using the row number.
> I'm aware this is far from ideal, but I can't think of another way.
> The reason it's difficult is that the different rendering methods all
> have different ideas about what a page is.
> Cheers
> Chris
>
> Eric wrote:
> > Hi,
> >
> > How I can create an index in a report which are referencing bookmarks
> > in the report?
> >
> > I would like to have this format:
> >
> > [Name / Title of bookmark] [Page Number]
> > ...
> > [Name / Title of bookmark] [Page Number]
> >
> >
> > Can I get the page numer with an expression?
> >
> > Thanks
>
> --
>|||Hi Eric,
Based on my research, Chris's suggestion seems to be the only way to do
this. You have to do this with the dataset. Hope you can understand.
You may submit feedback on this via the link below to improve our product.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei
Thanks, but how you want to calculate the pagenumber if you havbe different
tables, freetext, charts, etc.
My questions was also about a custom render item.
Because in the SRSS2005 library you have also a class named 'Bookmark' &
'Bookmarks', where all the bookmarks are stored.
It's there no way to access these classes / properties?
Thanks|||Hi Eric,
Thanks for the update.
I don't think you can use the bookmark directly in a report designer.
You can use the class only in your custom rendering extensions for
Reporting Services.
A rendering extension is a component or module of a report server that
transforms report data and layout information into a device-specific
format. SQL Server Reporting Services includes six rendering extensions:
HTML, Excel, CSV or Text, XML, Image, and PDF. You can create additional
rendering extensions to generate reports in other formats.
The Reporting Services Extension Library is a set of classes, interfaces,
and value types that are included in Reporting Services. This library
provides access to system functionality and is designed to be the
foundation on which Microsoft .NET Framework applications can be used to
extend Reporting Services components.
You may find the information in the Reporting Services Extensions section
in SQL Books online.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for your answer.
I have read the documentation and I'm aware of the rendering extension and
also the custom render item.
>>I don't think you can use the bookmark directly in a report designer.
I was talking about a custom report item, like a rendering extension but one
level deeper.
http://msdn2.microsoft.com/en-us/library/ms345259(SQL.90).aspx
>>You can use the class only in your custom rendering extensions for
Reporting Services.
And for a custom report item? Or can the item not access all bookmarks,
because the report wasn't yet rendered fully?
Thanks
How I can create an index in a report which are referencing bookmarks in the
report?
I would like to have this format:
[Name / Title of bookmark] [Page Number]
...
[Name / Title of bookmark] [Page Number]
Can I get the page numer with an expression?
ThanksThis is something I asked for in the early days of RS2000,
it was a problem that could only be resolved by using two passes.
Generate the data, save it into a data table adding a row number to
each record. If you know how many rows fit a page you can then generate
the report then construct an index at the end using the row number.
I'm aware this is far from ideal, but I can't think of another way.
The reason it's difficult is that the different rendering methods all
have different ideas about what a page is.
Cheers
Chris
Eric wrote:
> Hi,
> How I can create an index in a report which are referencing bookmarks
> in the report?
> I would like to have this format:
> [Name / Title of bookmark] [Page Number]
> ...
> [Name / Title of bookmark] [Page Number]
>
> Can I get the page numer with an expression?
> Thanks|||Thanks Chris,
But this is not an option because the report isn't based on one dataset or
table, the report format is mixed.
"Chris" wrote:
> This is something I asked for in the early days of RS2000,
> it was a problem that could only be resolved by using two passes.
> Generate the data, save it into a data table adding a row number to
> each record. If you know how many rows fit a page you can then generate
> the report then construct an index at the end using the row number.
> I'm aware this is far from ideal, but I can't think of another way.
> The reason it's difficult is that the different rendering methods all
> have different ideas about what a page is.
> Cheers
> Chris
>
> Eric wrote:
> > Hi,
> >
> > How I can create an index in a report which are referencing bookmarks
> > in the report?
> >
> > I would like to have this format:
> >
> > [Name / Title of bookmark] [Page Number]
> > ...
> > [Name / Title of bookmark] [Page Number]
> >
> >
> > Can I get the page numer with an expression?
> >
> > Thanks
>
> --
>|||Hi Eric,
Based on my research, Chris's suggestion seems to be the only way to do
this. You have to do this with the dataset. Hope you can understand.
You may submit feedback on this via the link below to improve our product.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thanks!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei
Thanks, but how you want to calculate the pagenumber if you havbe different
tables, freetext, charts, etc.
My questions was also about a custom render item.
Because in the SRSS2005 library you have also a class named 'Bookmark' &
'Bookmarks', where all the bookmarks are stored.
It's there no way to access these classes / properties?
Thanks|||Hi Eric,
Thanks for the update.
I don't think you can use the bookmark directly in a report designer.
You can use the class only in your custom rendering extensions for
Reporting Services.
A rendering extension is a component or module of a report server that
transforms report data and layout information into a device-specific
format. SQL Server Reporting Services includes six rendering extensions:
HTML, Excel, CSV or Text, XML, Image, and PDF. You can create additional
rendering extensions to generate reports in other formats.
The Reporting Services Extension Library is a set of classes, interfaces,
and value types that are included in Reporting Services. This library
provides access to system functionality and is designed to be the
foundation on which Microsoft .NET Framework applications can be used to
extend Reporting Services components.
You may find the information in the Reporting Services Extensions section
in SQL Books online.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for your answer.
I have read the documentation and I'm aware of the rendering extension and
also the custom render item.
>>I don't think you can use the bookmark directly in a report designer.
I was talking about a custom report item, like a rendering extension but one
level deeper.
http://msdn2.microsoft.com/en-us/library/ms345259(SQL.90).aspx
>>You can use the class only in your custom rendering extensions for
Reporting Services.
And for a custom report item? Or can the item not access all bookmarks,
because the report wasn't yet rendered fully?
Thanks
Thursday, March 22, 2012
Bookmarks
Hi,
How I can create an index in a report which are referencing bookmarks in the
report?
I would like to have this format:
[Name / Title of bookmark] [Page Number]
...
[Name / Title of bookmark] [Page Number]
Can I get the page numer with an expression?
ThanksHi Eric,
Thank you for posting here!
However, I notice you have posted the same question in this newsgroup,
which MVP have already responded. So please check the answer there and if
you need any further assistance on this particular issue, please reply to
me in that thread so I can follow up with you in time. Also, please don't
cross-post the same question in multiple newsgroups in the future so that
our engineers can work on your question efficiently. Your understanding and
cooperation is appreciated.
Thank you and Have a nice day!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
How I can create an index in a report which are referencing bookmarks in the
report?
I would like to have this format:
[Name / Title of bookmark] [Page Number]
...
[Name / Title of bookmark] [Page Number]
Can I get the page numer with an expression?
ThanksHi Eric,
Thank you for posting here!
However, I notice you have posted the same question in this newsgroup,
which MVP have already responded. So please check the answer there and if
you need any further assistance on this particular issue, please reply to
me in that thread so I can follow up with you in time. Also, please don't
cross-post the same question in multiple newsgroups in the future so that
our engineers can work on your question efficiently. Your understanding and
cooperation is appreciated.
Thank you and Have a nice day!
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Bookmark, Explain Plan understanding
When I display my execution plan, a node indicates an Index Seek, the object
listed is the name of the nonclustered indexe used, and the Output list has
[Bmk1002]. Normally in the Output list I see a list of columns when ther
e is
a Bookmark involved, but this is confusing to me cause it is an Index Seek
and the Output list is simply [Bmk1002]. Using "set showplan_all on" sho
ws
the same thing. In this instance do I look at the corresponding Bookmark nod
e
to determine which columns are being sought? Why does it give me a Bookmark
when I am having returned an Index Seek? This is a nasty multi-join query so
I am not including the statement or the tables and indexes. Any possible
explanations would be appreciated.
Message posted via http://www.droptable.comWell, it is because you are trying to get the column/s that do not covered
by index and SQL Server is using nonclusterd index to point to datapage to
return the data
Like
select col1, col30 from table where col1=5
col1 has an index and we will see index seek with bookmark because col30
does not have any index in that case
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:605b4028efd9b@.uwe...
> When I display my execution plan, a node indicates an Index Seek, the
> object
> listed is the name of the nonclustered indexe used, and the Output list
> has
> [Bmk1002]. Normally in the Output list I see a list of columns when th
ere
> is
> a Bookmark involved, but this is confusing to me cause it is an Index Seek
> and the Output list is simply [Bmk1002]. Using "set showplan_all on" s
hows
> the same thing. In this instance do I look at the corresponding Bookmark
> node
> to determine which columns are being sought? Why does it give me a
> Bookmark
> when I am having returned an Index Seek? This is a nasty multi-join query
> so
> I am not including the statement or the tables and indexes. Any possible
> explanations would be appreciated.
> --
> Message posted via http://www.droptable.com
listed is the name of the nonclustered indexe used, and the Output list has
[Bmk1002]. Normally in the Output list I see a list of columns when ther
e is
a Bookmark involved, but this is confusing to me cause it is an Index Seek
and the Output list is simply [Bmk1002]. Using "set showplan_all on" sho
ws
the same thing. In this instance do I look at the corresponding Bookmark nod
e
to determine which columns are being sought? Why does it give me a Bookmark
when I am having returned an Index Seek? This is a nasty multi-join query so
I am not including the statement or the tables and indexes. Any possible
explanations would be appreciated.
Message posted via http://www.droptable.comWell, it is because you are trying to get the column/s that do not covered
by index and SQL Server is using nonclusterd index to point to datapage to
return the data
Like
select col1, col30 from table where col1=5
col1 has an index and we will see index seek with bookmark because col30
does not have any index in that case
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:605b4028efd9b@.uwe...
> When I display my execution plan, a node indicates an Index Seek, the
> object
> listed is the name of the nonclustered indexe used, and the Output list
> has
> [Bmk1002]. Normally in the Output list I see a list of columns when th
ere
> is
> a Bookmark involved, but this is confusing to me cause it is an Index Seek
> and the Output list is simply [Bmk1002]. Using "set showplan_all on" s
hows
> the same thing. In this instance do I look at the corresponding Bookmark
> node
> to determine which columns are being sought? Why does it give me a
> Bookmark
> when I am having returned an Index Seek? This is a nasty multi-join query
> so
> I am not including the statement or the tables and indexes. Any possible
> explanations would be appreciated.
> --
> Message posted via http://www.droptable.com
Bookmark, Explain Plan understanding
When I display my execution plan, a node indicates an Index Seek, the object
listed is the name of the nonclustered indexe used, and the Output list has
[Bmk1002]. Normally in the Output list I see a list of columns when there is
a Bookmark involved, but this is confusing to me cause it is an Index Seek
and the Output list is simply [Bmk1002]. Using "set showplan_all on" shows
the same thing. In this instance do I look at the corresponding Bookmark node
to determine which columns are being sought? Why does it give me a Bookmark
when I am having returned an Index Seek? This is a nasty multi-join query so
I am not including the statement or the tables and indexes. Any possible
explanations would be appreciated.
--
Message posted via http://www.sqlmonster.comWell, it is because you are trying to get the column/s that do not covered
by index and SQL Server is using nonclusterd index to point to datapage to
return the data
Like
select col1, col30 from table where col1=5
col1 has an index and we will see index seek with bookmark because col30
does not have any index in that case
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:605b4028efd9b@.uwe...
> When I display my execution plan, a node indicates an Index Seek, the
> object
> listed is the name of the nonclustered indexe used, and the Output list
> has
> [Bmk1002]. Normally in the Output list I see a list of columns when there
> is
> a Bookmark involved, but this is confusing to me cause it is an Index Seek
> and the Output list is simply [Bmk1002]. Using "set showplan_all on" shows
> the same thing. In this instance do I look at the corresponding Bookmark
> node
> to determine which columns are being sought? Why does it give me a
> Bookmark
> when I am having returned an Index Seek? This is a nasty multi-join query
> so
> I am not including the statement or the tables and indexes. Any possible
> explanations would be appreciated.
> --
> Message posted via http://www.sqlmonster.comsql
listed is the name of the nonclustered indexe used, and the Output list has
[Bmk1002]. Normally in the Output list I see a list of columns when there is
a Bookmark involved, but this is confusing to me cause it is an Index Seek
and the Output list is simply [Bmk1002]. Using "set showplan_all on" shows
the same thing. In this instance do I look at the corresponding Bookmark node
to determine which columns are being sought? Why does it give me a Bookmark
when I am having returned an Index Seek? This is a nasty multi-join query so
I am not including the statement or the tables and indexes. Any possible
explanations would be appreciated.
--
Message posted via http://www.sqlmonster.comWell, it is because you are trying to get the column/s that do not covered
by index and SQL Server is using nonclusterd index to point to datapage to
return the data
Like
select col1, col30 from table where col1=5
col1 has an index and we will see index seek with bookmark because col30
does not have any index in that case
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:605b4028efd9b@.uwe...
> When I display my execution plan, a node indicates an Index Seek, the
> object
> listed is the name of the nonclustered indexe used, and the Output list
> has
> [Bmk1002]. Normally in the Output list I see a list of columns when there
> is
> a Bookmark involved, but this is confusing to me cause it is an Index Seek
> and the Output list is simply [Bmk1002]. Using "set showplan_all on" shows
> the same thing. In this instance do I look at the corresponding Bookmark
> node
> to determine which columns are being sought? Why does it give me a
> Bookmark
> when I am having returned an Index Seek? This is a nasty multi-join query
> so
> I am not including the statement or the tables and indexes. Any possible
> explanations would be appreciated.
> --
> Message posted via http://www.sqlmonster.comsql
Book Recommendations Needed
I am looking for a book that discusses query tuning, index tuning, execution
plans, etc. Can anyone recommend something?
plans, etc. Can anyone recommend something?
--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com"BenignVanilla" <bv@.tibetanbeefgarden.com> wrote in message
news:-Pqdna74lMVGzVKiRVn-tw@.giganews.com...
> I am looking for a book that discusses query tuning, index tuning,
execution
> plans, etc. Can anyone recommend something?
Inside SQL Server 2000 by Kalen Delany
>
> --
> BV.
> WebPorgmaster - www.IHeartMyPond.com
> Work at Home, Save the Environment - www.amothersdream.com
Book Online at MDSN Site
Someone that works with me would like to be able use the search and index
function of Books Online documentation that you get with the desktop version
of SQL Server 2005 Books Online to search and index into the MSDN website
documentation of SQL Server 2005 Books Online. Is there some place on the
web where he can go that provides a search and index function into SQL Server
2005 Books Online documentation, much like you get with the desktop version
of Books Online documentation for SQL Server? He doesn't what me to install
the desktop tools for SQL Server on his workstation for some reason.How about our new search feature we just released on MSDN
http://search.live.com/macros/sql_server_user_education/booksonline? The
link provides a scoped search of Books Online topics.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
> Someone that works with me would like to be able use the search and index
> function of Books Online documentation that you get with the desktop
> version
> of SQL Server 2005 Books Online to search and index into the MSDN website
> documentation of SQL Server 2005 Books Online. Is there some place on the
> web where he can go that provides a search and index function into SQL
> Server
> 2005 Books Online documentation, much like you get with the desktop
> version
> of Books Online documentation for SQL Server? He doesn't what me to
> install
> the desktop tools for SQL Server on his workstation for some reason.|||One more thought. You can download Books Online to the user's desktop
without installing the desktop tools from here: Download the latest version
of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx.
Maybe the user would be okay with that as an alternative.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
news:OMsU8Q6dHHA.4340@.TK2MSFTNGP06.phx.gbl...
> How about our new search feature we just released on MSDN
> http://search.live.com/macros/sql_server_user_education/booksonline? The
> link provides a scoped search of Books Online topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
> news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
>> Someone that works with me would like to be able use the search and index
>> function of Books Online documentation that you get with the desktop
>> version
>> of SQL Server 2005 Books Online to search and index into the MSDN website
>> documentation of SQL Server 2005 Books Online. Is there some place on
>> the
>> web where he can go that provides a search and index function into SQL
>> Server
>> 2005 Books Online documentation, much like you get with the desktop
>> version
>> of Books Online documentation for SQL Server? He doesn't what me to
>> install
>> the desktop tools for SQL Server on his workstation for some reason.
>|||I think this is just what the programmer was asking for. Thank you for the
link.
"Gail Erickson [MS]" wrote:
> How about our new search feature we just released on MSDN
> http://search.live.com/macros/sql_server_user_education/booksonline? The
> link provides a scoped search of Books Online topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
> news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
> > Someone that works with me would like to be able use the search and index
> > function of Books Online documentation that you get with the desktop
> > version
> > of SQL Server 2005 Books Online to search and index into the MSDN website
> > documentation of SQL Server 2005 Books Online. Is there some place on the
> > web where he can go that provides a search and index function into SQL
> > Server
> > 2005 Books Online documentation, much like you get with the desktop
> > version
> > of Books Online documentation for SQL Server? He doesn't what me to
> > install
> > the desktop tools for SQL Server on his workstation for some reason.
>
>
function of Books Online documentation that you get with the desktop version
of SQL Server 2005 Books Online to search and index into the MSDN website
documentation of SQL Server 2005 Books Online. Is there some place on the
web where he can go that provides a search and index function into SQL Server
2005 Books Online documentation, much like you get with the desktop version
of Books Online documentation for SQL Server? He doesn't what me to install
the desktop tools for SQL Server on his workstation for some reason.How about our new search feature we just released on MSDN
http://search.live.com/macros/sql_server_user_education/booksonline? The
link provides a scoped search of Books Online topics.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
> Someone that works with me would like to be able use the search and index
> function of Books Online documentation that you get with the desktop
> version
> of SQL Server 2005 Books Online to search and index into the MSDN website
> documentation of SQL Server 2005 Books Online. Is there some place on the
> web where he can go that provides a search and index function into SQL
> Server
> 2005 Books Online documentation, much like you get with the desktop
> version
> of Books Online documentation for SQL Server? He doesn't what me to
> install
> the desktop tools for SQL Server on his workstation for some reason.|||One more thought. You can download Books Online to the user's desktop
without installing the desktop tools from here: Download the latest version
of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx.
Maybe the user would be okay with that as an alternative.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
news:OMsU8Q6dHHA.4340@.TK2MSFTNGP06.phx.gbl...
> How about our new search feature we just released on MSDN
> http://search.live.com/macros/sql_server_user_education/booksonline? The
> link provides a scoped search of Books Online topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
> news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
>> Someone that works with me would like to be able use the search and index
>> function of Books Online documentation that you get with the desktop
>> version
>> of SQL Server 2005 Books Online to search and index into the MSDN website
>> documentation of SQL Server 2005 Books Online. Is there some place on
>> the
>> web where he can go that provides a search and index function into SQL
>> Server
>> 2005 Books Online documentation, much like you get with the desktop
>> version
>> of Books Online documentation for SQL Server? He doesn't what me to
>> install
>> the desktop tools for SQL Server on his workstation for some reason.
>|||I think this is just what the programmer was asking for. Thank you for the
link.
"Gail Erickson [MS]" wrote:
> How about our new search feature we just released on MSDN
> http://search.live.com/macros/sql_server_user_education/booksonline? The
> link provides a scoped search of Books Online topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> "Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
> news:C5F698E6-7206-421D-8CE8-73E17D737A6A@.microsoft.com...
> > Someone that works with me would like to be able use the search and index
> > function of Books Online documentation that you get with the desktop
> > version
> > of SQL Server 2005 Books Online to search and index into the MSDN website
> > documentation of SQL Server 2005 Books Online. Is there some place on the
> > web where he can go that provides a search and index function into SQL
> > Server
> > 2005 Books Online documentation, much like you get with the desktop
> > version
> > of Books Online documentation for SQL Server? He doesn't what me to
> > install
> > the desktop tools for SQL Server on his workstation for some reason.
>
>
Tuesday, March 20, 2012
BOL May 2007 shows no index and no table of contents
I downloaded and installed SqlServer2K5_BOL_May2007.msi, and it had no index and no table of contents. The shortcut is
"C:\Program Files\Common Files\Microsoft Shared\Help 8\dexplore.exe" /helpcol ms-help://MS.SQLCC.v9 /usehelpsettings SQLServerBooksOnline.9.0 /LaunchFKeywordTopic sql9.portal.f1
"C:\Program Files\Common Files\Microsoft Shared\Help 8\dexplore.exe" /helpcol ms-help://MS.SQLCC.v9 /usehelpsettings SQLServerBooksOnline.9.0 /LaunchFKeywordTopic sql9.portal.f1
there are table of contents files:
Directory of C:\Program Files\Microsoft SQL Server\90\Tools\Books\1033
01/26/2007 11:59 AM 12,949 sql90.hxt
07/27/2006 07:53 AM 271 SQLCC.hxt
11/07/2006 02:16 PM 687 ssm3.hxt
and there are index files too -- the most important one seeming to be :
05/23/2007 12:44 PM 13,630,606 sql90.hxq
I re-executed the .msi and chose repair.
That didn't work to show the index or TC either.
I will try a reboot -- but then I'll have to resintall the previous BOL.
I downloaded and installed it, I was asked about a previous version and choose yes to override it. I am also running Katamai BOL both runs fine. I have no problems, so I think you should delete the download and get a new file for the next install. Hope this helps.|||TOC and index have showed up after a reboot. (Windows XP SP2)
Sunday, March 11, 2012
Blocking while creating index?
If I dont use online indexing, will there be blocking for the entire
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005
See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I thought
> there might be an exclusive lock on the table for the entire duration where
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005
See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I thought
> there might be an exclusive lock on the table for the entire duration where
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
Blocking while creating index?
If I dont use online indexing, will there be blocking for the entire
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I though
t
> there might be an exclusive lock on the table for the entire duration wher
e
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I though
t
> there might be an exclusive lock on the table for the entire duration wher
e
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
Blocking while creating index?
If I dont use online indexing, will there be blocking for the entire
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I thought
> there might be an exclusive lock on the table for the entire duration where
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
duration of the index creation be it clustered or non clustered ? I thought
there might be an exclusive lock on the table for the entire duration where
even selects would be blocked...but it doesnt appear to be true.
Please let me know
Using SQL 2005See BOL, Alter Index, Online OFF
"Table locks are applied for the duration of the index operation. An offline
index operation that creates, rebuilds, or drops a clustered index, or
rebuilds or drops a nonclustered index, acquires a Schema modification
(Sch-M) lock on the table. This prevents all user access to the underlying
table for the duration of the operation. An offline index operation that
creates a nonclustered index acquires a Shared (S) lock on the table. This
prevents updates to the underlying table but allows read operations, such as
SELECT statements."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> If I dont use online indexing, will there be blocking for the entire
> duration of the index creation be it clustered or non clustered ? I thought
> there might be an exclusive lock on the table for the entire duration where
> even selects would be blocked...but it doesnt appear to be true.
> Please let me know
> Using SQL 2005
>
Saturday, February 25, 2012
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,
Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluat...s/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,
Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluat...s/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluation/features/fulltext.asp
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evaluation/features/fulltext.asp
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
BLOB index search
Hi,
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evalua...es/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
I am wondering if I can user SQL server to store Word documents in the BLOB
field and then use Index Server to crawl through those documents (maybe on a
timed basis) to generate a catalog which can be used for web based queries
against. If this can be done then any caveats would also be welcome.
Thanks,Yes. You can do that via SQL Full Text Search:
http://www.microsoft.com/sql/evalua...es/fulltext.asp
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul" <ancientsiam@.yahoo.com> wrote in message
news:ebl2DFEMFHA.3448@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am wondering if I can user SQL server to store Word documents in the
BLOB
> field and then use Index Server to crawl through those documents (maybe on
a
> timed basis) to generate a catalog which can be used for web based queries
> against. If this can be done then any caveats would also be welcome.
> Thanks,
>
Sunday, February 12, 2012
Bizarre Index on Table causing problems
Hello,
One of my sql tables has a bizarre index on it that looks like its name is
?8 (that's some weird small k, 8, and what appears to be a newline
character). The first character appears to be some sort of ascii code for
what I have no idea. The index appeared out of nowhere, and is a clustered,
hypothetical, auto create located on PRIMARY. It does not show in
Enterprise Manager's list of indexes. I believe it is the source of some
major problems on the table, and it cannot be dropped via DROP INDEX --
Cannot drop the index 'tblTable.?8', because it does not exist in the system
catalog.
Does anyone know of a way to remove this index, and where it came from? I
tried creating some sql to try and get around it
declare @.indexname nvarchar(2000)
select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
and indid = 13
select @.indexname
declare @.sql nvarchar(3000)
set @.sql = 'DROP INDEX ' + @.indexname
exec (@.sql)
thinking that perhaps that might do the trick. No dice. If anyone can help
me out here I would really appreciate it. Thanks so much.I had something somewhat similar to this and I had to script a temp table out how I wanted, insert the data from the original to the temp, drop the original, rename the temp.
>--Original Message--
>Hello,
>One of my sql tables has a bizarre index on it that looks like its name is
>?8=04 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname =3D 'tblTable.' + name from sysindexes where id =3D 1110347070
>and indid =3D 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql =3D 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
>
>
>.
>|||To reference names that don't conform to the rules for identifiers, try
enclosing the names in brackets (or double quotes):
DECLARE @.indexname nvarchar(261)
SELECT @.indexname = QUOTENAME(OBJECT_NAME(id)) +
'.' +
QUOTENAME(name)
FROM sysindexes
WHERE id = 1110347070 AND
indid = 13
--
Hope this helps.
Dan Guzman
SQL Server MVP
"tglenist" <tglenist@.hotmail.com> wrote in message
news:OT5jysNwDHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> One of my sql tables has a bizarre index on it that looks like its name is
> ?8 (that's some weird small k, 8, and what appears to be a newline
> character). The first character appears to be some sort of ascii code for
> what I have no idea. The index appeared out of nowhere, and is a
clustered,
> hypothetical, auto create located on PRIMARY. It does not show in
> Enterprise Manager's list of indexes. I believe it is the source of some
> major problems on the table, and it cannot be dropped via DROP INDEX --
> Cannot drop the index 'tblTable.?8', because it does not exist in the
system
> catalog.
> Does anyone know of a way to remove this index, and where it came from? I
> tried creating some sql to try and get around it
> declare @.indexname nvarchar(2000)
> select @.indexname = 'tblTable.' + name from sysindexes where id =1110347070
> and indid = 13
> select @.indexname
> declare @.sql nvarchar(3000)
> set @.sql = 'DROP INDEX ' + @.indexname
> exec (@.sql)
> thinking that perhaps that might do the trick. No dice. If anyone can
help
> me out here I would really appreciate it. Thanks so much.
>
>|||"tglenist" <tglenist@.hotmail.com> wrote:
>One of my sql tables has a bizarre index on it that looks like its name is
>?8 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
>and indid = 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql = 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
This sounds related to a recent thread entitled "Hypothetical indexes",
F8EE1587-3A79-4E3A-85B8-BE0B5B2E3A59@.microsoft.com
It refers to a KB article,
http://support.microsoft.com/support/kb/articles/Q293/1/77.ASP
HTH,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander
One of my sql tables has a bizarre index on it that looks like its name is
?8 (that's some weird small k, 8, and what appears to be a newline
character). The first character appears to be some sort of ascii code for
what I have no idea. The index appeared out of nowhere, and is a clustered,
hypothetical, auto create located on PRIMARY. It does not show in
Enterprise Manager's list of indexes. I believe it is the source of some
major problems on the table, and it cannot be dropped via DROP INDEX --
Cannot drop the index 'tblTable.?8', because it does not exist in the system
catalog.
Does anyone know of a way to remove this index, and where it came from? I
tried creating some sql to try and get around it
declare @.indexname nvarchar(2000)
select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
and indid = 13
select @.indexname
declare @.sql nvarchar(3000)
set @.sql = 'DROP INDEX ' + @.indexname
exec (@.sql)
thinking that perhaps that might do the trick. No dice. If anyone can help
me out here I would really appreciate it. Thanks so much.I had something somewhat similar to this and I had to script a temp table out how I wanted, insert the data from the original to the temp, drop the original, rename the temp.
>--Original Message--
>Hello,
>One of my sql tables has a bizarre index on it that looks like its name is
>?8=04 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname =3D 'tblTable.' + name from sysindexes where id =3D 1110347070
>and indid =3D 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql =3D 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
>
>
>.
>|||To reference names that don't conform to the rules for identifiers, try
enclosing the names in brackets (or double quotes):
DECLARE @.indexname nvarchar(261)
SELECT @.indexname = QUOTENAME(OBJECT_NAME(id)) +
'.' +
QUOTENAME(name)
FROM sysindexes
WHERE id = 1110347070 AND
indid = 13
--
Hope this helps.
Dan Guzman
SQL Server MVP
"tglenist" <tglenist@.hotmail.com> wrote in message
news:OT5jysNwDHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> One of my sql tables has a bizarre index on it that looks like its name is
> ?8 (that's some weird small k, 8, and what appears to be a newline
> character). The first character appears to be some sort of ascii code for
> what I have no idea. The index appeared out of nowhere, and is a
clustered,
> hypothetical, auto create located on PRIMARY. It does not show in
> Enterprise Manager's list of indexes. I believe it is the source of some
> major problems on the table, and it cannot be dropped via DROP INDEX --
> Cannot drop the index 'tblTable.?8', because it does not exist in the
system
> catalog.
> Does anyone know of a way to remove this index, and where it came from? I
> tried creating some sql to try and get around it
> declare @.indexname nvarchar(2000)
> select @.indexname = 'tblTable.' + name from sysindexes where id =1110347070
> and indid = 13
> select @.indexname
> declare @.sql nvarchar(3000)
> set @.sql = 'DROP INDEX ' + @.indexname
> exec (@.sql)
> thinking that perhaps that might do the trick. No dice. If anyone can
help
> me out here I would really appreciate it. Thanks so much.
>
>|||"tglenist" <tglenist@.hotmail.com> wrote:
>One of my sql tables has a bizarre index on it that looks like its name is
>?8 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
>and indid = 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql = 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
This sounds related to a recent thread entitled "Hypothetical indexes",
F8EE1587-3A79-4E3A-85B8-BE0B5B2E3A59@.microsoft.com
It refers to a KB article,
http://support.microsoft.com/support/kb/articles/Q293/1/77.ASP
HTH,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander
Friday, February 10, 2012
Bitmap index in sql server
Hi
I was using bitmap index in Oracle and now moving to SQL Server 2000. Is there any "equivalent" of bitmap index in sql server ? Any help / links ?
Thanks,
SamIf I'm not mistaken a bitmap index also indexes null values. As far as I know, sqlserver does not have special indexes (not) considering specific null values. A regular index will work. Lookup Indexes in Books Online (BOL).
In the analyzer (turn on execution plan):
use monkey
go
set nocount on
create table tab1 (myint integer null, myval integer not null)
go
create index idx_tab1_myint on tab1 (myint)
go
insert into tab1 (myint, myval) values (1,1)
insert into tab1 (myint, myval) values (null,2)
go
select myint from tab1
go
drop table tab1
go|||A bitmap index is an index that can be used on columns with little different values in it (eg sexe: values male, female and unknown/null), for example in Oracle. This type of index is not available in SQL Server.
If I'm not mistaken a bitmap index also indexes null values.
In SQL Server you can also create indexes that allow null values
I was using bitmap index in Oracle and now moving to SQL Server 2000. Is there any "equivalent" of bitmap index in sql server ? Any help / links ?
Thanks,
SamIf I'm not mistaken a bitmap index also indexes null values. As far as I know, sqlserver does not have special indexes (not) considering specific null values. A regular index will work. Lookup Indexes in Books Online (BOL).
In the analyzer (turn on execution plan):
use monkey
go
set nocount on
create table tab1 (myint integer null, myval integer not null)
go
create index idx_tab1_myint on tab1 (myint)
go
insert into tab1 (myint, myval) values (1,1)
insert into tab1 (myint, myval) values (null,2)
go
select myint from tab1
go
drop table tab1
go|||A bitmap index is an index that can be used on columns with little different values in it (eg sexe: values male, female and unknown/null), for example in Oracle. This type of index is not available in SQL Server.
If I'm not mistaken a bitmap index also indexes null values.
In SQL Server you can also create indexes that allow null values
Bit field index
I have a table with 5 bit fields on the end. Do you can any performace by
indxing a bit field, even though its not used in any caculations or where
clauses?
--
JP
.NET Software DeveloperWhy do you think an index would be useful?
"JP" <JP@.discussions.microsoft.com> wrote in message
news:456DE2B8-EFAD-42FE-8FA8-0C4CB336BDF5@.microsoft.com...
>I have a table with 5 bit fields on the end. Do you can any performace by
> indxing a bit field, even though its not used in any caculations or where
> clauses?
> --
> JP
> .NET Software Developer|||Well I miss typed my message. The bit fild is used in the where of a delete
statement but was thinking since its either 0 or 1 I would think a index o
n
a bit wouldnt do any good in terms of SP performace. Since Im dealing with
over 40 million records, I wanted to make sure though as I dont want to make
changes to this table unless I have to.
--
JP
.NET Software Developer
"Aaron Bertrand [SQL Server MVP]" wrote:
> Why do you think an index would be useful?
>
> "JP" <JP@.discussions.microsoft.com> wrote in message
> news:456DE2B8-EFAD-42FE-8FA8-0C4CB336BDF5@.microsoft.com...
>
>|||> Well I miss typed my message. The bit fild is used in the where of a
> delete
> statement but was thinking since its either 0 or 1 I would think a index
> on
> a bit wouldnt do any good in terms of SP performace.
You're right. Unless your table is 99% one value or the other, it is very
unlikely to use the index.
http://www.aspfaq.com/2530
A|||In fact query optimizer might decide on doing a table scan anyway.
ML
http://milambda.blogspot.com/|||JP (JP@.discussions.microsoft.com) writes:
> I have a table with 5 bit fields on the end. Do you can any performace by
> indxing a bit field, even though its not used in any caculations or where
> clauses?
Indexing bit columns is meaningful if you have a column like isprocessed,
and only new rows has this value. For bit columns with 50/50 split, an
index is only useful if you need to do:
SELECT bitcol, COUNT(*) FROM tbl GROUP BY bitcol
There is a gotcha with bit columns. Say that you have an index on
isprocessed:
SELECT ... FROM tbl WHERE isprocessed = 0
This query will use the index (assuming that only a few rows has this
value), but it will scan the index, not s
it. This is because 0 is
integer, and integer is higher in SQL Server data-type precedence. This
query will be perform a s and be real fast:
SELECT ... FROM tbl WHERE isprocessed = convert(bit, 0)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
indxing a bit field, even though its not used in any caculations or where
clauses?
--
JP
.NET Software DeveloperWhy do you think an index would be useful?
"JP" <JP@.discussions.microsoft.com> wrote in message
news:456DE2B8-EFAD-42FE-8FA8-0C4CB336BDF5@.microsoft.com...
>I have a table with 5 bit fields on the end. Do you can any performace by
> indxing a bit field, even though its not used in any caculations or where
> clauses?
> --
> JP
> .NET Software Developer|||Well I miss typed my message. The bit fild is used in the where of a delete
statement but was thinking since its either 0 or 1 I would think a index o
n
a bit wouldnt do any good in terms of SP performace. Since Im dealing with
over 40 million records, I wanted to make sure though as I dont want to make
changes to this table unless I have to.
--
JP
.NET Software Developer
"Aaron Bertrand [SQL Server MVP]" wrote:
> Why do you think an index would be useful?
>
> "JP" <JP@.discussions.microsoft.com> wrote in message
> news:456DE2B8-EFAD-42FE-8FA8-0C4CB336BDF5@.microsoft.com...
>
>|||> Well I miss typed my message. The bit fild is used in the where of a
> delete
> statement but was thinking since its either 0 or 1 I would think a index
> on
> a bit wouldnt do any good in terms of SP performace.
You're right. Unless your table is 99% one value or the other, it is very
unlikely to use the index.
http://www.aspfaq.com/2530
A|||In fact query optimizer might decide on doing a table scan anyway.
ML
http://milambda.blogspot.com/|||JP (JP@.discussions.microsoft.com) writes:
> I have a table with 5 bit fields on the end. Do you can any performace by
> indxing a bit field, even though its not used in any caculations or where
> clauses?
Indexing bit columns is meaningful if you have a column like isprocessed,
and only new rows has this value. For bit columns with 50/50 split, an
index is only useful if you need to do:
SELECT bitcol, COUNT(*) FROM tbl GROUP BY bitcol
There is a gotcha with bit columns. Say that you have an index on
isprocessed:
SELECT ... FROM tbl WHERE isprocessed = 0
This query will use the index (assuming that only a few rows has this
value), but it will scan the index, not s
it. This is because 0 isinteger, and integer is higher in SQL Server data-type precedence. This
query will be perform a s
and be real fast:SELECT ... FROM tbl WHERE isprocessed = convert(bit, 0)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Subscribe to:
Posts (Atom)