Display date: 2012

2012年3月29日星期四

Display a servers "environment"

Does anyone have any techniques to be able to display what environment a
server might be part of (e.g. Production, UAT, Development etc).
Instance names already follow a standard naming convention (non descriptive)
so that is not an option.
My ideal solution would be to have a description appear for the server
registration in SSMS or Entman.
e.g.
server1 (SQL Server 8.0.878 - dom1\myuser)
would become...
server1 (SQL Server 8.0.878 PRODUCTION - dom1\myuser)
-
What metadata/ registry entries would I need to change to get this. Would it
cause issues (such as service pack upgrade problems). I would prefer not to
have to resort to putting this in a db/ table since I want the information
visible without having to issue a query.
Many thanks,
Mark.Hi
How does it know whether SQL Server uses PRODUCTION ir DEVELOPMENT?
http://dimantdatabasesolutions.blog...er.ht
ml
"news.microsoft.com" <nospam@.nospam.com> wrote in message
news:OFMENhYNIHA.5140@.TK2MSFTNGP05.phx.gbl...
> Does anyone have any techniques to be able to display what environment a
> server might be part of (e.g. Production, UAT, Development etc).
> Instance names already follow a standard naming convention (non
> descriptive) so that is not an option.
> My ideal solution would be to have a description appear for the server
> registration in SSMS or Entman.
> e.g.
> server1 (SQL Server 8.0.878 - dom1\myuser)
> would become...
> server1 (SQL Server 8.0.878 PRODUCTION - dom1\myuser)
> -
> What metadata/ registry entries would I need to change to get this. Would
> it cause issues (such as service pack upgrade problems). I would prefer
> not to have to resort to putting this in a db/ table since I want the
> information visible without having to issue a query.
> Many thanks,
> Mark.
>|||> My ideal solution would be to have a description appear for the server
> registration in SSMS or Entman.
Both SSMS and Enterprise Manager allow you to to logically group servers.
You might consider creating different groups for PROD, UAT, etc. to
categorize your servers by environment.
Hope this helps.
Dan Guzman
SQL Server MVP
"news.microsoft.com" <nospam@.nospam.com> wrote in message
news:OFMENhYNIHA.5140@.TK2MSFTNGP05.phx.gbl...
> Does anyone have any techniques to be able to display what environment a
> server might be part of (e.g. Production, UAT, Development etc).
> Instance names already follow a standard naming convention (non
> descriptive) so that is not an option.
> My ideal solution would be to have a description appear for the server
> registration in SSMS or Entman.
> e.g.
> server1 (SQL Server 8.0.878 - dom1\myuser)
> would become...
> server1 (SQL Server 8.0.878 PRODUCTION - dom1\myuser)
> -
> What metadata/ registry entries would I need to change to get this. Would
> it cause issues (such as service pack upgrade problems). I would prefer
> not to have to resort to putting this in a db/ table since I want the
> information visible without having to issue a query.
> Many thanks,
> Mark.
>|||those properties just tell me about the installation and are readonly.
I'm looking to add a custom property description that will be displayed at
the server registration.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUguZuZNIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Hi
> How does it know whether SQL Server uses PRODUCTION ir DEVELOPMENT?
> http://dimantdatabasesolutions.blog...er.
html
> "news.microsoft.com" <nospam@.nospam.com> wrote in message
> news:OFMENhYNIHA.5140@.TK2MSFTNGP05.phx.gbl...
>|||that would only help me (and I dont want to distribute anything).
what I need is for the logical server usage name to be displayed whenever a
developer registers a server.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:5F7B5747-FBF7-44BA-9D5A-5387DCA323CC@.microsoft.com...
> Both SSMS and Enterprise Manager allow you to to logically group servers.
> You might consider creating different groups for PROD, UAT, etc. to
> categorize your servers by environment.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "news.microsoft.com" <nospam@.nospam.com> wrote in message
> news:OFMENhYNIHA.5140@.TK2MSFTNGP05.phx.gbl...
>|||> what I need is for the logical server usage name to be displayed whenever
> a developer registers a server.
I don't have suggestion other than those already mentioned. The Best
Practice is to use mnemonic server/instance names that include the role of
the server but you mentioned that's not an option.
Hope this helps.
Dan Guzman
SQL Server MVP
"news.microsoft.com" <nospam@.nospam.com> wrote in message
news:O9shrmlNIHA.5988@.TK2MSFTNGP02.phx.gbl...
> that would only help me (and I dont want to distribute anything).
> what I need is for the logical server usage name to be displayed whenever
> a developer registers a server.
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:5F7B5747-FBF7-44BA-9D5A-5387DCA323CC@.microsoft.com...
>|||Thanks anyway Dan, always good to know opinions on best practice though.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:C9D2AAAF-D3F1-4293-97FC-951A096736F2@.microsoft.com...
> I don't have suggestion other than those already mentioned. The Best
> Practice is to use mnemonic server/instance names that include the role of
> the server but you mentioned that's not an option.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "news.microsoft.com" <nospam@.nospam.com> wrote in message
> news:O9shrmlNIHA.5988@.TK2MSFTNGP02.phx.gbl...
>

Display a report in fullscreenmode

Hello,
is it possible to open a report in fullscreenmode automatically? Perhaps there might be a http parameter?

Current view:

Now a click on the button on the right side. This is the view i want to see when i open a report.

Did anyone have an idea how i can achieve my goal?

Thanks for your help!
Christian Niehaves

Use the url http://servername/ReportServer instead of http://servername/Reports|||Great.
Thanks for your help.

Display a report in a WinForm client

Hi everyone!
This question has probably been asked many of times and I apologize for
asking again.
What is the best way to display a report in a WinForm client?
Thanks,
YEither embed IE control and use URL integration or use web services. With
Widbey and Yukon MS has announced a winform control but until then you have
to jump through more hoops.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Yoshi" <yoshi@.home.com> wrote in message
news:O0HKyt0xEHA.3840@.tk2msftngp13.phx.gbl...
> Hi everyone!
> This question has probably been asked many of times and I apologize for
> asking again.
> What is the best way to display a report in a WinForm client?
> Thanks,
> Y
>|||Perfecto!
Thanks for the quick response. I think I can handle these hoops.
Y
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:exbA590xEHA.3096@.tk2msftngp13.phx.gbl...
> Either embed IE control and use URL integration or use web services. With
> Widbey and Yukon MS has announced a winform control but until then you
> have
> to jump through more hoops.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Yoshi" <yoshi@.home.com> wrote in message
> news:O0HKyt0xEHA.3840@.tk2msftngp13.phx.gbl...
>> Hi everyone!
>> This question has probably been asked many of times and I apologize for
>> asking again.
>> What is the best way to display a report in a WinForm client?
>> Thanks,
>> Y
>>
>sql

