nvarchar = unicode?

Dear all,
I would like to ask the question as the tile. will all data store in
nvarchar type be converted to unicode? Thank you for all of your help.
Alex Yung
Hi Alex,
Thanks for your post.
I think the answer from Peter was short but rather solid. I just wanted to
post a quick note to see if you would like additional assistance or
information regarding this particular issue. We appreciate your patience
and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

nvarchar = unicode?

Dear all,
I would like to ask the question as the tile. will all data store in
nvarchar type be converted to unicode? Thank you for all of your help.
Alex YungHi Alex,
Thanks for your post.
I think the answer from Peter was short but rather solid. I just wanted to
post a quick note to see if you would like additional assistance or
information regarding this particular issue. We appreciate your patience
and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

nvarchar = unicode?

Dear all,
I would like to ask the question as the tile. will all data store in
nvarchar type be converted to unicode? Thank you for all of your help.
Alex YungYes
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_na-nop_9msy.asp
Peter
"Information is the oxygen of the modern age. It seeps
through the walls topped by barbed wire, it wafts across
the electrified borders.""
Ronald Reagan
>--Original Message--
>Dear all,
> I would like to ask the question as the tile. will all
data store in
>nvarchar type be converted to unicode? Thank you for all
of your help.
>Alex Yung
>
>.
>|||Hi Alex,
Thanks for your post.
I think the answer from Peter was short but rather solid. I just wanted to
post a quick note to see if you would like additional assistance or
information regarding this particular issue. We appreciate your patience
and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Numbers problems in PDF

Dear All,

i am developing an application in arabic languge we had use the reporting service as our report engine we export the report to PDF format for printing or display

i have a problem with the numbers: when export to PDF the numbers not take the localization language i mean it always displayed in arabic number in need to be display in indean numbers

can u hlep me

hope my problem is clear.

Bolos

Hi,
you can check if your problem is resolved with SP2 :
http://support.microsoft.com/?kbid=889640

Number of transactions

Dear all,
Which is the faster and reliable way to obtain how many transactions has
been commited in a day in all the Sql Server db? Is there any system stored
procedure which get that information?
Thanks for your advices/comments/thoughts,
Regards,
EnricI don't believe you can track committed transactions.
There's no perfmon counter or SQL profiler event I can think of that
would do the trick. There's also no proc I know of to do so. As far as
I am aware, the only transactions that are of any interest, in terms of
tracking, are open (or active) transactions, which you can see with
"SELECT @.@.TRANCOUNT", but that won't tell you how many transactions have
been committed over a certain period of time, just how many are
currently open.
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Enric wrote:

>Dear all,
>Which is the faster and reliable way to obtain how many transactions has
>been commited in a day in all the Sql Server db? Is there any system stored
>procedure which get that information?
>Thanks for your advices/comments/thoughts,
>Regards,
>Enric
>
>|||Partial solution
you can see BOL for global vaiables like
@.@.connections,@.@.transcount,@.2packets_sen
t but all these give you no of
transactions since last start. you may use average of it per day.
r.d
"Enric" wrote:

> Dear all,
> Which is the faster and reliable way to obtain how many transactions has
> been commited in a day in all the Sql Server db? Is there any system store
d
> procedure which get that information?
> Thanks for your advices/comments/thoughts,
> Regards,
> Enric
>|||@.@.total_read and @.@.total_write since last start also will help you
"Mike Hodgson" wrote:

> I don't believe you can track committed transactions.
> There's no perfmon counter or SQL profiler event I can think of that
> would do the trick. There's also no proc I know of to do so. As far as
> I am aware, the only transactions that are of any interest, in terms of
> tracking, are open (or active) transactions, which you can see with
> "SELECT @.@.TRANCOUNT", but that won't tell you how many transactions have
> been committed over a certain period of time, just how many are
> currently open.
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Enric wrote:
>
>|||@.@.connections has got nothing to do with transactions, it's the number
of connections (successful logins) since the last restart.
@.@.transcount is only the number of currently open transactions.
@.@.packets_sent has got nothing to do with transactions, it's the number
of packets sent out the server's NIC since the last restart.
There are some very informative global vars you can access (along with
the wealth of information available through perfmon counters & SQL
profiler traces) but none of that will tell you the number of
transactions (committed or otherwise) for a given time period.
The only place I can think of that this info is recorded is in the
transaction log. If you were to read the transaction log with
::fn_dblogs or some 3rd party app (like Lumigent Log Explorer) you could
probably tell. Something like this:
-- Number of BEGIN TRAN & COMMIT TRAN since last log truncation
select Operation, count(*) from ::fn_dblog(null,null)
where Operation in ('LOP_BEGIN_XACT', 'LOP_COMMIT_XACT')
group by Operation
-- Number of BEGIN TRAN & COMMIT TRAN today (assuming the log hasn't
been truncated today)
select Operation, count(*) from ::fn_dblog(null,null)
where (Operation = 'LOP_BEGIN_XACT' and convert(datetime,[Begin
Time]) > convert(datetime,convert(varchar(8),getd
ate(),112)))
or (Operation = 'LOP_COMMIT_XACT' and convert(datetime,[End
Time]) > convert(datetime,convert(varchar(8),getd
ate(),112)))
group by Operation
*mike hodgson*
blog: http://sqlnerd.blogspot.com
R.D wrote:
>Partial solution
>you can see BOL for global vaiables like
> @.@.connections,@.@.transcount,@.2packets_sen
t but all these give you no of
>transactions since last start. you may use average of it per day.
>r.d
>"Enric" wrote:
>
>|||No they won't. Those global vars have nothing to do with transactions.
@.@.TOTAL_READ
(http://msdn.microsoft.com/library/d.../>
ls_484k.asp)
@.@.TOTAL_WRITE
(http://msdn.microsoft.com/library/d.../>
ls_26p1.asp)
*mike hodgson*
blog: http://sqlnerd.blogspot.com
R.D wrote:
>@.@.total_read and @.@.total_write since last start also will help you
>"Mike Hodgson" wrote:
>
>|||Thanks so much for that,
"Mike Hodgson" wrote:

> No they won't. Those global vars have nothing to do with transactions.
> @.@.TOTAL_READ
> (http://msdn.microsoft.com/library/d...
bals_484k.asp)
> @.@.TOTAL_WRITE
> (http://msdn.microsoft.com/library/d...
bals_26p1.asp)
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> R.D wrote:
>
>|||In any case, it would be gorgeous have available any job or sp be able to
show info such as this:
user1 select 12 2 10
user1 delete 3 1 2
user2 update 1
I've found this:
DBCC INPUTBUFFER (spid)
Language Event 0 select * from VconexionesNAO where referencia='ACTUA' and
optapl='0'
Doing a loop with that info and then sorting it.
Returning the sentence
"Mike Hodgson" wrote:

> No they won't. Those global vars have nothing to do with transactions.
> @.@.TOTAL_READ
> (http://msdn.microsoft.com/library/d...
bals_484k.asp)
> @.@.TOTAL_WRITE
> (http://msdn.microsoft.com/library/d...
bals_26p1.asp)
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> R.D wrote:
>
>|||sp_monitor reveals several server metrics, but not total transactions.
Also, if you can identify a suitable SQL Profiler event (perhaps
RPC:Completed,SQL:BatchCompleted), then you can have the event log output to
a table for periodic querying.
http://vyaskn.tripod.com/analyzing_profiler_output.htm
http://www.informit.com/guides/cont...&seqNum=41&rl=1
http://www.microsoft.com/technet/pr...ps/sqlprof.mspx
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:58B2337B-7A9E-4945-89BB-B95F1431584B@.microsoft.com...
> Dear all,
> Which is the faster and reliable way to obtain how many transactions has
> been commited in a day in all the Sql Server db? Is there any system
> stored
> procedure which get that information?
> Thanks for your advices/comments/thoughts,
> Regards,
> Enric
>

Number of statements during a specific time

Dear fellows,
I'd like to see how many queries are launched in a hour in a live server. In
order to achieve such information I've though in to open profiler applicatio
n
and then save that information on a .TRC file (encompassing two hours for
example). After that, by DTS export that file to a table and to retrieve the
number of SELECT commited with the help of specific strings (Textdata and
loginname). That will mean know the number of queries launched for our
developers from its QA sessions as well as queries and another things for an
y
kind of processes (If I am not wrong)
It take part of a set of measures intended to demonstrate that we'd need
news hardware requirements, hd, and so on.
Any help/though/advice of how do this better? In aid of faster or reliabilit
y.
Thanks a lot for your input,It is not a good solution due to I've got now 140mb of tracefile for just a
hour!!
Let me know any idea...
"Enric" wrote:

> Dear fellows,
> I'd like to see how many queries are launched in a hour in a live server.
In
> order to achieve such information I've though in to open profiler applicat
ion
> and then save that information on a .TRC file (encompassing two hours for
> example). After that, by DTS export that file to a table and to retrieve t
he
> number of SELECT commited with the help of specific strings (Textdata and
> loginname). That will mean know the number of queries launched for our
> developers from its QA sessions as well as queries and another things for
any
> kind of processes (If I am not wrong)
> It take part of a set of measures intended to demonstrate that we'd need
> news hardware requirements, hd, and so on.
> Any help/though/advice of how do this better? In aid of faster or reliabil
ity.
> Thanks a lot for your input,|||try use performans counters - perfmon (sqlserver:sqlserverstatistics)
but... is is not idealy metod to demonstrate that you need new hardware...
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Enric" wrote:

> Dear fellows,
> I'd like to see how many queries are launched in a hour in a live server.
In
> order to achieve such information I've though in to open profiler applicat
ion
> and then save that information on a .TRC file (encompassing two hours for
> example). After that, by DTS export that file to a table and to retrieve t
he
> number of SELECT commited with the help of specific strings (Textdata and
> loginname). That will mean know the number of queries launched for our
> developers from its QA sessions as well as queries and another things for
any
> kind of processes (If I am not wrong)
> It take part of a set of measures intended to demonstrate that we'd need
> news hardware requirements, hd, and so on.
> Any help/though/advice of how do this better? In aid of faster or reliabil
ity.
> Thanks a lot for your input,

Number of documents vs rank in FTS

