Production DBs are going to suspect mode automatically

Dear All,
In our server,Our Production DBs are going to suspect mode automatically.
Any body help us for this issues.
Regards,
R.SathiamoorthyHi
http://www.karaszi.com/sqlserver/in..._suspect_db.asp
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>|||Hello,
Can you check:-
1. Do u have enough hard disk space in data and log drices?
2. Does this happen after the SQL Server service restart, in this case the
MDF or LDF will be used by anti virus software or some backup jobs. Due
to this file willl not be available for recovery and will be marked suspect.
Verify both the above steps.
THnaks
Hari
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>|||The first think you should do is look at the SQL Server error log. The log
should be an indication of why SQL Server marked the database suspect.
Hope this helps.
Dan Guzman
SQL Server MVP
"Sathiamoorthy" <someone@.microsoft.com> wrote in message
news:%23kcjEUmgHHA.392@.TK2MSFTNGP06.phx.gbl...
> Dear All,
> In our server,Our Production DBs are going to suspect mode automatically.
> Any body help us for this issues.
> Regards,
> R.Sathiamoorthy
>
>
>

Product Basket Problem

Hi,
I have to build a Poduct basket mining mode

Hi,

I have to build a Product basket mining mode such that when a customer selects

a product the model should be able to recommend him/her some more products.

I have a customer, product transaction table.

I have come across many typical examples where the output is

as follows

CustomerRecommended Products

Cust1a, b, c…….

Cust2e, b,

f……….

But I want the output of the model to be as follows

ProductRecommendedProducts

AB, C, D…….

BE, D, A…….

CD, A, F……

How should my mining model structure and the prediction

query look like?

Your model would look the same - all you would really want to do is to change how you query the model.

Essentially, the question you are asking is "if a customer bought product 'A', what other products might they buy". This is the same as "If customer 1 has product A in their basket, what products should I recommend." Therefore you need a query like this:

SELECT 'A' as [Product], Predict(Products,5) as [Recommended Products]
FROM MyRecommendationModel
NATURAL PREDICTION JOIN
(SELECT (SELECT 'A' as Product) AS Products) AS t

If you wanted to do this for all individual products, you would have to create a shaped input query from your product table. For example