display a message in store procedure

 helo all..., this is my store procedure. but it can not display message. my friend said it must use output code.

can someone add output code to my store procedure, so it can display message?

ALTER PROCEDURE [bank].[dbo].[pay]
(
 @.no_billINT,
 @.no_orderint,
 @.totalcostmoney,
 @.messagevarchar(100)-- make it output parameter in your stored procedure
)
ASBEGIN TRANSACTION
DECLARE @.balanceAS money
select @.balance = balance
from bank.dbo.bill
where no_bill = @.no_bill
select @.totalcost = totalcost
from games.dbo.totalcost
where no_order = @.no_order
if (@.balance > @.totalcost)
begin
set @.balance = @.balance - @.totalcost
UPDATE bank.dbo.bill
SET
 [balance] = @.balance
WHERE [no_bill] = @.no_bill
-- set @.message = 'your have enough balance'
end
else
begin
set @.message ='sorry, your balance not enough'
end
COMMIT TRANSACTION
set nocount off

pls.., thx

ALTER PROCEDURE [bank].[dbo].[pay]( @.no_billINT, @.no_orderint, @.totalcostmoney, @.messagevarchar(100)OUTPUT-- make it output parameter in your stored procedure)ASBEGIN TRANSACTION DECLARE @.balanceAS moneyselect @.balance = balancefrom bank.dbo.billwhere no_bill = @.no_billselect @.totalcost = totalcostfrom games.dbo.totalcostwhere no_order = @.no_orderif (@.balance > @.totalcost)beginset @.balance = @.balance - @.totalcostUPDATE bank.dbo.billSET [balance] = @.balanceWHERE [no_bill] = @.no_billset @.message ='your have enough balance'endelsebeginset @.message ='sorry, your balance not enough'end

|||

yes, thx. but when i execute that procedure, it told to insert no_order, no_bill,totalcost, message. i don't want to insert message, i want to insert no_order,no_bill,totalcost, and click ok, so then message automatic display it..

can u add any code ?

thx...

|||

Using the code posted below, I dont see how it could be wanting to "INSERT" or "UPDATE" message. We are setting the parameter @.message after the update statement is completed.
If you are still getting the error then post the current version of the code you are using.

ALTER PROCEDURE [bank].[dbo].[pay]( @.no_billINT, @.no_orderint, @.totalcostmoney, @.messagevarchar(100)OUTPUT-- make it output parameter in your stored procedure)ASBEGIN TRANSACTION DECLARE @.balanceAS money select @.balance = balancefrom bank.dbo.billwhere no_bill = @.no_billselect @.totalcost = totalcostfrom games.dbo.totalcostwhere no_order = @.no_orderif (@.balance > @.totalcost)begin set @.balance = @.balance - @.totalcostUPDATE bank.dbo.billSET [balance] = @.balanceWHERE [no_bill] = @.no_billset @.message ='your have enough balance'end else begin set @.message ='sorry, your balance not enough'endCOMMIT TRANSACTION

|||

yes, your code are right, but when i execute your code, it display:

type direction name value

int in no_bill we insert to this,example:110

int in no_order we insert to this,ex:2

money in totalcost we insert to this, ex 100$

char in/out message ??? if i not insert to this, myerror :Procedure or Function 'pay' expects parameter '@.message', whichwas not supplied.

so i must insert it something, then it can work... but i want to only insert no_bill,no_order,totalcost,so message is display automatic after i insert no_bill,no_order,totalcost.. is there can show automatic message without insert data to message?

thx...

|||

When you define an output parameter in a Stored procedure, you still need to pass a parameter in to the stored procedure. In your case you would pass in an empty string param.

Its not inserting into your DB message it just needs to know what to pass your output param back to.

If you need help with calling the stored procedure, then post that code where you are calling it and we can help you call it properly.

|||

thx .., now i want to call that message from pay.aspx. this is my pay.aspx.vb like:

pay.aspx.vb

Protected Sub Button1_Command(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs) Handles Button1.Command

Dim sp As String = "pay"
Dim connect As String = ConfigurationManager.AppSettings("ConnectionString")
Dim conn As New SqlConnection(connect)
Dim cm As New SqlCommand(sp, conn)
Dim totalcost As Label = Me.FormView1.FindControl("totallabel")
Dim no As Label = Me.FormView1.FindControl("no_orderlabel")
cm.CommandType = CommandType.StoredProcedure
cm.Parameters.AddWithValue("@.totalcost ", totalcost.Text)
cm.Parameters.AddWithValue("@.no_order ", no.Text)
cm.Parameters.AddWithValue("@.no_bill ", no_bill.Text)
cm.Parameters.AddWithValue("@.message", Label1.Text )

conn.Open()
cm.ExecuteNonQuery() ' do not forget to close Connection
conn.Close()

end sub

that code can work..., but i don't know about to display that message.

if totalcost > balance, show message"sorry, your balance is not enough"

if totalcost<balance, not show message..

pls...

thx...

|||

First change

cm.Parameters.AddWithValue("@.message", Label1.Text )

cm.Parameters.Add(New SqlParameter("@.message", SqlDbType.VarChar, 250, ParameterDirection.Output))

Then right after

cm.ExecuteNonQuery() ' do not forget to close Connection

add

Dim message As String - cm.Parameters("@.message").Value

|||

thx, it work.. but not display a message.

so i put label1.text in this, but it still no display a message. this is my code:

Protected Sub Button1_Command(ByVal sender As Object, ByVal e AsSystem.Web.UI.WebControls.CommandEventArgs) Handles Button1.Command

conn.Open()
cm.ExecuteNonQuery() ' do not forget to close Connection

Dim message As String - cm.Parameters("@.message").Value
conn.Close()
label1.text= message

end sub

but the label no show message.. how should i do?

thx...

|||

have you tried debugging and stepping through the code?

|||

yes, i have many try it, but not show a message, maybe i put label1.text in wrong location. can u show that label put in true location?

pls..,thx..

|||

other than changing it to

label1.text = message.tostring()

your code looks correct. When you step through it set a breakpoing on "Dim message as string" so when you step on to conn.close() you can see if message has a value.

|||

i have use breakpoint at row label1.text, it display value text="". it mean not take message from @.message,so empty..

or maybe my store procedure is wrong?

this is my store procedure

ALTER PROCEDURE [bank].[dbo].[paid]
(
 @.no_billINT,
 @.no_orderint,
 @.totalcostmoney,
 @.messagevarchar(100) output="a"
)
ASBEGIN TRANSACTION
DECLARE @.balanceAS money
select @.balance = balance
from bank.dbo.bill
where no_bill = @.no_bill
select @.totalcost = totalcost
from games.dbo.totalcost
where no_order = @.no_order
if (@.balance > @.totalcost)
begin
set @.balance = @.balance - @.totalcost
UPDATE bank.dbo.bill
SET
 [balance] = @.balance