Dear all,
I am interested in using FTS for scientific investigation.
Specifically, I need to know exactly how often certain keywords occur
in documents in my collection. I know how many documents contain the
keyword, but how do I find out how often the keyword occurs in these
documents? I know the ranking formula used the inverse document
frequency to penalize the number of occurrences for keywords common in
my document collection and also penalizes longer documents, so I cannot
just use the rank as given by sql server. However, I am sure that the
FT index somehow contains the frequency with which each word occurs in
each document since it needs that to calculate the rank in the first
place. Is there any way I can get this information?
[As an example, I would like to know how often the terms 'bush NEAR
president', 'kerry NEAR senator', and 'terrorism' occur in my
collection of NYTimes articles so I can calculate co-occurrence scores]
Thanks in advance,
Wouter van Atteveldt
Free University Amsterdam
You are looking for the hit count property. This feature is available in
other Microsoft Search products but not in SQL FTS. You can use an inverted
file index to get this value. Search the web for implementations of this in
tsql.
Here is one -
http://www.n3labs.com/pdf/putz91usin...rted-DBMS.html
The ranking formula actually "penalizes" the contribution to words or tokens
which you are searching on which occur frequently or rarely in your entire
document collection or the frequency that words occur compared to the entire
count of words indexed. Words which slightly more than avereage - as defined
by Zipf's law, have greater "resolving" power and are ranked higher.
The formula also normalizes for length - so its sort of like an occurence
density. So if you have a large document with the word occuring twice in a
10,000 word document, this document will be ranked lower than a 1,000 word
document where the word occurs twice.
"wouter" <wouter@.2at.nl> wrote in message
news:1108296276.416611.195050@.z14g2000cwz.googlegr oups.com...
> Dear all,
> I am interested in using FTS for scientific investigation.
> Specifically, I need to know exactly how often certain keywords occur
> in documents in my collection. I know how many documents contain the
> keyword, but how do I find out how often the keyword occurs in these
> documents? I know the ranking formula used the inverse document
> frequency to penalize the number of occurrences for keywords common in
> my document collection and also penalizes longer documents, so I cannot
> just use the rank as given by sql server. However, I am sure that the
> FT index somehow contains the frequency with which each word occurs in
> each document since it needs that to calculate the rank in the first
> place. Is there any way I can get this information?
> [As an example, I would like to know how often the terms 'bush NEAR
> president', 'kerry NEAR senator', and 'terrorism' occur in my
> collection of NYTimes articles so I can calculate co-occurrence scores]
> Thanks in advance,
> Wouter van Atteveldt
> Free University Amsterdam
>
|||Dear Hilary,
Thanks for your answer. The article on using the BTree index to build
my own index is very interesting and very tempting. However, my
intuition tells me that I must be reinventing the wheel if I start
writing procedures to build, update, and query such an index and
especially if I start writing procedures to query the index using
boolean phrases or proximity terms. I think it would be very
interesting and insightful to write myself but it I'm sure other people
have written it already and probably more efficiently...
So my question is: If it is true that I can't retrieve the inverse
document frequency of a boolean query in SQL server*, can anyone advise
me on a good alternative? Is there a Document Retrieval engine that
communicates well with databases? Does anyone think I should try using
the API on the search engine directly either from a stand-alone program
or from a SQL Server function (esp. with 2005 supporting .NET code) ?
Any help appreciated!
Wouter
* which would be a shame since it is obvious that SQL server or at
least the search service 'knows' this number and the rest of my program
is built around an SQL server database anyway. O well, who said life is
easy anyway :-)
Hilary Cotter wrote:
> You are looking for the hit count property. This feature is available
in
> other Microsoft Search products but not in SQL FTS. You can use an
inverted
> file index to get this value. Search the web for implementations of
this in
> tsql.
> Here is one -
> http://www.n3labs.com/pdf/putz91usin...rted-DBMS.html
> The ranking formula actually "penalizes" the contribution to words or
tokens
> which you are searching on which occur frequently or rarely in your
entire
> document collection or the frequency that words occur compared to the
entire
> count of words indexed. Words which slightly more than avereage - as
defined
> by Zipf's law, have greater "resolving" power and are ranked higher.
> The formula also normalizes for length - so its sort of like an
occurence
> density. So if you have a large document with the word occuring twice
in a
> 10,000 word document, this document will be ranked lower than a 1,000
word[vbcol=seagreen]
> document where the word occurs twice.
> "wouter" <wouter@.2at.nl> wrote in message
> news:1108296276.416611.195050@.z14g2000cwz.googlegr oups.com...
occur[vbcol=seagreen]
the[vbcol=seagreen]
these[vbcol=seagreen]
in[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
in[vbcol=seagreen]
first[vbcol=seagreen]
scores][vbcol=seagreen]
|||Hit Count - the property you are looking for ships with other Microsoft
Search products. It may ship with future versions of SQL Server - currently
in 2005, this property is not exposed.
Other search engine vendors that interact with SQL Server (SQL Turbo,
DTSearch) might.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"wouter" <wouter@.2at.nl> wrote in message
news:1108398341.423014.22460@.o13g2000cwo.googlegro ups.com...
> Dear Hilary,
> Thanks for your answer. The article on using the BTree index to build
> my own index is very interesting and very tempting. However, my
> intuition tells me that I must be reinventing the wheel if I start
> writing procedures to build, update, and query such an index and
> especially if I start writing procedures to query the index using
> boolean phrases or proximity terms. I think it would be very
> interesting and insightful to write myself but it I'm sure other people
> have written it already and probably more efficiently...
> So my question is: If it is true that I can't retrieve the inverse
> document frequency of a boolean query in SQL server*, can anyone advise
> me on a good alternative? Is there a Document Retrieval engine that
> communicates well with databases? Does anyone think I should try using
> the API on the search engine directly either from a stand-alone program
> or from a SQL Server function (esp. with 2005 supporting .NET code) ?
> Any help appreciated!
> Wouter
>
> * which would be a shame since it is obvious that SQL server or at
> least the search service 'knows' this number and the rest of my program
> is built around an SQL server database anyway. O well, who said life is
> easy anyway :-)
>
> Hilary Cotter wrote:
> in
> inverted
> this in
> tokens
> entire
> entire
> defined
> occurence
> in a
> word
> occur
> the
> these
> in
> cannot
> the
> in
> first
> scores]
>

Null values in cascading parameters

dear All,

I want to make a Report with attractive selection parameters.
That I mean, there is a parameter, Tparam (Time Param) which will activate other parameters (3 parameters: TimeA_1, TimeA_2 & TimeA_3. These selection values have been registered in the "Aviable values => non-queried".)

when Tparam selected TimeA_1 then Parameter for TimeA_1 will activated (and the others will be disappeared/hidden), vice versa for the other control (TimeA_2 & TimeA_3)