SELECT t.Product, Predict(Products, 5) FROM [My Recommendation Model]
PREDICTION JOIN
SHAPE
{ OPENQUERY(MyDataSource],'SELECT Product FROM Products ORDER BY Product') }
APPEND
( {OPENQUERY([MyDataSource],'SELECT Product FROM Products ORDER BY Product'}
RELATE [Product] TO [Product])
AS [Products]
AS [t]
ON [My Recommendation Model].Products.Product=t.Products.Product

Processor licensing

In the processor licensing mode a license is required for each physical
or virtual processor like explained in
http://www.microsoft.com/sql/howtobuy/default.mspx
->But what about dual core processor?
->And what about clustering? (if a user install 2 server in cluster mode)

tnxOn Thu, 12 Oct 2006 14:14:40 GMT, Enorme Vigenti wrote:

Quote:

Originally Posted by

>In the processor licensing mode a license is required for each physical
>or virtual processor like explained in
>http://www.microsoft.com/sql/howtobuy/default.mspx
>
>->But what about dual core processor?

Hi Enorme,

You pay per soocket. So a dual-core can run on a single-core license.
And if you have a quad-code CPU with hyperthreading (do such beasts even
exist?), you'd have eight logical processors and still have to pay for
only a single processor license.

Quote:

Originally Posted by

>->And what about clustering? (if a user install 2 server in cluster mode)

If only one server is active and the other is a passice server, used
only to take over from the active server in case of an emergency, you
only need a license for the active server. The passive server can't have
more processors than the active server, though.

If you have two active servers (e.g. using one to offload some of the
reporting tasks), you'll have to license both servers.

Licensing FAQ: http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Hugo Kornelis, SQL Server MVP|||Licensing is per processor, not per core. So if you have one dual core
processor it still counts as one.
In clustering, I believe that you dont have to pay for the 'standby' server
if you do not use it for anything else (if its just standby you only need
one license for two servers in cluster).

MC

"Enorme Vigenti" <Lsimon5@.libero.itwrote in message
news:k5sXg.536$uv5.900@.twister1.libero.it...

Quote:

Originally Posted by

In the processor licensing mode a license is required for each physical
or virtual processor like explained in
http://www.microsoft.com/sql/howtobuy/default.mspx
>
->But what about dual core processor?
->And what about clustering? (if a user install 2 server in cluster mode)
>
tnx

|||On Thu, 12 Oct 2006 21:00:33 +0200, MC wrote:

(snip)

Hi MC,

May I suggest that you fix your system clock? The NNTP headers show that
your message was sent on Friday, 15:41 UTC/GMT, but the date on your
message shows as Thursday 19:00 UTC/GMT. That's almost 24 hours
difference.

Quote:

Originally Posted by

Quote:

Originally Posted by

>>Date: Thu, 12 Oct 2006 21:00:33 +0200

(...)

Quote:

Originally Posted by

Quote:

Originally Posted by

>>NNTP-Posting-Date: Fri, 13 Oct 2006 15:41:11 +0000 (UTC)

--
Hugo Kornelis, SQL Server MVP|||I'll pass it on to the admin on the machine I used. Thanks Hugo

MC

"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALIDwrote in message
news:5900j21t2g3f5gqrgspj346qsmio9ikth5@.4ax.com...

Quote:

Originally Posted by

On Thu, 12 Oct 2006 21:00:33 +0200, MC wrote:
>
(snip)
>
Hi MC,
>
May I suggest that you fix your system clock? The NNTP headers show that
your message was sent on Friday, 15:41 UTC/GMT, but the date on your
message shows as Thursday 19:00 UTC/GMT. That's almost 24 hours
difference.
>

Quote:

Originally Posted by

Quote:

Originally Posted by

>Date: Thu, 12 Oct 2006 21:00:33 +0200

(...)

Quote:

Originally Posted by

Quote:

Originally Posted by

>NNTP-Posting-Date: Fri, 13 Oct 2006 15:41:11 +0000 (UTC)

>
>
--
Hugo Kornelis, SQL Server MVP

Processor license

Hello everyone,
What is the procedure of changing a SQL 2000 server to processor mode
from per seat?
Thank you
Alex AndersonNo, switching between the licensing models is not
permitted.
>--Original Message--
>Hello everyone,
> What is the procedure of changing a SQL 2000 server
to processor mode
>from per seat?
>Thank you
>Alex Anderson
>
>.
>|||The following is unsupported but you may want to check the
link:
Q:How to change the license mode after SQL2000 setup?
http://www.tkdinesh.com/faq/ans/license.html
-Sue
On Mon, 23 Aug 2004 15:18:14 -0700, "Alex Anderson"
<AAnderson@.Murrieta.org> wrote:
>Hello everyone,
> What is the procedure of changing a SQL 2000 server to processor mode
>from per seat?
>Thank you
>Alex Anderson
>|||Sue,
Interesting link, however Mode is already set to 0 and I'm running
Windows 2003 Server. Although, contained within the same registry key is a
FlipAllow and I'm not sure what this is used for. Perhaps to allow the
switch between Per device and Processor? I have the licenses for two
processes (just purchased them from Microsoft) and now from what I'm told I
might just have to pay for support to re-license SQL. Go figure...
Thank you
Alex Anderson
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:fe6li09llida0kiqg7tksh26hta255i5de@.4ax.com...
> The following is unsupported but you may want to check the
> link:
> Q:How to change the license mode after SQL2000 setup?
> http://www.tkdinesh.com/faq/ans/license.html
> -Sue
> On Mon, 23 Aug 2004 15:18:14 -0700, "Alex Anderson"
> <AAnderson@.Murrieta.org> wrote:
> >Hello everyone,
> >
> > What is the procedure of changing a SQL 2000 server to processor mode
> >from per seat?
> >
> >Thank you
> >Alex Anderson
> >
>