WHERE [no_bill] = @.no_bill
-- set @.message = 'your have enough balance'
end
else
begin
set @.message ='sorry, your balance not enough'
end
COMMIT TRANSACTION

but i execute in store procedure, it can display message...

so,which is wrong?

thx

|||

Here is an article for you on another way to define an output parameter.

http://www.sqlservercentral.com/columnists/kKellenberger/usingparameterswithstoredprocedures.asp

Also you have in your stored procedure one line commented out that sets @.message, and your also trying to set a default value using double quotes.

If you want to set a default value for the parameter then set it inside of your begin transaction statement, and also use single quotes in setting it.

Display a KPI need the same Dimension on its Value and Target?

I mean, I have a KPI, it's value is set to a measure of a measuregroup based on a facttable A. and it's Target is set to a measure of another measuregroup based on another facttable B.

Now I want to display the KPI, with a given dimension's slice. My question is, is it needed that the dimension I chose must be shared by both the measures of KPI's Value and Target? For an example, If I dispaly the KPI with the Promotion Dimention, and the Promotion Dimention has a relation to the KPI's Value's related measure(There's a PromotionKey column in facttable A; ), but it has no relation to the KPI's Target's related measure(There's NOT a PromotionKey column in facttable B).

Could I do so?

I think this is SSAS question. I moved it to the SSAS forum...|||

OK.

Help, Help! Thanks.

|||

The KPI should work similarly to the underlying measures - so, in your example, the KPI Target behavior will depend on how the IgnoreUnrelatedDimensions property of the "facttable B" Measure Group is set. If true (default), then the KPI Target should be unaffected by slicing the Promotion dimension; if false, the KPI Target should become null.

http://sqljunkies.com/WebLog/mosha/archive/2005/12/31/cube_init.aspx

Default members, MDX Scripts, Security, KPIs and Perspectives

...

KPI trigger creation of hidden calculated measures only if the MDX expression for the KPI property is not a simple reference to some measure (either calculated or physical). However, if the expression is a simple reference, such as [Measures].[Sales], then no hidden calculated measure will be created, and KPIValue, KPIGoal, KPITrend etc functions will simply return that measure.

http://msdn2.microsoft.com/en-us/library/ms365411.aspx

Configuring Measure Group Properties

...

IgnoreUnrelatedDimensions

Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True.

|||Thanks! that's what i am looking for! Thank you, Puri.

Display a image based on a value field

Hello friends
I have a problem displaying a picture on a table detail based on a value of
a column.
If this column have a value greather than 10, show a image, else show
another image. I don't know how to call the images on the statement below
=IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
I've added the images to the project as a embedded images.
Can anyone please help me or give me an example?
Thanks for Help
BrunoI only know one line of VB code, which is what I use to show/hide
report elements. Maybe you can use it to help you write yours to work
the way it needs to.
=IIF(Parameters!ReportGroup.Value = 1 AND Parameters!ReportType.Value =1, False, True)|||Hi Bruno
I'm only a novice, but this works:
Create two identical table rows, one below the other, each row has one cell
showing the (same) database field - e.g. "ID" and one cell to hold the
appropriate image - row 1 holds image1, row2 holds image2.
Now set the visibility of each row using expressions:
row1: =iif(Fields!ID.value<10,true,false)
row2: =iif(Fields!ID.value>=10,true,false)
when you run the report, the rows will be visible with the appropriate
images appearing as the ID.values change
~grasshopper~
"Bruno" wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a value of
> a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno|||Create an image control on the report, make it show one of the images
you've embedded. In the properties of the image, you should be able to
see how the image is referred to in the "value" property. Now wrap the
=IIf statement around this. The image name will have to be in double
quotes because you are passing a string value to the property. For
example;
=IIf(Fields!DIAS.Value > 10, "Image1.gif", "Image2.gif")
If you wanted to show now image you could do;
=IIf(Fields!DIAS.Value > 10, Nothing, "Image2.bmp")
I haven't tried this but see no reason it shouldn't work for both
RS2000 or RS2005.
Cheers
Chris
Bruno wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a
> value of a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement
> below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno

Display a field onlt up to a Specific Character

Hi
Can someone please tell me if there is a function that can be used to print a field only up till a specific character. For ex: I'm trying to print all the student email Id's bu only the characters that fall before the "@." sign.
Thanks
ACleft(x, instr(x, '@.') -1)|||Hello
Thank you sooo much. It worked!!

Thanks again
Aparna

Display a datagrid using the dataset as the source?

I am not sure how to display this in my report. I have dataset that queries the database to find a list of ingredients. I would like each ingredient listed in a grid. Under each individual ingredient is its amount, which is found from the database, using the Product and Ingredient name discussed above. The ingredient dataset has a list of ingredients. So I need the first one displayed in the first field, the second in the second field and so on. Then I need to ordert the Amounts Dataset properly so that the amount appears directly below the appropriate ingredient. How do you make a table cell display the first member of a dataset, then the second cell display the second and so on? Right now it is trying to display all the ingredients in one cell. I hope this makes sence. Thanks.I dont know if that makes any sence, so I found some better words to describe my problem. I have a table that I would like to transpose. This table could be long, so I only want it transposed for 5 or 5 columns, then word-wrapped to the next line so it can all fit on one page. How do you transpose a table. Is this a reporting issue, or should this be done on the Sql side? Thanks.sql

Display 2 field of database in form <select>

I have a database "code" with 2 field : "product_code" and "description".
product_code | description
PC | Personal Computer
MS | Mouse
etc

The form will let user choose a product code from this database. The query is like this :

java.sql.ResultSet rsproduct = statement10.executeQuery("SELECT * FROM code ORDER BY product_code");

At the form section,

<select name="product_code">
<option value=""></option>
<%
while(rsproduct.next()){
%>
<option value="<%=rsproduct.getString("product_code").trim()%>"><%=rsproduct.getString("product_code")%></option>
<%}%>
</select>

How should I coding if wanna let user view the description for particular product_code while scroll down?

Thanks~~Can any code for "pop up" the different description while the mouse pointer is on the different product_code?

Display 1 piece of Data from a SQLDataSource

I have the following sqlDataSource. I wan't to display one piece of data, not a whole row, from it. I can find lots of information on putting it into a datagrid, but nothing on puttin one piece in a textbox. I cannot use a formview as we are embedding html in response.write and it breaks in a formview. Thanks.

<asp:SqlDataSourcerunat="server"

ID="myEmpInfo"

SelectCommand="Select di.EmpInfo,di.eth,gc.t_level

From tblEmp di

,tblMisc gc

Where di.empnum = @.empnum