any idea to do that?

thank you...What you want is available, they are called Cascading Parameters, there is a tutorial here
http://msdn2.microsoft.com/en-us/library/aa337426.aspx|||

Hi SNMSDN,

In the link ,you sent i can't find any source regarding hiding or ignoring one parameter using another parameter.

Even i have another problem in setting null values . I have 5 cascading parameters ,level1,level2,level3,level4 and level5

when level1 is compulsory ,i had the remaining 4 parameters to accept for null and are made optional

for this i tried with "Allow null value option" in Report parameters but its not accepting

as an alternative i tried with default value 'Query based' to return null.

None of them directs me towards accepting null

It is aksing to select the parameter

It will be really a great help if some body faced some problem like this and resolved it

Thanks in advance

Raj Deep.A

|||

I have the same problem.

Basically, it appears that if you reference a parameter directly or indirectly via any other parameter's DS, then it will not respect the "Allow Null" setting for that parameter, since it thinks that it is implicitly required.

For example, I have a report with State & County parameters that both need to be set to enable "Allow Null". The County parameter references the State parameter's value within its Dataset, but no other parameter references the County parameter.

As a result, the County parameter respects the "Allow Null" setting, but the "State" parameter does not.

There MUST be a way around this restriction!!!

I have tried to hack around it by creating a dummy parameter called "StateFilter" that uses an expression to either return the Parameter!State.Value or Null, and then the County dataset references this parameter instead of the actual "State" parameter. However, this doesnt work either. Sql RS is "smart" enough to see the indirect reference and continues to treat State as a required parameter.

Help!!!

~Lance

|||

Nevermind.

I had forgotten about this wrinkle in how report parameters worked, but just now realized that you have to provide an option that has a value of NULL in order to select the "Allow Null" option. Makes sense when you think of it, but it would be nice if RS injected the NULL value option in such cases.

See this posting for the details:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1067464&SiteID=17

Null values in cascading parameters

dear All,

I want to make a Report with attractive selection parameters.
That I mean, there is a parameter, Tparam (Time Param) which will activate other parameters (3 parameters: TimeA_1, TimeA_2 & TimeA_3. These selection values have been registered in the "Aviable values => non-queried".)

when Tparam selected TimeA_1 then Parameter for TimeA_1 will activated (and the others will be disappeared/hidden), vice versa for the other control (TimeA_2 & TimeA_3)

any idea to do that?

thank you...What you want is available, they are called Cascading Parameters, there is a tutorial here
http://msdn2.microsoft.com/en-us/library/aa337426.aspx|||

Hi SNMSDN,

In the link ,you sent i can't find any source regarding hiding or ignoring one parameter using another parameter.

Even i have another problem in setting null values . I have 5 cascading parameters ,level1,level2,level3,level4 and level5

when level1 is compulsory ,i had the remaining 4 parameters to accept for null and are made optional

for this i tried with "Allow null value option" in Report parameters but its not accepting

as an alternative i tried with default value 'Query based' to return null.

None of them directs me towards accepting null

It is aksing to select the parameter

It will be really a great help if some body faced some problem like this and resolved it

Thanks in advance

Raj Deep.A

|||

I have the same problem.

Basically, it appears that if you reference a parameter directly or indirectly via any other parameter's DS, then it will not respect the "Allow Null" setting for that parameter, since it thinks that it is implicitly required.

For example, I have a report with State & County parameters that both need to be set to enable "Allow Null". The County parameter references the State parameter's value within its Dataset, but no other parameter references the County parameter.

As a result, the County parameter respects the "Allow Null" setting, but the "State" parameter does not.

There MUST be a way around this restriction!!!

I have tried to hack around it by creating a dummy parameter called "StateFilter" that uses an expression to either return the Parameter!State.Value or Null, and then the County dataset references this parameter instead of the actual "State" parameter. However, this doesnt work either. Sql RS is "smart" enough to see the indirect reference and continues to treat State as a required parameter.

Help!!!

~Lance

|||

Nevermind.

I had forgotten about this wrinkle in how report parameters worked, but just now realized that you have to provide an option that has a value of NULL in order to select the "Allow Null" option. Makes sense when you think of it, but it would be nice if RS injected the NULL value option in such cases.

See this posting for the details:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1067464&SiteID=17