and di.empnum = gc.empnum"DataSourceMode="DataReader"ConnectionString="<%$ ConnectionStrings : myConnectionString %>">

<asp:QueryStringParameterName="empnum"QueryStringField="empnum"/>

</SelectParameters>

</asp:SqlDataSource>

Hi,

Do you want to get the value of specific row and specific column from a table? If so,you can use DataView to achieve. See the following sample:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" DataSourceMode="DataSet" ConnectionString="<%$ ConnectionStrings:TestConnectionString2%>" ></asp:SqlDataSource>

SqlDataSource1.SelectCommand ="select CategoryName from Categories";DataView dw = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
 /// Display all the valueforeach (DataRow drin dw.Table.Rows) {foreach (DataColumn dcin dw.Table.Columns) { Response.Write(dr[dc.ToString()].ToString() +";"); } Response.Write("\r\n"); }/// You also can use /// string str = dw.Table.Rows[0][0].ToString(); /// to get the value from a specific row specific column.
 
Hope that helps. Thanks.

Display .356 as a percentage

I have several columns of data in a report that have values like .743 or
.253, and I'd like them to display as 74.3% and 25.3%.
I'm a reporting services newbie - I didn't see a format option in the
properties of a textbox. Suggestions?
Thanks in advance.
MarkSorry - just found it.
Properties of Textbox- Format - enter "P2"
Mark
"Mark" <markfield88@.nospam.nospam> wrote in message
news:u3451E0fGHA.4004@.TK2MSFTNGP04.phx.gbl...
>I have several columns of data in a report that have values like .743 or
>.253, and I'd like them to display as 74.3% and 25.3%.
> I'm a reporting services newbie - I didn't see a format option in the
> properties of a textbox. Suggestions?
> Thanks in advance.
> Mark
>|||that works or you can set the value of the text box to
=Format(Fields!FieldName.value, "p")

Display <Long Text> in a table ??

Hi there,
I have taken over a SQL 2000 database and within it is a table which has
content for ASP web pages.
Some of the content is pretty long, and for some reason is displayed as
<Long Text> in the table, up returning all rows.
I need to change this text, how can i do this by ammending the existing
text? I need to see what is there!
Hope you guys can help,
Thanx
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.comFawke
Look at UPDATETEXT in the BOL
"Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> Hi there,
> I have taken over a SQL 2000 database and within it is a table which has
> content for ASP web pages.
> Some of the content is pretty long, and for some reason is displayed as
> <Long Text> in the table, up returning all rows.
> I need to change this text, how can i do this by ammending the existing
> text? I need to see what is there!
> Hope you guys can help,
> Thanx
> --
> Thanks in advance
> Fawke
> Please remove ANTI and SPAM
> from my email address before emailing me.
> www.bradflack.com
>|||sorry, what are these?
forgive me, i am quite new to SQL
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23v0unqEKEHA.1392@.TK2MSFTNGP09.phx.gbl...
> Fawke
> Look at UPDATETEXT in the BOL
>
> "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> > Hi there,
> >
> > I have taken over a SQL 2000 database and within it is a table which has
> > content for ASP web pages.
> > Some of the content is pretty long, and for some reason is displayed as
> > <Long Text> in the table, up returning all rows.
> >
> > I need to change this text, how can i do this by ammending the existing
> > text? I need to see what is there!
> >
> > Hope you guys can help,
> >
> > Thanx
> >
> > --
> > Thanks in advance
> >
> > Fawke
> >
> > Please remove ANTI and SPAM
> > from my email address before emailing me.
> >
> > www.bradflack.com
> >
> >
>|||BOL says:
Updates an existing text, ntext, or image field. Use UPDATETEXT to change
only a portion of a text, ntext, or image column in place. Use WRITETEXT to
update and replace an entire text, ntext, or image field.
This example puts the text pointer into the local variable @.ptrval, and then
uses UPDATETEXT to update a spelling error.
USE pubs
GO
EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'true'
GO
DECLARE @.ptrval binary(16)
SELECT @.ptrval = TEXTPTR(pr_info)
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
AND p.pub_name = 'New Moon Books'
UPDATETEXT pub_info.pr_info @.ptrval 88 1 'b'
GO
EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'false'
GO
For more details please refer to BOL (Books Online)
"Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
news:#LILT2EKEHA.2660@.TK2MSFTNGP09.phx.gbl...
> sorry, what are these?
> forgive me, i am quite new to SQL
> --
> Thanks in advance
> Fawke
> Please remove ANTI and SPAM
> from my email address before emailing me.
> www.bradflack.com
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23v0unqEKEHA.1392@.TK2MSFTNGP09.phx.gbl...
> > Fawke
> > Look at UPDATETEXT in the BOL
> >
> >
> > "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> > news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> > > Hi there,
> > >
> > > I have taken over a SQL 2000 database and within it is a table which
has
> > > content for ASP web pages.
> > > Some of the content is pretty long, and for some reason is displayed
as
> > > <Long Text> in the table, up returning all rows.
> > >
> > > I need to change this text, how can i do this by ammending the
existing
> > > text? I need to see what is there!
> > >
> > > Hope you guys can help,
> > >
> > > Thanx
> > >
> > > --
> > > Thanks in advance
> > >
> > > Fawke
> > >
> > > Please remove ANTI and SPAM
> > > from my email address before emailing me.
> > >
> > > www.bradflack.com
> > >
> > >
> >
> >
>|||Check out below articles:
From classic VB code and ADO:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038
From .NET code and ADO.NET:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316887
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> Hi there,
> I have taken over a SQL 2000 database and within it is a table which has
> content for ASP web pages.
> Some of the content is pretty long, and for some reason is displayed as
> <Long Text> in the table, up returning all rows.
> I need to change this text, how can i do this by ammending the existing
> text? I need to see what is there!
> Hope you guys can help,
> Thanx
> --
> Thanks in advance
> Fawke
> Please remove ANTI and SPAM
> from my email address before emailing me.
> www.bradflack.com
>|||Still a tad confused, is this the only way?
Can i not just view this in the table, i want to "see" what is there now,
and type in the new words/values.
Just like i would when changing a shorter piece of text (that i can see!) in
a table.....
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$G4w7EKEHA.2756@.TK2MSFTNGP10.phx.gbl...
> BOL says:
> Updates an existing text, ntext, or image field. Use UPDATETEXT to change
> only a portion of a text, ntext, or image column in place. Use WRITETEXT
to
> update and replace an entire text, ntext, or image field.
> This example puts the text pointer into the local variable @.ptrval, and
then
> uses UPDATETEXT to update a spelling error.
> USE pubs
> GO
> EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'true'
> GO
> DECLARE @.ptrval binary(16)
> SELECT @.ptrval = TEXTPTR(pr_info)
> FROM pub_info pr, publishers p
> WHERE p.pub_id = pr.pub_id
> AND p.pub_name = 'New Moon Books'
> UPDATETEXT pub_info.pr_info @.ptrval 88 1 'b'
> GO
> EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'false'
> GO
> For more details please refer to BOL (Books Online)
>
>
> "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> news:#LILT2EKEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > sorry, what are these?
> >
> > forgive me, i am quite new to SQL
> >
> > --
> > Thanks in advance
> >
> > Fawke
> >
> > Please remove ANTI and SPAM
> > from my email address before emailing me.
> >
> > www.bradflack.com
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:%23v0unqEKEHA.1392@.TK2MSFTNGP09.phx.gbl...
> > > Fawke
> > > Look at UPDATETEXT in the BOL
> > >
> > >
> > > "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> > > news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> > > > Hi there,
> > > >
> > > > I have taken over a SQL 2000 database and within it is a table which
> has
> > > > content for ASP web pages.
> > > > Some of the content is pretty long, and for some reason is displayed
> as
> > > > <Long Text> in the table, up returning all rows.
> > > >
> > > > I need to change this text, how can i do this by ammending the
> existing
> > > > text? I need to see what is there!
> > > >
> > > > Hope you guys can help,
> > > >
> > > > Thanx
> > > >
> > > > --
> > > > Thanks in advance
> > > >
> > > > Fawke
> > > >
> > > > Please remove ANTI and SPAM
> > > > from my email address before emailing me.
> > > >
> > > > www.bradflack.com
> > > >
> > > >
> > >
> > >
> >
> >
>|||the field is ntext, where do i run this code? can i do this within the table
query?
a bit double-dutch
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$G4w7EKEHA.2756@.TK2MSFTNGP10.phx.gbl...
> BOL says:
> Updates an existing text, ntext, or image field. Use UPDATETEXT to change
> only a portion of a text, ntext, or image column in place. Use WRITETEXT
to
> update and replace an entire text, ntext, or image field.
> This example puts the text pointer into the local variable @.ptrval, and
then
> uses UPDATETEXT to update a spelling error.
> USE pubs
> GO
> EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'true'
> GO
> DECLARE @.ptrval binary(16)
> SELECT @.ptrval = TEXTPTR(pr_info)
> FROM pub_info pr, publishers p
> WHERE p.pub_id = pr.pub_id
> AND p.pub_name = 'New Moon Books'
> UPDATETEXT pub_info.pr_info @.ptrval 88 1 'b'
> GO
> EXEC sp_dboption 'pubs', 'select into/bulkcopy', 'false'
> GO
> For more details please refer to BOL (Books Online)
>
>
> "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> news:#LILT2EKEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > sorry, what are these?
> >
> > forgive me, i am quite new to SQL
> >
> > --
> > Thanks in advance
> >
> > Fawke
> >
> > Please remove ANTI and SPAM
> > from my email address before emailing me.
> >
> > www.bradflack.com
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:%23v0unqEKEHA.1392@.TK2MSFTNGP09.phx.gbl...
> > > Fawke
> > > Look at UPDATETEXT in the BOL
> > >
> > >
> > > "Fawke101" <guy@.ANTIbradflack.SPAMcom> wrote in message
> > > news:unRgynEKEHA.952@.TK2MSFTNGP12.phx.gbl...
> > > > Hi there,
> > > >
> > > > I have taken over a SQL 2000 database and within it is a table which
> has
> > > > content for ASP web pages.
> > > > Some of the content is pretty long, and for some reason is displayed
> as
> > > > <Long Text> in the table, up returning all rows.
> > > >
> > > > I need to change this text, how can i do this by ammending the
> existing
> > > > text? I need to see what is there!
> > > >
> > > > Hope you guys can help,
> > > >
> > > > Thanx
> > > >
> > > > --
> > > > Thanks in advance
> > > >
> > > > Fawke
> > > >
> > > > Please remove ANTI and SPAM
> > > > from my email address before emailing me.
> > > >
> > > > www.bradflack.com
> > > >
> > > >
> > >
> > >
> >
> >
>|||You can execute the statements in Query Analyzer.
-Sue
On Thu, 22 Apr 2004 11:17:14 +0100, "Fawke101"
<guy@.ANTIbradflack.SPAMcom> wrote:
>the field is ntext, where do i run this code? can i do this within the table
>query?
>a bit double-dutch|||Ok, i have created a linked table in Access and edited it thru here, seems
to work....
Thanks for all your help
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:rjdf80l1eqp3779ko6a7k41g14u1bpdlll@.4ax.com...
> You can execute the statements in Query Analyzer.
> -Sue
> On Thu, 22 Apr 2004 11:17:14 +0100, "Fawke101"
> <guy@.ANTIbradflack.SPAMcom> wrote:
> >the field is ntext, where do i run this code? can i do this within the
table
> >query?
> >a bit double-dutch
>

Display "Last Run Date" in report!

Is there a way to display the "Last Run Date" in the actual report?The short answer is no, though you could try writing a custom assembly that
passes a report path on the server and then return the ExecutionDate
property via soap.
The properties you will need to build the report path are ReportServerURL,
ReportFolder, and ReportName.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
news:FE56C3C8-9FB6-4320-9AF9-8FD3C3612AC2@.microsoft.com...
> Is there a way to display the "Last Run Date" in the actual report?|||Do you really want the "Last Run Date", or do you just want to know the
actual timestamp of data and report processing of a particular report (or
history snapshot)?
If it is the latter one, then just add a textbox with =Now to the report.
When the report is rendered live and no execution caching is involved, then
the expression will return the current timestamp (because the data and the
report layout is processed live). If execution caching is involved the
textbox with have the timestamp of the execution snapshot. Finally, if you
render an historic snapshot, the textbox will have the timestamp when the
snapshot has been created (unless you re-process a parameterized history
snapshot where expressions will get re-evaluated).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:ewzyGxTlEHA.3876@.TK2MSFTNGP15.phx.gbl...
> The short answer is no, though you could try writing a custom assembly
that
> passes a report path on the server and then return the ExecutionDate
> property via soap.
> The properties you will need to build the report path are ReportServerURL,
> ReportFolder, and ReportName.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "St Matthew" <StMatthew@.discussions.microsoft.com> wrote in message
> news:FE56C3C8-9FB6-4320-9AF9-8FD3C3612AC2@.microsoft.com...
> > Is there a way to display the "Last Run Date" in the actual report?
>

Dispalying AS2005 Parent-child hierarchy with RS2005

Hello,

in AdventureWorksDW at Dimemployee there is a parent-child dimension.

If I use the browse Tab in VS, I can browse all the levels of that hierarchy.

My question is How do I produce this kind of report with RS2005 sp1?

I need the report to behave the same as the browser of VS, meaning that the level depth can change.

I looked all over the web, but didn't find any solution.

Thanks,

Yoav.

Your problem is to fetch all data of parent-child dimension in a single query oi order to fit it in sinlgle SSRS report. I suppose that such solution won't satisfy you. You schould develop report getting data from SSAS by demand, not all-in-one query.|||I had the same problem. From I've been reading Reporting Services has limited functionality when dealing with Analysis Services including the parent-child relationship.

In analysis services I never designated a parent-child relationship, I just simply put the appropriate keys into the cube. That way Reporting Services can do the hierarchy just like it does for aregular SQL query.

The query should return an ID and a Parent ID. In RS create a table with just the Details row (just now at least). In the properties put the group on being the ID and the Parent being the parent ID.

For more info checkout:
http://www.codeguru.com/csharp/.net/net_data/sortinganditerating/article.php/c12223/|||

If this not is working with a SSAS2005 cube you can query the data mart/source system with a TSQL CTE(Common Table Expression). I know that this is an OLAP forum but if nothing else works try the examples i SSRAS2005 that you find on this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_05TSQLEnhance.asp

HTH

Thomas Ivarsson

|||

Hi,

thanks for the answer .

I asked if there is an option to use the hierarchy of AS?

I know how to produce RS parent-child reports.

is this the only option?

Dispaly mask and select N-M records

Two questions:
1. With SQL, how can I setup display mask for dollar amount :
eg. 100000 display as $100,000
2. How can I select number N to M records in a table.
eg. select No. 50 - 100 records from a table. ( not top 50)
Thanks,
Guyang1.
cast(100000 as money)

2.
select top 51 foo
from (
select top 100 foo
from yourtable
order by foo desc
) as derivedtable
order by foo

rudy
http://r937.com/|||Formatting of results is best handled by the user interface (in my humble opinion).

Rudy's method works for a specific case, but the TOP command (very unfortunately) does not accept variables as parameters. You will need to cast your query as a dynamic SQL statement to use it for the general N of M case.

A lot of people come across this issue when trying to produce results that can be "paged" through, such as in a web page. If this is the case for you, then instead of trying to find records N of M, have your interface submit the largest sort-value of the previous recordset as a parameter, and then your procedure can return the first 50 (hard-coded) records that are greater than that value.

blindman|||For question one,

I try the cast(100000 as money), result as:

100000.0000 , any way to output as: $100,000 ?

Thanks for advise.

Guyang|||SELECT '$' + CONVERT (varchar(10), 100000, 1)

If you don't want the decimal values:
SELECT '$' + LEFT(CONVERT(varchar(10), 100000, 1), len(CONVERT (varchar(10), 100000, 1) - 3))

...but I'll say again that it is better to let the interface handle this. I'm thinking that you are coming from the Access world, but Access is a database and an interface wrapped together. SQL Server is purely a database (but much more powerful than MS Access). You should you other tools to communicate with the database and format the output, such as VB applications, MS Access Data Projects, or (yech) Crystal Reports.

blindmansql

dispaly data at bottom of the report by daily,weekly,monthly,SYTD

hai iam new to ssrs, please help me.

i have student billbale information assume what ever data it. i need to to dispaly total amount for the student at

Bottom Of Report By Daily, Weekly, Monthly, SYTD . take any example, i want to know formula.

thanks to advanced

Jacks v

In Reporting Services there is no inbuild formula for Daily, Weekly etc

You will have to perform these calculations inside the stored procedure and return the dataset back to the RDL.

Reporting Services provides us with some grouping functions which can be found at

http://technet.microsoft.com/en-us/library/ms159673.aspx

Dislpay Report Parameters selectively?

I was wondering if there is a way I can selective display report parameters?
For example, I have one parameters that lets the user select a report type.
If the user selects 'Daily' I want to display the report parameter that
allows the user select a date. On the other hand if the user selects
'Monthly' I want to display a drop down list that has all months preloaded.
I do not want the dropdown list that contains months to show up if the user
wants to run a 'Daily' report.
Any help would be much appreciated!
TIA
VinayPresuming that you are also able to display a drop-down list of available
dates if the user selects 'Daily' then the way I would do this is to have a
dataset using a stored procedure which takes the Daily/Monthly parameter and
generates the drop-down list accordingly.
HTH,
magendo_man
"Vinay" wrote:
> I was wondering if there is a way I can selective display report parameters?
> For example, I have one parameters that lets the user select a report type.
> If the user selects 'Daily' I want to display the report parameter that
> allows the user select a date. On the other hand if the user selects
> 'Monthly' I want to display a drop down list that has all months preloaded.
> I do not want the dropdown list that contains months to show up if the user
> wants to run a 'Daily' report.
> Any help would be much appreciated!
> TIA
> Vinay
>
>

Diskspace problem running tuning advisor after server profiler?!

Hi,
I am trying to run a session in Database tuning advisor on a ~8G database
and the workload is ~350M. During the session, diskspace on drive C is
running low, it's using more than 3G after a while.
Which database/location is the tuning advisor using for temporary files?
Drive C is too small, and I want to change the setting to use drive E for
example. Anyone knows how to do this?
Thanks!
ValentijnHi
If the DTA is using tempdb space you would be able to see this, by looking
at the file sizes; but if you suddenly regain this space after the program is
stopped then it is more likely to be temporary files in the temp directory.
In general it is best practice if you move the temp directories away from the
system disc onto a drive that is less critical if it fills up.
John
"Valentijn" wrote:
> Hi,
> I am trying to run a session in Database tuning advisor on a ~8G database
> and the workload is ~350M. During the session, diskspace on drive C is
> running low, it's using more than 3G after a while.
> Which database/location is the tuning advisor using for temporary files?
> Drive C is too small, and I want to change the setting to use drive E for
> example. Anyone knows how to do this?
> Thanks!
> Valentijn|||Microsoft recommends using of these tools on another machine if possible,
not on the production one.
--
Ekrem Ã?nsoy
"Valentijn" <Valentijn@.discussions.microsoft.com> wrote in message
news:B3C3E818-D440-4A0E-8D5C-5489D45C62F8@.microsoft.com...
> Hi,
> I am trying to run a session in Database tuning advisor on a ~8G database
> and the workload is ~350M. During the session, diskspace on drive C is
> running low, it's using more than 3G after a while.
> Which database/location is the tuning advisor using for temporary files?
> Drive C is too small, and I want to change the setting to use drive E for
> example. Anyone knows how to do this?
> Thanks!
> Valentijn|||Hi
If you are only talking about SQL Profiler and not DTA then it certainly
does use space in the temp folder.
John
"John Bell" wrote:
> Hi
> If the DTA is using tempdb space you would be able to see this, by looking
> at the file sizes; but if you suddenly regain this space after the program is
> stopped then it is more likely to be temporary files in the temp directory.
> In general it is best practice if you move the temp directories away from the
> system disc onto a drive that is less critical if it fills up.
> John
> "Valentijn" wrote:
> > Hi,
> >
> > I am trying to run a session in Database tuning advisor on a ~8G database
> > and the workload is ~350M. During the session, diskspace on drive C is
> > running low, it's using more than 3G after a while.
> >
> > Which database/location is the tuning advisor using for temporary files?
> > Drive C is too small, and I want to change the setting to use drive E for
> > example. Anyone knows how to do this?
> >
> > Thanks!
> >
> > Valentijn|||Hi John,
Thanks for the answer. I'm using the Tuning Advisor from the GUI (Management
console), so I'm not using the commandline tool DTA directly.
The SQL Profiler runs fine, but the diskspace problem occurs when running
the tuning advisor. And yes, the diskspace suddenly comes back after stopping
the tuning advisor.
One of the things I will try monday at work is changing the temp folder.
Would I do that by just changeing the environment variable TEMP?
Furthermore, how can I see DTA (or the graphical version) does use the
tempdb? I looked at the filesize op tempmdb.mdf (and the other system
databases, but they were not growing during the tuning session)..
Thanks again,
Valentijn
"John Bell" wrote:
> Hi
> If you are only talking about SQL Profiler and not DTA then it certainly
> does use space in the temp folder.
> John
> "John Bell" wrote:
> > Hi
> >
> > If the DTA is using tempdb space you would be able to see this, by looking
> > at the file sizes; but if you suddenly regain this space after the program is
> > stopped then it is more likely to be temporary files in the temp directory.
> > In general it is best practice if you move the temp directories away from the
> > system disc onto a drive that is less critical if it fills up.
> >
> > John
> >
> > "Valentijn" wrote:
> >
> > > Hi,
> > >
> > > I am trying to run a session in Database tuning advisor on a ~8G database
> > > and the workload is ~350M. During the session, diskspace on drive C is
> > > running low, it's using more than 3G after a while.
> > >
> > > Which database/location is the tuning advisor using for temporary files?
> > > Drive C is too small, and I want to change the setting to use drive E for
> > > example. Anyone knows how to do this?
> > >
> > > Thanks!
> > >
> > > Valentijn|||Hi
If the space is reclaimed once you have stopped dta then it is not tempdb
that is being used as the tempdb file would remain enlarged. sp_helpfile or
sp_helpdb from a query window would tell you the size of tempdb files
before, during and again after you ran the wizard if you ran it several
times. You could also use the perfmon counters to monitor database file sizes.
From BOL: Database Engine Tuning Advisor stores tuning session data and
other information in the msdb database. Implement an appropriate backup
strategy for the msdb database to avoid the risk of losing tuning session
data.
Again you can use the above methods to monitor the size of msdb but you say
these have not changed which again points to files being created in the temp
folder.
You need to set the temp environment variable before starting the database
tuning advisor.
John
"Valentijn" wrote:
> Hi John,
> Thanks for the answer. I'm using the Tuning Advisor from the GUI (Management
> console), so I'm not using the commandline tool DTA directly.
> The SQL Profiler runs fine, but the diskspace problem occurs when running
> the tuning advisor. And yes, the diskspace suddenly comes back after stopping
> the tuning advisor.
> One of the things I will try monday at work is changing the temp folder.
> Would I do that by just changeing the environment variable TEMP?
> Furthermore, how can I see DTA (or the graphical version) does use the
> tempdb? I looked at the filesize op tempmdb.mdf (and the other system
> databases, but they were not growing during the tuning session)..
> Thanks again,
> Valentijn
> "John Bell" wrote:
> > Hi
> >
> > If you are only talking about SQL Profiler and not DTA then it certainly
> > does use space in the temp folder.
> >
> > John
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > If the DTA is using tempdb space you would be able to see this, by looking
> > > at the file sizes; but if you suddenly regain this space after the program is
> > > stopped then it is more likely to be temporary files in the temp directory.
> > > In general it is best practice if you move the temp directories away from the
> > > system disc onto a drive that is less critical if it fills up.
> > >
> > > John
> > >
> > > "Valentijn" wrote:
> > >
> > > > Hi,
> > > >
> > > > I am trying to run a session in Database tuning advisor on a ~8G database
> > > > and the workload is ~350M. During the session, diskspace on drive C is
> > > > running low, it's using more than 3G after a while.
> > > >
> > > > Which database/location is the tuning advisor using for temporary files?
> > > > Drive C is too small, and I want to change the setting to use drive E for
> > > > example. Anyone knows how to do this?
> > > >
> > > > Thanks!
> > > >
> > > > Valentijn

disks when doing mirroirng

Hi,
I'm using SQL 2005 with 2 identical servers
I want to use Mirroring between the two.
I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
services)
each server has 6 disks.
what is the best configuration of these disks ?
3 RAID1, 1 RAID1 + RAID5 ?
and where should i put things ?
e.g. OS, data files, log files, tempDB, reporting services, SSIS ..If all drives are the same size and type, for fault tolerance:
1- Mirror of two disks for OS and SQL Server
2- Create two mirrors (2 drives each) and then create a stripe with parity
between both mirrors (RAID 0). I will put the data and log files there.
This way, you can have 3 failed disks (one failed disk on each mirror) and
the system will still be online. Also RAID 0 will give you better performance.
Another option would be to create a RAID 5 with for the data and the files,
which will give you a good performance for reads (not as good for wites..)
and you will be having more space for storage for the data and the logs,
compared with the first option
"raviv762@.gmail.com" wrote:
> Hi,
> I'm using SQL 2005 with 2 identical servers
> I want to use Mirroring between the two.
> I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
> services)
> each server has 6 disks.
>
> what is the best configuration of these disks ?
> 3 RAID1, 1 RAID1 + RAID5 ?
> and where should i put things ?
> e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
>|||Is your database OLTP? ... if not, you can setup your server like this:
RAID 1 (2 disks) = Os
RAID 5 (4 disks) = Data and Log files
If your data is not static, then ...
RAID 1 = Os
RAID 1 = Data Files
RAID 1 = Log Files
Using this last config. you won't have a high availability option like
RAID 5 for your data but you'll have a better performance for your
transactions and log files...
Edgardo wrote:
> If all drives are the same size and type, for fault tolerance:
> 1- Mirror of two disks for OS and SQL Server
> 2- Create two mirrors (2 drives each) and then create a stripe with parity
> between both mirrors (RAID 0). I will put the data and log files there.
> This way, you can have 3 failed disks (one failed disk on each mirror) and
> the system will still be online. Also RAID 0 will give you better performance.
> Another option would be to create a RAID 5 with for the data and the files,
> which will give you a good performance for reads (not as good for wites..)
> and you will be having more space for storage for the data and the logs,
> compared with the first option
> "raviv762@.gmail.com" wrote:
> >
> > Hi,
> >
> > I'm using SQL 2005 with 2 identical servers
> > I want to use Mirroring between the two.
> > I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
> > services)
> >
> > each server has 6 disks.
> >
> >
> > what is the best configuration of these disks ?
> > 3 RAID1, 1 RAID1 + RAID5 ?
> >
> > and where should i put things ?
> > e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
> >
> >|||thanks for the quick answer.
some remarks and a question ...
1) i can not do RAID10 since my disks are not so big ... and i can not
buy bigger.
2) my data is not static, so i guess the second option is better.
the high availability will be supported by the mirroring between
servers so i'm relaxed on that.
do you have recomendation were to put the SSIS, Reporting services,
tempDB ?
jocamp3@.gmail.com wrote:
> Is your database OLTP? ... if not, you can setup your server like this:
> RAID 1 (2 disks) = Os
> RAID 5 (4 disks) = Data and Log files
> If your data is not static, then ...
> RAID 1 = Os
> RAID 1 = Data Files
> RAID 1 = Log Files
> Using this last config. you won't have a high availability option like
> RAID 5 for your data but you'll have a better performance for your
> transactions and log files...
>
> Edgardo wrote:
> > If all drives are the same size and type, for fault tolerance:
> >
> > 1- Mirror of two disks for OS and SQL Server
> > 2- Create two mirrors (2 drives each) and then create a stripe with parity
> > between both mirrors (RAID 0). I will put the data and log files there.
> >
> > This way, you can have 3 failed disks (one failed disk on each mirror) and
> > the system will still be online. Also RAID 0 will give you better performance.
> >
> > Another option would be to create a RAID 5 with for the data and the files,
> > which will give you a good performance for reads (not as good for wites..)
> > and you will be having more space for storage for the data and the logs,
> > compared with the first option
> >
> > "raviv762@.gmail.com" wrote:
> >
> > >
> > > Hi,
> > >
> > > I'm using SQL 2005 with 2 identical servers
> > > I want to use Mirroring between the two.
> > > I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
> > > services)
> > >
> > > each server has 6 disks.
> > >
> > >
> > > what is the best configuration of these disks ?
> > > 3 RAID1, 1 RAID1 + RAID5 ?
> > >
> > > and where should i put things ?
> > > e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
> > >
> > >sql

disks when doing mirroirng

Disks not appearing in "My Computer"

I have a clustered environment which includes 2 nodes. The cluster
fails across fine but the only issue is the disks do not appear in My
Computer. When I connect to the disks through Windows disk management
all the disks are there.
Any ideas?
Many thanks
The clustered drives which are called resources are held by the node which is
the active one. At any point of time, only one node can hold the resources.
"Edwin vMierlo [MVP]" wrote:

> Clustered disks are only accessible on the node where they are online.
> Rgds,
> Edwin.
>
> <Joe.Mobley@.nationalexpress.com> wrote in message
> news:1178015037.826526.300420@.h2g2000hsg.googlegro ups.com...
>
>

Disks

I need additional disk space for storing my backups on SQL server 2000. Any
ideas on the latest and greatest discs I can purchase. Thanks
What disks you can buy probably depends on your hardware. Are you running
IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
provide enough storage, and are cost effective for your environment. Don't
forget about growth...you probably don't want to buy drives in another
month or two.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> I need additional disk space for storing my backups on SQL server 2000.
Any
> ideas on the latest and greatest discs I can purchase. Thanks
|||Any limits that sql server has as far as how many discs you can add? I still
have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
Thanks
"Keith Kratochvil" wrote:

> What disks you can buy probably depends on your hardware. Are you running
> IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
> provide enough storage, and are cost effective for your environment. Don't
> forget about growth...you probably don't want to buy drives in another
> month or two.
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> Any
>
|||SQL Server will use what the OS provides.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:0044BB2C-7897-4DA6-9237-AED43D7F35AE@.microsoft.com...
> Any limits that sql server has as far as how many discs you can add? I
still[vbcol=seagreen]
> have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
> Thanks
> "Keith Kratochvil" wrote:
running[vbcol=seagreen]
Don't[vbcol=seagreen]
2000.[vbcol=seagreen]

Disks

I need additional disk space for storing my backups on SQL server 2000. Any
ideas on the latest and greatest discs I can purchase. ThanksWhat disks you can buy probably depends on your hardware. Are you running
IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
provide enough storage, and are cost effective for your environment. Don't
forget about growth...you probably don't want to buy drives in another
month or two.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> I need additional disk space for storing my backups on SQL server 2000.
Any
> ideas on the latest and greatest discs I can purchase. Thanks|||Any limits that sql server has as far as how many discs you can add? I stil
l
have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
Thanks
"Keith Kratochvil" wrote:

> What disks you can buy probably depends on your hardware. Are you running
> IDE? SATA? SCSI? Buy whatever disks work with your current hardware,
> provide enough storage, and are cost effective for your environment. Don'
t
> forget about growth...you probably don't want to buy drives in another
> month or two.
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:8A8A8D80-7E98-43DA-B78C-3EC3232DB8FF@.microsoft.com...
> Any
>|||SQL Server will use what the OS provides.
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:0044BB2C-7897-4DA6-9237-AED43D7F35AE@.microsoft.com...
> Any limits that sql server has as far as how many discs you can add? I
still[vbcol=seagreen]
> have 4 slots open. We have SCSI discs some are 72.8 GB others are 36.4GB
> Thanks
> "Keith Kratochvil" wrote:
>
running[vbcol=seagreen]
Don't[vbcol=seagreen]
2000.[vbcol=seagreen]sql

订阅：博文 (Atom)

2012年3月29日星期四

Display a servers "environment"

Display a report in fullscreenmode

Display a report in a WinForm client

display a message in store procedure

Display a KPI need the same Dimension on its Value and Target?

Display a image based on a value field

Display a field onlt up to a Specific Character

Display a datagrid using the dataset as the source?

Display 2 field of database in form <select>

Display 1 piece of Data from a SQLDataSource

Display .356 as a percentage

Display <Long Text> in a table ??

Display <Long Text> in a table ??

Display <Long Text> in a table ??

Display <Long Text> in a table ??

Display "Last Run Date" in report!

Dispalying AS2005 Parent-child hierarchy with RS2005

Dispaly mask and select N-M records

dispaly data at bottom of the report by daily,weekly,monthly,SYTD

Dislpay Report Parameters selectively?

Diskspace problem running tuning advisor after server profiler?!

disks when doing mirroirng

disks when doing mirroirng

disks when doing mirroirng

Disks not appearing in "My Computer"

Disks

Disks

Display date

Blog Archive

About Me