Is there a simple way to get everything there is to get from an XmlReader?

THE TASK
Using Visual Studio .NET 2003 and SQL Server 2000, I want to create a .NET application that gets SQL Server data obtained from a SELECT query with a FOR XML clause. I have seen the solution a long time ago in the MSCD .NET book "Developing Windows-Based Applications" for 70-306 and 70-316 and I thought, this looks really simple, I don't need to try it out. Now that I need to do it I am surprised how difficult it is.

TO RUN THE EXAMPLE
The code below demonstrates the expected solution based on the book and the failure of that solution. To run this example, create a Windows Forms project, put a TextBox called textBox1 and two Buttons called button1 and button2 on the Form. Double-click each button to generate the methods that handle the click events. Replace "MySQLServer" and "MyWorkstation" with your own names. The pubs database should be present, otherwise modify the connection string and the command text as well. Compile it and click button1.

THE OUTCOME
The text in textBox1 shows four XML elements but there are eight records in the publishers database. The pub_ID values show that every second record has been omitted.

THE PROBLEM
The code should be self-explanatory, so let's look directly at the while loop and the ReadOuterXml method. That's where the problem occurs.
The framework documentation reveals a bad surprise. If the XmlReader is positioned on a node at the leaf level, ReadOuterXml behaves like Read. This means the reader advances to the next position. In combination with Read this means that the reader advances by 2 positions although the while loop has only looped once. This may or may not happen depending on whether the reader happens to be on a leaf node or node. Try to play with nested parent and child records and you will see how funny this can be.
Apparently, this means there is no easy way to reliably loop through everything.
I find this behavior of the ReadOuterXml method very disappointing especially since there seems to be no straightforward way to control this behavior. When I research the subject, I only find articles that simply say "//Do some parsing here" in the while loop. I disagree. One should not do any parsing there. One should not query the node type and then reconstruct every aspect of the XML for every theroetically possible node type and write a lot of code to that end. Instead, one should trust that SQL Server has produced correct data and go ahead and save the data to a file. Compare how well-behaved the SqlDataReader is!
I wish the XmlReader had a ReadEverythingThereIsToReadAndReturnItAsATextStream method. Is there a known and simple solution to accomplish what that method whoud do?

THE CODE
private void button1_Click(object sender, System.EventArgs e)
{
string connectionString = "data source=MySQLServer;initial catalog=pubs;integrated security=SSPI;persist security info=False;workstation id=MyWorkStation;packet size=4096";
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString);
string cmdText = "SELECT * FROM publishers FOR XML RAW";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, connection);
this.textBox1.Text = String.Empty;
connection.Open();
System.Xml.XmlReader reader = cmd.ExecuteXmlReader();
while (reader.Read())
{
this.textBox1.AppendText(reader.ReadOuterXml());
}
reader.Close();
connection.Close();
}

private void button2_Click(object sender, System.EventArgs e)
{
string filename = Application.StartupPath + System.IO.Path.DirectorySeparatorChar + "publishers.xml";
System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(filename, System.Text.Encoding.UTF8);
writer.Formatting = System.Xml.Formatting.Indented;
writer.WriteStartDocument();
writer.WriteStartElement("Publishers");
writer.WriteRaw(this.textBox1.Text);
writer.WriteEndDocument();
writer.Close();
}

If you want to write out everything the XmlReader returns then open up an XmlTextWriter and simply do xmlTextWriter.WriteNode(xmlReader, false).|||

Thank you Martin Honnen. What you wrote is useful, indeed.

HOWEVER!

I figured out a much simpler solution.

If there is no need to do any parsing on the XML that SQL Server returns, don't use an XmlReader and a while loop at all. Instead, do this:

string xmlResult = (string)cmd.ExecuteScalar();

I still think that the ReadOuterXml method (ReadInnerXml as well) should behave in a more controlled way, because as it is it's quite useless. But anyway, we have learned enough about this. Let's move on to new problems.

Is there a equivalent tool to Oracle HTML DB for SQL Server

Oracle have released a free download to enable non-developers without
application development experience to quickly build professional web
enabled applications.
The tool oracle as released for download at this URL:
http://www.oracle.com/technology/products/database/application_express/index.html
is there a similar tool for SQL Server from Microsoft. Apparently,
Oracle features even case studies where customers have rapidly built
even planning and budgetting applications with the Oracle HTML DB.
I know a much primitive tool to Oracle HTML DB was available a while
ago for SQL Server called web matrix but now that as disappeared. I am
keen to see a similar tool for SQL Server to rapidly build web
applications.
Thanks
KarenHi,
I used before CodeCharge (www.yessoftware.com) and now Adenin Solutions
(www.adenin.com).
Regards, Marco
KarenM schreef:
> Oracle have released a free download to enable non-developers without
> application development experience to quickly build professional web
> enabled applications.
> The tool oracle as released for download at this URL:
> http://www.oracle.com/technology/products/database/application_express/index.html
>
> is there a similar tool for SQL Server from Microsoft. Apparently,
> Oracle features even case studies where customers have rapidly built
> even planning and budgetting applications with the Oracle HTML DB.
> I know a much primitive tool to Oracle HTML DB was available a while
> ago for SQL Server called web matrix but now that as disappeared. I am
> keen to see a similar tool for SQL Server to rapidly build web
> applications.
> Thanks
> Karen|||Thanks for the pointers I have already looked at the Visual web express
but still it needs coding. If you look at the Oracle Express I got a
evaluation userid and uploaded some of my spreadsheet databases I
maintain my catalog of DVDs, Music CDs and books into the Oracle
database without one line of coding and now I can securely sign on to
this web site and maintain all my information not only that it as all
fancy reporting components built in like gauge, charts,etc all from a
web browser user interface. All this does not need even one line of
coding. I tried it myself.
The development tools themselves are all web based. Oracle is pitching
it at companies to get rid of Access and Excel databases and store data
in a central & secure location with the Oracle Application Express. I
want to do the same with SQL Server provide tools that empower the end
users to setup their own applications all based on the web. This will
make it attractive for users maintaining Access databases and
spreadsheets causing all kinds of chaos to move into a centralised
managed environment but still have all the flexibility they wanted.
Cheers
Karen|||Hi,
I know Oracle is pushing Portals and use it as one frontend for all
your business needs.
But if you are using Word, Excel you want one platform where you can
store all your information structured and non structured. With WebDav
this nis very easy just save your word doc and it is automatic in the
folder in your portal. Can this be more easy no upload just works as
you used before and look at the great Application Builder. It is even
easier than Access to make solution and automatic webbased, incl.
reporting!
Demo:
http://demo.dynamicintranet.com/adenin/diHome.asp
Register for your free trial:
http://demo.dynamicintranet.com/adenin/diHome.asp
Regards, Marco
www.gmsbv.nl - your information worker company !
KarenM schreef:
> Thanks for the pointers I have already looked at the Visual web express
> but still it needs coding. If you look at the Oracle Express I got a
> evaluation userid and uploaded some of my spreadsheet databases I
> maintain my catalog of DVDs, Music CDs and books into the Oracle
> database without one line of coding and now I can securely sign on to
> this web site and maintain all my information not only that it as all
> fancy reporting components built in like gauge, charts,etc all from a
> web browser user interface. All this does not need even one line of
> coding. I tried it myself.
> The development tools themselves are all web based. Oracle is pitching
> it at companies to get rid of Access and Excel databases and store data
> in a central & secure location with the Oracle Application Express. I
> want to do the same with SQL Server provide tools that empower the end
> users to setup their own applications all based on the web. This will
> make it attractive for users maintaining Access databases and
> spreadsheets causing all kinds of chaos to move into a centralised
> managed environment but still have all the flexibility they wanted.
> Cheers
> Karen|||Marco
Today IT managers are trying to reduce the number of vendors Microsoft,
Oracle
and IBM are the shortlist of the software vendors. We want a solution
for
SQL from Microsoft besides we do not want to use Access and Excel to
store data
if it is structured data it must reside in SQL and have a good web
based
tool to build data capture and reporting on it which end users can do
it. I
would say Microsoft must even extend this to Analysis Services to be
able to
store data into Analysis Services and do reporting of analysis Services
all from a web frontend. To me it does not sound rocket science Oracle
have
already built the web application express which end users or business
analysts
can customise and deploy a enterprise wide solution.
What I am referring to in the Oracle Application Express is a great
simple
and very effective web enablement solution for the relational database
it almost
does the same thing what Access provides a simple mechanim to capture
and report
on data except unlike Access it does not have scalability, security &
deployment
issues. With companies running SQL Server extensively I was wondering
if there is
a similar tool like Oracle application express for SQL Server the
Oracle app express
as everything to build small or large transaction/data capture systems
and report
on the data and secure the application and still leave the data on a
secure
backend systems than having spreadsheets and access databases all over
the place.
Appears so far I have not heard that such a similar tool exists for SQL
Server
perhaps we will wait until Microsoft builds a similar SQL Server Web
Application
Express or something like that :)-
Thanks
Karen
Marco wrote:
> Hi,
> I know Oracle is pushing Portals and use it as one frontend for all
> your business needs.
> But if you are using Word, Excel you want one platform where you can
> store all your information structured and non structured. With WebDav
> this nis very easy just save your word doc and it is automatic in the
> folder in your portal. Can this be more easy no upload just works as
> you used before and look at the great Application Builder. It is even
> easier than Access to make solution and automatic webbased, incl.
> reporting!
> Demo:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Register for your free trial:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Regards, Marco
> www.gmsbv.nl - your information worker company !
> KarenM schreef:
> > Thanks for the pointers I have already looked at the Visual web express
> > but still it needs coding. If you look at the Oracle Express I got a
> > evaluation userid and uploaded some of my spreadsheet databases I
> > maintain my catalog of DVDs, Music CDs and books into the Oracle
> > database without one line of coding and now I can securely sign on to
> > this web site and maintain all my information not only that it as all
> > fancy reporting components built in like gauge, charts,etc all from a
> > web browser user interface. All this does not need even one line of
> > coding. I tried it myself.
> >
> > The development tools themselves are all web based. Oracle is pitching
> > it at companies to get rid of Access and Excel databases and store data
> > in a central & secure location with the Oracle Application Express. I
> > want to do the same with SQL Server provide tools that empower the end
> > users to setup their own applications all based on the web. This will
> > make it attractive for users maintaining Access databases and
> > spreadsheets causing all kinds of chaos to move into a centralised
> > managed environment but still have all the flexibility they wanted.
> >
> > Cheers
> > Karensql

Is the workgroup edition suitable for a web application?

Hi,
well, the title says it all already. Are there any technical
limitations that could prevent using the WG edition with asp.net?
Oh, and are there licensing limitations (is it even allowed to run the
WG edition in a web server environment) ?Hi,
Here, you can find info about SQL Server 2005 Workgroup Edition:
http://www.microsoft.com/sql/editions/workgroup/default.mspx
Here, you can find info about SQL Server 2005 Edition comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Ekrem Önsoy
<PSiegmann@.mail.nu> wrote in message
news:1188925296.970273.139890@.50g2000hsm.googlegroups.com...
> Hi,
> well, the title says it all already. Are there any technical
> limitations that could prevent using the WG edition with asp.net?
> Oh, and are there licensing limitations (is it even allowed to run the
> WG edition in a web server environment) ?
>

Is the RDA "PULL" slower in SQL Mobile vs. SQL CE 2.0?

I have a CF application I'm porting from VS2003/SQL CE 2.0 to VS2005/SQL Mobile. I make extensive use of RDA and unfortunately there is a huge performance degredation for me going to SQL Mobile. Where most PULL's in 2.0 take no more than a second or 2 to complete, they are taking around 10 or 11 seconds in SQL Mobile. This is the time from when .PULL starts and ends, it does not include any code run before or after the .PULL is issued, so it definitely something during the PULL that is slower.

I have tried settins of 0,1,3, and 6 for the compression level, all gave similar results, around 10 or 11 seconds. I have also tried doing a .SubmitSQL right before the .PULL to see if a sort of cached connection would help, but it only shaved a second off the time in most cases.

These times are using the same IIS server, SQL server (2000 SP3a), and database. I have tried using a 2003 SE device, WM 5.0 device, WM 5.0 emulator, and 2003 SE emulator, all exhibit the same performance degradation.

I really need to figure this out or I can't move the product to 2005 as the synchronization times would be completely unacceptable to our customers. Has anyone else run into this problem or know of a solution to it?

Thanks!

-Manny

Well, I managed to get the time down. After looking at both versions doing Pull's via SQL Trace, I discovered that the time to begin and to execute the things that happen on SQL server was pretty much the same for both, but the difference came after SQL Mobile was done using SQL Server...there was about an 8 or second lag between finishing the database access and the Pull command completing.

I discovered through the SQL Mobile Books Online that SQL Mobile now has logging that can be enabled through the registry. I tried that and then looked at the resulting log and discovered this happening after it was done accessing SQL Server:

2007/01/05 11:36:09 Thread=13BC RSCB=173 Command=CLOS Hr=00000000 Total Uncompressed bytes out = 249
2007/01/05 11:36:12 Thread=13BC RSCB=173 Command=CLOS Hr=80070005 ERR:DeleteFile failed 0
2007/01/05 11:36:15 Thread=13BC RSCB=173 Command=CLOS Hr=80070005 ERR:DeleteFile failed 0

If you look at the times, you'll see that the 2 errors account for about 6 seconds.

I managed to eliminate those errors by setting full control to the Internet Guest user for the windows directory that sqlce30.dll is in. After that fix, my Pulls are now taking around 4 or 5 seconds rather than 10 or 11, about 6 seconds faster!

I'm still not quite at the speed of 2.0, though. I synchronize 70 tables and in 2.0, this is taking around 3 minutes. In 3.0 it's now taking around 4.5 minutes. Still much better than the 13 or so minutes it was taking!

Any ideas how I can squeeze the last 2 seconds out so it's equivalent to the 2.0 version?

Is that possible with RS?

Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web application.
The way I'd like it to work is to click a button and launch a page with the
report. I have stored procedures that the reports would use and I'd like to
manually fill a dataset and assign it to the report.
Is that possible?
All examples I see create a report project, a datasource, and the report.
If I do that, first I have to use a dataset for each report, and I can't use
that reports in the web project.
--
Regards,
Diego F.VS 2005 has report controls for both win and web forms. You can use them in
local mode where you give it a report and the dataset. However it is
definitely more work to use them in local mode. If you already have stored
procedure then create a report that uses the stored procedures. Test and
make sure you like it. Then if possible (VB.Net pro is the cheapest version
that has the controls I believe) get the new controls for your app. With the
new controls it is very easy to embed in your application, set the
parameters and away you go.
Otherwise, look at URL integration to call the report from your app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web application.
> The way I'd like it to work is to click a button and launch a page with
> the report. I have stored procedures that the reports would use and I'd
> like to manually fill a dataset and assign it to the report.
> Is that possible?
> All examples I see create a report project, a datasource, and the report.
> If I do that, first I have to use a dataset for each report, and I can't
> use that reports in the web project.
> --
> Regards,
> Diego F.
>
>|||I tried creating a report in a report project, with my stored procedures.
But then, I have problems with deployment; it's unable to connect with the
server. I created a site in the server, but if I put
http://server:port/reportserver/reports in the report project properties,
and the conexion isn't possible.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
> VS 2005 has report controls for both win and web forms. You can use them
> in local mode where you give it a report and the dataset. However it is
> definitely more work to use them in local mode. If you already have stored
> procedure then create a report that uses the stored procedures. Test and
> make sure you like it. Then if possible (VB.Net pro is the cheapest
> version that has the controls I believe) get the new controls for your
> app. With the new controls it is very easy to embed in your application,
> set the parameters and away you go.
> Otherwise, look at URL integration to call the report from your app.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>|||I'm confused. Have your successfully deployed the report? Can you view the
report with Report Manager? Those two things need to happen before you try
to integrate with your app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>I tried creating a report in a report project, with my stored procedures.
>But then, I have problems with deployment; it's unable to connect with the
>server. I created a site in the server, but if I put
>http://server:port/reportserver/reports in the report project properties,
>and the conexion isn't possible.
> --
> Regards,
> Diego F.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>|||You don't have to deploy the report from your dev box. Just copy the RDL
file to somewhere where you can add it to your Report Manager site, and add
it to Report Manager by clicking the Upload file button.
You might have to create data sources manually, just click on New Data
Source button. Connect the report to the datasource and test it.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>I tried creating a report in a report project, with my stored procedures.
>But then, I have problems with deployment; it's unable to connect with the
>server. I created a site in the server, but if I put
>http://server:port/reportserver/reports in the report project properties,
>and the conexion isn't possible.
> --
> Regards,
> Diego F.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I'm starting to understand it. My first problem is that I can't see the
Report Manager. Where should I configure it?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
> You don't have to deploy the report from your dev box. Just copy the RDL
> file to somewhere where you can add it to your Report Manager site, and
> add it to Report Manager by clicking the Upload file button.
> You might have to create data sources manually, just click on New Data
> Source button. Connect the report to the datasource and test it.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored procedures.
>>But then, I have problems with deployment; it's unable to connect with the
>>server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project properties,
>>and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||Assuming it has been installed correctly on a web server, you should be able
to access Report manager at
http://yourwebserver/reports
Also, check for http://yourwebserver/reportserver/
If these websites are unavailable, you need to check what actually got
installed on the server.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
> I'm starting to understand it. My first problem is that I can't see the
> Report Manager. Where should I configure it?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the RDL
>> file to somewhere where you can add it to your Report Manager site, and
>> add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored procedures.
>>But then, I have problems with deployment; it's unable to connect with
>>the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project properties,
>>and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset. However
>> it is definitely more work to use them in local mode. If you already
>> have stored procedure then create a report that uses the stored
>> procedures. Test and make sure you like it. Then if possible (VB.Net
>> pro is the cheapest version that has the controls I believe) get the
>> new controls for your app. With the new controls it is very easy to
>> embed in your application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page
>> with the report. I have stored procedures that the reports would use
>> and I'd like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||The problem is that if I write that URL, what I see is the list of
directories in both cases. Shouldn't I see an application?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Assuming it has been installed correctly on a web server, you should be
> able to access Report manager at
> http://yourwebserver/reports
> Also, check for http://yourwebserver/reportserver/
> If these websites are unavailable, you need to check what actually got
> installed on the server.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>> I'm starting to understand it. My first problem is that I can't see the
>> Report Manager. Where should I configure it?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the RDL
>> file to somewhere where you can add it to your Report Manager site, and
>> add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored
>>procedures. But then, I have problems with deployment; it's unable to
>>connect with the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project
>>properties, and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset. However
>> it is definitely more work to use them in local mode. If you already
>> have stored procedure then create a report that uses the stored
>> procedures. Test and make sure you like it. Then if possible (VB.Net
>> pro is the cheapest version that has the controls I believe) get the
>> new controls for your app. With the new controls it is very easy to
>> embed in your application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page
>> with the report. I have stored procedures that the reports would use
>> and I'd like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>>
>|||No, the Report Manager is an application, but you won't see it as a sort of
program. Report Manager displays reports with descriptions and some details
in a nice user interface, the ReportServer displays some details in plain
text.
If you do get to see the directories, try uploading a report by pressing the
Upload file button in http://yourserver/reports/
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23lUPWAcFGHA.3900@.TK2MSFTNGP10.phx.gbl...
> The problem is that if I write that URL, what I see is the list of
> directories in both cases. Shouldn't I see an application?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
>> Assuming it has been installed correctly on a web server, you should be
>> able to access Report manager at
>> http://yourwebserver/reports
>> Also, check for http://yourwebserver/reportserver/
>> If these websites are unavailable, you need to check what actually got
>> installed on the server.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>> I'm starting to understand it. My first problem is that I can't see the
>> Report Manager. Where should I configure it?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the
>> RDL file to somewhere where you can add it to your Report Manager site,
>> and add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored
>>procedures. But then, I have problems with deployment; it's unable to
>>connect with the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project
>>properties, and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset.
>> However it is definitely more work to use them in local mode. If you
>> already have stored procedure then create a report that uses the
>> stored procedures. Test and make sure you like it. Then if possible
>> (VB.Net pro is the cheapest version that has the controls I believe)
>> get the new controls for your app. With the new controls it is very
>> easy to embed in your application, set the parameters and away you
>> go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>>> application.
>>>
>>> The way I'd like it to work is to click a button and launch a page
>>> with the report. I have stored procedures that the reports would use
>>> and I'd like to manually fill a dataset and assign it to the report.
>>>
>>> Is that possible?
>>>
>>> All examples I see create a report project, a datasource, and the
>>> report.
>>>
>>> If I do that, first I have to use a dataset for each report, and I
>>> can't use that reports in the web project.
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||I thought that I would interject here a little.
We are using SQL Server 2000 / Reporting Services 2000 both on 1.1
framework. Our web server and web development platform is 2.0 framwork with
the web dev being done on vs 2005.
By far the easiest setup we've had so far is to setup the reports on report
server, publish a url. Then populate a table with two fields; report
discritpion and url field.
From that we have setup a navigation component from the web server and
linked it to the url table.
What this does is break the dev of reports and the web interface apart so
that they can be managed more effectively. As soon as the SQL dev produces a
new report or a change he populates the table with the new info and it is
immediately on the web site for consumers to view.
Ken...
"Kaisa M. Lindahl" wrote:
> No, the Report Manager is an application, but you won't see it as a sort of
> program. Report Manager displays reports with descriptions and some details
> in a nice user interface, the ReportServer displays some details in plain
> text.
> If you do get to see the directories, try uploading a report by pressing the
> Upload file button in http://yourserver/reports/
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23lUPWAcFGHA.3900@.TK2MSFTNGP10.phx.gbl...
> > The problem is that if I write that URL, what I see is the list of
> > directories in both cases. Shouldn't I see an application?
> >
> > --
> > Regards,
> >
> > Diego F.
> >
> >
> > "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> > news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
> >> Assuming it has been installed correctly on a web server, you should be
> >> able to access Report manager at
> >>
> >> http://yourwebserver/reports
> >>
> >> Also, check for http://yourwebserver/reportserver/
> >>
> >> If these websites are unavailable, you need to check what actually got
> >> installed on the server.
> >>
> >> Kaisa M. Lindahl
> >>
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
> >> I'm starting to understand it. My first problem is that I can't see the
> >> Report Manager. Where should I configure it?
> >>
> >> --
> >> Regards,
> >>
> >> Diego F.
> >>
> >>
> >> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> >> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
> >> You don't have to deploy the report from your dev box. Just copy the
> >> RDL file to somewhere where you can add it to your Report Manager site,
> >> and add it to Report Manager by clicking the Upload file button.
> >> You might have to create data sources manually, just click on New Data
> >> Source button. Connect the report to the datasource and test it.
> >>
> >> Kaisa M. Lindahl
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> >>I tried creating a report in a report project, with my stored
> >>procedures. But then, I have problems with deployment; it's unable to
> >>connect with the server. I created a site in the server, but if I put
> >>http://server:port/reportserver/reports in the report project
> >>properties, and the conexion isn't possible.
> >>
> >> --
> >> Regards,
> >>
> >> Diego F.
> >>
> >>
> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> >> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
> >> VS 2005 has report controls for both win and web forms. You can use
> >> them in local mode where you give it a report and the dataset.
> >> However it is definitely more work to use them in local mode. If you
> >> already have stored procedure then create a report that uses the
> >> stored procedures. Test and make sure you like it. Then if possible
> >> (VB.Net pro is the cheapest version that has the controls I believe)
> >> get the new controls for your app. With the new controls it is very
> >> easy to embed in your application, set the parameters and away you
> >> go.
> >>
> >> Otherwise, look at URL integration to call the report from your app.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> >>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
> >>> application.
> >>>
> >>> The way I'd like it to work is to click a button and launch a page
> >>> with the report. I have stored procedures that the reports would use
> >>> and I'd like to manually fill a dataset and assign it to the report.
> >>>
> >>> Is that possible?
> >>>
> >>> All examples I see create a report project, a datasource, and the
> >>> report.
> >>>
> >>> If I do that, first I have to use a dataset for each report, and I
> >>> can't use that reports in the web project.
> >>>
> >>> --
> >>> Regards,
> >>>
> >>> Diego F.
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>sql

Is SqlTransaction overhead ?

hi,

Is it over head to use SqlTransaction(begin, commit, rollback) for a single transaction.

am not using application block or enterprise library.

only a single insert statement.

Yes, SQL Transactions are an overhead to SQL Server whether you are writing a single query or a batch of queries, but on the other side you are rest assured that in case of any errors you can always rollback the transaction and on successful execution only you will commit transaction.

Have a look at Trasactions in SQL BOL.

Hope this will help.

|||

hi

i dont think that using the sqlTransaction causes any overhead ...

regards,

Is SQL Server CE really the solution?

Hi,

So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:

1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)

2- Create/access "local"/"Single-User" files for processing purposes. (try to minimize network trafic...)

So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach?

1- What SQL version to use for "multi-user" databases?

2- What SQL version to use for "single-user" databases/files?

3- Can SQL Express allow me to achieve both "multi-user" and "single-user" approaches within same app? If not, what would you rather suggest?

Thanks in advance,

Stphane

I include a long discussion of the architectural best practices in both of my new books that include the SQL Server Compact Edition as well as the other SQL Server SKUs.

SQL Server Compact Edition is clearly not a multi-used database--unless you consider using it as a replication subscriber-based DBMS. While this is certainly a way to share data between multiple users, it's not a "multiuser" database in the traditional sense. It's best use is as a single-user data repository--even in applications that connect to a shared database.

SQL Server Express and similar SKUs can be used as a single-user database but it might (just might) be overkill for some situations. Yes, SQL Server Express edition can be used in an application that serves one or many users. As I describe in my books (in great detail), if you intend to take this approach, both applications need to be built as "multiuser" to reduce development and support costs.

See www.hitchhikerguides.net for more information.

hth

|||

Hi,

First, many thanks for replying. I really appreciate. I was aware that SQL CE was not a "multi-users" database. As a reminder, the approach I'm looking for is to have:

1- tables found at a specific network location which are shared by several users at the same time. (where I thought using SQL Express...)

2- tables, owned by single/specific user, which could be localized either on network (especially when centralized backups are an issue) as well as locally. These tables are especially used for queries and calculations required by the user so there is no need to have them "shareable". (where I "first" thought using SQL CE...)

Considering this scenario, after reading all articles I could find on subject, I really scratched my head wondering if using SQL CE in this context would effectively complicate things for nothing, that I could rather simply use SQL Express for both multi-user tables as well as single-user tables at the same time. You seem to say yes.

Now, when you add "...but it might (just might) be overkill for some situations", I'm not too familiar with this "overkill" expression. Can you elaborate a little more about this point?

Accordingly, for my "single user" access needs. With Clarion (ref. SoftVelocity), I used to have in this case directories, one for each user, where I could find any single table needed for processing. In fact, each filename could be specified from within application including appropriate directory path. Now with SQL Express, how can I integrate this same scenario? Will/can I create many occurences of same "single-user" database, one per user, but each one localized at a different physical place? Would certainly like to have your opinion on this...

A last point. Many times, over past years, I had to support people over the phone. I would certainly appreciate to still be able to install any new version of application "off-site" by instructing users over the phone, after sending them everything they need over the Net, method I oftenly used so far with other programming platforms. But... I'm still wondering how I can manage this way any SQL table layout modifications... Let me explain by a concrete example.

Again with Clarion, platform I've used now for many years, I could integrate in my application a "filer" utility wich could compare version of files/tables directly on site and "re-structure" them accordingly if file/table layout was not up to date.

Now, with SQL Express/SQL CE, what is the process involved when my "new" application is now using any table's version which layout is now "newer/different" from the one within actual database thus requiring any re-structuring process? Any tools I must acquire and combine with my application or must this re-structuring process absolutely be done manually on site (like I had no choice to do for any Oracle tables)? Your opinion?

Thanks again,

Stphane

|||

1- tables found at a specific network location which are shared by several users at the same time. (where I thought using SQL Express...)

Yes, SQL Express makes a lot of sense here but you might want to upgrade to Workgroup instead for reasons I'm about to explain.|||

Hi again,

Really appreciate your time. I read carefully your reply and would like to bring a few more things:

"In this case keeping user-specific tables stored in SQLCe might make sense if the application is run without a network connection at all at some time(s)."

Must I understand that I can't have an app using both SQL Express, for accessing "network" tables, and SQL CE, for accessing "local" tables, at the same time?

"Since you're depending on a shared database connection to SQL Express anyway, I would probably keep the user-specific data in the central SQL Express DB with a UserID as a secondary key"

I agree with this kind of structure. My only concerns are if I have, as an example, over a hundred of users running simultaneously reports then generating a lot of data (scenario I've already seen in the past on a tuesday afternoon after administration and production woke up...), won't I face a performance issue taking into account that this kind of data management generates a lot of insert/update/delete statements on same tables, a lot of network traffic in a short period of time? This kind of situation made me decide to go for localized resources which improved a lot the time response for all users. Your opinion?

"Yes, you could cache this on the client with SQLCe to improve startup performance"

I lost you on this one. I'm not sure to understand what you suggest to cache at startup?

"Another approach would be to let the Workgroup Edition publish some or all of this data..."

I took a few minutes and got on Microsoft's website to get some more infos on SQL Server 2005 Workgroup Edition. Seems in fact to be the appropriate tool. Unfortunately, if I'm targetting small/medium businesses as well, I'm quite sure that some customers will tell me to find something less expensive... (Please don't laugh. It's unfortunately true as I had to face this situation many times...) Any other reliable but cheaper approach?

BTW, thanks for taking time to explain the term "overkill". This is not an expression we use around here ;)

"When using a replication architecture, the schema is also propagated to the clients"

Any articles I could read on this replication process? I've never found/read anything on the subject so far... Are your books giving a detailed explanation on this subject? This issue is very important for me as I have to do it most of the times when people are asking for new features.

A last point, your books. BTW, I'm developping using VC++2005 (C++/CLI). I must admit that I'm quite worrying about not being able to find more reliable examples in C++ when I search MSDN or any other related resources, books. I can always convert from C# examples which are not that different but really have a hard time to find my way out with VB examples. In the books you mentionned, what is the language used for the examples?

Having discussed with many persons on this last issue so far, I can't keep asking myself why there is still so few resources available for C++... So much for C# and VB... People, even from Microsoft, told me many times that C++ was here to stay. But... why leaving us, especially when learning, with so few?

Thanks again for your help.

Stphane

|||

Must I understand that I can't have an app using both SQL Express, for accessing "network" tables, and SQL CE, for accessing "local" tables, at the same time?

Sure you can. It's a perfectly viable alternative. I discuss this strategy in the books. I think using SQLCe to store client-specific data or ever-morphing business rules in a local data cache (like SQLCe) makes a lot of sense. This way the application can come up (without having to connect to the server), process data and close down without having to connect at all. Using the SQLCe engine to buffer data that's eventually replicated up to the server also makes sense in some situations. That's what the SQL Mobile/SQLCe engine was designed to do.|||

Hi again,

Where are you that you have never heard of "overkill"? Cleveland?

I'm simply from nearly Montral, in Qubec Canada. Even if I work with English people on a daily basis, it is an expression I didn't hear quite often let's say.

"It's not the language that you use to ask the question that affects the answer--it's the question itself."

You can't hit the target better than that! How true it is!

I will definitely look forward reading your books/ebooks. Thanks again for your support. Again really appreciated.

Case closed for me!

Stphane

|||I (think) I'm speaking in Montreal in May. DevTeach? Look me up then and we can see how well you were able to implement your design.|||

Hi again,

Many thanks for this invitation. Very nice of you. I really hope I will be able to attend DevTeach.

Maybe a little question concerning install of CE. The version I have installed on my machine was done from files downloaded on Dec 15th 2006, which I think was the RC1 version. I noticed while reading this friday issue of "Microsoft Download Notifications" that there seemed to be new versions of CE available for download. I followed links supplied:

SQL Server 2005 Compact Edition:

http://www.microsoft.com/downloads/details.aspx?familyid=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&mg_id=10096&displaylang=en

SQL Server 2005 Compact Edition Tools for VS2005 SP1

http://www.microsoft.com/downloads/details.aspx?familyid=877C0ADC-0347-4A47-B842-58FB71D159AC&mg_id=10096&displaylang=en

SQL Server 2005 Compact Edition Books Online

http://www.microsoft.com/downloads/details.aspx?familyid=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en

and downloaded corresponding files but didn't install anything yet. I would have some questions:

1- Is the version obtained from those links the final version of CE?

2- As mentionned, considering that RC1 downloaded on Dec 15th is the version actually installed on my machine, should I uninstall everything before install these new files downloaded today.

3- Considering finally that VS2005 has been upgraded to SP1 on same machine, am I right thinking that I must also install "SQL Server 2005 Compact Edition Tools for VS2005 SP1" or is this already include in "SQL Server 2005 Compact Edition" version I downloaded?

Thanks again for your help, really appreciated.

Stphane

|||

1) The "official" announcment won't come until (at least) Monday. It should detail what's been exposed. I ended up uninstalling VS (completely) and reinstalling VS, SP1 and then the new SDK. I don't think the BOL has changed since the last drop, but I expect there will be further updates. In my opinion (and that of some others), it's pretty thin. That's why I wrote the EBook...

2) I did.

3) BHOM (Beats the Heck Out of Me)... ;) dunno. When I went into VS, after installing the new bits and did see the data providers had been renamed but the SQL Server Management Studio bits don't seem to have caught up. They still refer to the provider as "SQL Mobile".

perhaps we'll hear more next week.

|||

Hi again,

Didn't think you would be online today ;-). Glad to hear from you! As a conclusion to what you wrote, I really think that it would be smarter to wait for upcoming events.

"The "official" announcment won't come until (at least) Monday"

Is there any special website which would be the best source for any news or big titles coming from Microsoft especially for what may concern VS2005? I must admit that for CE, as an example, I browsed throught several websites in order to make my mind about what was really going on. Still no infos on that final version except the bits and bytes I can catch here and there on the Net...

I could understand that you had to reinstall VS. Is this a required step when uninstalling CE?

Must I understand that when upgrading from CE RC1 to CE final, I would probably have to face this reinstall? Yak!!!

BTW, should we receive any announcements or notice from Microsoft when SQL CE would be really at its final version and fully ready for download?

Thanks again,

Stphane

|||"Must I understand that when upgrading from CE RC1 to CE final, I would probably have to face this reinstall? Yak!!!"

I just uninstalled RC1 then installed final - no problem
|||

Hi Brian,

I understand that you had to uninstall RC1. After uninstall was completed, did you encounter any problem with VS2005 like William seems to highlight forcing you to reinstall anything?

(recall of William's reply: "I ended up uninstalling VS (completely) and reinstalling VS, SP1")

I ask you this question because I've myself seen this kind of scenario so many times in the past with many softwares unfortunately...

I presume you are using VS 2005 SP1. What install sequence would you recommend? Is the following one OK?

1. Uninstall SQL Server 2005 CE RC1 and any corresponding BOL installed.

2. Restart computer

3. Install SQL Server 2005 Compact Edition:

http://www.microsoft.com/downloads/details.aspx?familyid=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&mg_id=10096&displaylang=en

4. Install SQL Server 2005 Compact Edition Tools for VS2005 SP1

http://www.microsoft.com/downloads/details.aspx?familyid=877C0ADC-0347-4A47-B842-58FB71D159AC&mg_id=10096&displaylang=en

Note: as I already mentionned in earlier post of this thread, is this step required if I'm using VS2005 SP1 or is this install already included in package downloaded from link specified in step 3.

5. Install SQL Server CE BOL

http://www.microsoft.com/downloads/details.aspx?familyid=E6BC81E8-175B-46EA-86A0-C9DACAA84C85&displaylang=en

Thanks for sharing,

Stphane

|||

Hi Stephane:

Your order of installation is incorrect.

The correct order of installation is in the Overview section on the SQL Server 2005 Compact Edition Tools for VS2005 SP1 page at

http://www.microsoft.com/downloads/details.aspx?familyid=877C0ADC-0347-4A47-B842-58FB71D159AC&mg_id=10096&displaylang=en

Robert Wishlaw

|||

Hi Robert,

Many thanks for follow-up and highlighting my mistakes. I followed link you supplied and concluded for what I could read, that install sequence should rather be the following:

1. Uninstall SQL Server 2005 CE RC1 and any corresponding BOL installed.

2. Restart computer

3. Install SQL Server 2005 Compact Edition Tools for VS2005 SP1

4. Install SQL Server 2005 Compact Edition:

5. Install SQL Server CE BOL

Is it OK now?

Also any established facts about the possibility of corrupting VS 2005 SP1 when uninstalling SQL 2005 CE?

Many thanks again for your help,

Stphane

Is Sql Mobile a generic database engine?

Hi,

I am about to write an application of the Pocket PC 2003 SE. I plan on using CF2.0 and VS 2005. The application will need to store several different peices of information, I immediately thought of using a database.

I have read somewhere that Sql Mobile 05 will only allow databases on the device via replication with Sql 2005. I don't want to use replication. I just want to store several diffent peices of information for use with my mobile app.

Would Sql mobile be suitable or should I stick to something like persisted ADO Data tables?

Thanks for your help

GrahamWell, so far it seems to be!

I created a CF2.0 PPC 2003 project and inserted a Sql Mobile database. I could then define tables and insert data from the mobile app at runtime.
Graham|||

The answer to your question in the subject is yes.

There are few things to keep in mind. SQL Server 2005 Mobile or it's earlier version SQL Server CE have simpler engine and thus have simpler set of features and somewhat more restrictions.

E.g. a recent post on this forum was about using semicolon to separate statements. It is not strictly required on full version but it is on Mobile.

You can find some additional information here

http://msdn.microsoft.com/SQL/2005/mobile/default.aspx

and by searching MSDN for SQL Mobile specific topics. You can also download Books Online only for SQL Server 2005 and search there. Check this URL (it is referred from the general SQL Server page):

http://www.microsoft.com/downloads/details.aspx?FamilyId=ADC75E35-7245-4038-9B8A-B8FABAEC16DA&displaylang=en

In addition to that – may be a useful feature in the development – if you have SQL Server 2005 (not Mobile version) Management Studio installed, you can create a SQL Server Mobile database (select SQL Server Mobile in server types when connecting in Object Explorer). It may help you to “play with” queries, syntax, etc. It is very likely that you can do the same from VS2005. I haven’t tried that myself.

Regards,
Boris.

|||Yet another URL of interest:

http://www.microsoft.com/sql/ce/productinfo/SQLMobile.mspx

Is SQL 2000 better than 7?

We are using SQL 7 and Forte application and Win NT. I
have migrated DB to SQL 2000 and new Windows 2000 server.
Our DB is big, 150 G. Testing on new 2000 server, I see
that many of our procedures are running slower. One
procedure is like not running. Taking all resources and
hanging. I can ont even see the exec plan. I have tried
set plan still not working. This particular procedure is
using multiple unions and one of them using self join.
I have other procedures they are not that compecated but
the are slow too. I am having hard time convincing my boss
that SQL 2000 is better than 7. We really don't see any.
On top of that some procedure are not working at all.
Please send me your expert opinion.
Hello Aziz,
If my statement will work that here you go "SQL Server 2000 is far better
than SQL Server 7.0" :-)
I hope you have rebuilt all the indexes and updated statistics for all the
databases.
HTH
Saleem@.sqlnt.com
"Aziz Karim" wrote:

> We are using SQL 7 and Forte application and Win NT. I
> have migrated DB to SQL 2000 and new Windows 2000 server.
> Our DB is big, 150 G. Testing on new 2000 server, I see
> that many of our procedures are running slower. One
> procedure is like not running. Taking all resources and
> hanging. I can ont even see the exec plan. I have tried
> set plan still not working. This particular procedure is
> using multiple unions and one of them using self join.
> I have other procedures they are not that compecated but
> the are slow too. I am having hard time convincing my boss
> that SQL 2000 is better than 7. We really don't see any.
> On top of that some procedure are not working at all.
> Please send me your expert opinion.
>
|||Update statistics with FULLSCAN on all indexes. Also, using the Profiler,
check for lock escalation events. If you see a lot, then you may have to
tune some queries.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote in message
news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
We are using SQL 7 and Forte application and Win NT. I
have migrated DB to SQL 2000 and new Windows 2000 server.
Our DB is big, 150 G. Testing on new 2000 server, I see
that many of our procedures are running slower. One
procedure is like not running. Taking all resources and
hanging. I can ont even see the exec plan. I have tried
set plan still not working. This particular procedure is
using multiple unions and one of them using self join.
I have other procedures they are not that compecated but
the are slow too. I am having hard time convincing my boss
that SQL 2000 is better than 7. We really don't see any.
On top of that some procedure are not working at all.
Please send me your expert opinion.
|||Thank you for your reply.
Tom, I tried again now with FULLSCAN. Same thing. I don't
think I will be able to use Profiler. I can not see the
exec paln since this query never finish. It is using a
table with 186 mil rows. With SQL server 7 no problem.

>--Original Message--
>Update statistics with FULLSCAN on all indexes. Also,
using the Profiler,
>check for lock escalation events. If you see a lot, then
you may have to
>tune some queries.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
in message
>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>We are using SQL 7 and Forte application and Win NT. I
>have migrated DB to SQL 2000 and new Windows 2000 server.
>Our DB is big, 150 G. Testing on new 2000 server, I see
>that many of our procedures are running slower. One
>procedure is like not running. Taking all resources and
>hanging. I can ont even see the exec plan. I have tried
>set plan still not working. This particular procedure is
>using multiple unions and one of them using self join.
>I have other procedures they are not that compecated but
>the are slow too. I am having hard time convincing my boss
>that SQL 2000 is better than 7. We really don't see any.
>On top of that some procedure are not working at all.
>Please send me your expert opinion.
>.
>
|||You can trace the lock escalation event, even if the statement does not
complete. Also, you can trace the SQL:BatchStarting event. That way, you
can see which statement is slow.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Aziz" <anonymous@.discussions.microsoft.com> wrote in message
news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
Thank you for your reply.
Tom, I tried again now with FULLSCAN. Same thing. I don't
think I will be able to use Profiler. I can not see the
exec paln since this query never finish. It is using a
table with 186 mil rows. With SQL server 7 no problem.

>--Original Message--
>Update statistics with FULLSCAN on all indexes. Also,
using the Profiler,
>check for lock escalation events. If you see a lot, then
you may have to
>tune some queries.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
in message
>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>We are using SQL 7 and Forte application and Win NT. I
>have migrated DB to SQL 2000 and new Windows 2000 server.
>Our DB is big, 150 G. Testing on new 2000 server, I see
>that many of our procedures are running slower. One
>procedure is like not running. Taking all resources and
>hanging. I can ont even see the exec plan. I have tried
>set plan still not working. This particular procedure is
>using multiple unions and one of them using self join.
>I have other procedures they are not that compecated but
>the are slow too. I am having hard time convincing my boss
>that SQL 2000 is better than 7. We really don't see any.
>On top of that some procedure are not working at all.
>Please send me your expert opinion.
>.
>
|||Tom Moreau wrote:
> You can trace the lock escalation event, even if the statement does
> not complete. Also, you can trace the SQL:BatchStarting event. That
> way, you can see which statement is slow.
>
You can also add SQL:StmtStarting and SP:StmtStarting to nail it down
even further. You can also run an estimated execution plan from Query
Analyzer and see if anything stands out without executing the query.
David G.
|||I know which statement is slow. I think SQL 2000 using
different path than 7 for this query. Do I have to fine
tune all of these slow query?
I am trying to find a general solution to solve all
problems.
Aziz

>--Original Message--
>You can trace the lock escalation event, even if the
statement does not
>complete. Also, you can trace the SQL:BatchStarting
event. That way, you
>can see which statement is slow.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>Thank you for your reply.
>Tom, I tried again now with FULLSCAN. Same thing. I don't
>think I will be able to use Profiler. I can not see the
>exec paln since this query never finish. It is using a
>table with 186 mil rows. With SQL server 7 no problem.
>using the Profiler,
>you may have to
-[vbcol=seagreen]
>--
>in message
boss
>.
>
|||As with anything in software development, there is no magic bullet. It is
possible that the specific query is degraded when parallelism is used. If
so, try OPTION (MAXDOP 1).
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
<anonymous@.discussions.microsoft.com> wrote in message
news:187501c499ed$e5100df0$a301280a@.phx.gbl...
I know which statement is slow. I think SQL 2000 using
different path than 7 for this query. Do I have to fine
tune all of these slow query?
I am trying to find a general solution to solve all
problems.
Aziz

>--Original Message--
>You can trace the lock escalation event, even if the
statement does not
>complete. Also, you can trace the SQL:BatchStarting
event. That way, you
>can see which statement is slow.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>Thank you for your reply.
>Tom, I tried again now with FULLSCAN. Same thing. I don't
>think I will be able to use Profiler. I can not see the
>exec paln since this query never finish. It is using a
>table with 186 mil rows. With SQL server 7 no problem.
>using the Profiler,
>you may have to
-[vbcol=seagreen]
>--
>in message
boss
>.
>
|||I appreciate your help Tom.
I used OPTION (MAXDOP1) but it is runnig for 30 min. In
SQl 7 takes only 8 min.
I see that my CPU is not that busy for this OPTION.
Also I found in MS website that sometimes this option may
not work. There is a bug.

>--Original Message--
>As with anything in software development, there is no
magic bullet. It is
>possible that the specific query is degraded when
parallelism is used. If[vbcol=seagreen]
>so, try OPTION (MAXDOP 1).
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>..
><anonymous@.discussions.microsoft.com> wrote in message
>news:187501c499ed$e5100df0$a301280a@.phx.gbl...
>I know which statement is slow. I think SQL 2000 using
>different path than 7 for this query. Do I have to fine
>tune all of these slow query?
>I am trying to find a general solution to solve all
>problems.
>Aziz
>statement does not
>event. That way, you
-[vbcol=seagreen]
>--
>message
then[vbcol=seagreen]
-[vbcol=seagreen]
>-
server.
>boss
>.
>
|||I have also tried SET FORCEPLAN ON
Not helping either.

>--Original Message--
>As with anything in software development, there is no
magic bullet. It is
>possible that the specific query is degraded when
parallelism is used. If[vbcol=seagreen]
>so, try OPTION (MAXDOP 1).
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>..
><anonymous@.discussions.microsoft.com> wrote in message
>news:187501c499ed$e5100df0$a301280a@.phx.gbl...
>I know which statement is slow. I think SQL 2000 using
>different path than 7 for this query. Do I have to fine
>tune all of these slow query?
>I am trying to find a general solution to solve all
>problems.
>Aziz
>statement does not
>event. That way, you
-[vbcol=seagreen]
>--
>message
then[vbcol=seagreen]
-[vbcol=seagreen]
>-
server.
>boss
>.
>

Is SQL 2000 better than 7?

We are using SQL 7 and Forte application and Win NT. I
have migrated DB to SQL 2000 and new Windows 2000 server.
Our DB is big, 150 G. Testing on new 2000 server, I see
that many of our procedures are running slower. One
procedure is like not running. Taking all resources and
hanging. I can ont even see the exec plan. I have tried
set plan still not working. This particular procedure is
using multiple unions and one of them using self join.
I have other procedures they are not that compecated but
the are slow too. I am having hard time convincing my boss
that SQL 2000 is better than 7. We really don't see any.
On top of that some procedure are not working at all.
Please send me your expert opinion.Update statistics with FULLSCAN on all indexes. Also, using the Profiler,
check for lock escalation events. If you see a lot, then you may have to
tune some queries.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote in message
news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
We are using SQL 7 and Forte application and Win NT. I
have migrated DB to SQL 2000 and new Windows 2000 server.
Our DB is big, 150 G. Testing on new 2000 server, I see
that many of our procedures are running slower. One
procedure is like not running. Taking all resources and
hanging. I can ont even see the exec plan. I have tried
set plan still not working. This particular procedure is
using multiple unions and one of them using self join.
I have other procedures they are not that compecated but
the are slow too. I am having hard time convincing my boss
that SQL 2000 is better than 7. We really don't see any.
On top of that some procedure are not working at all.
Please send me your expert opinion.|||Thank you for your reply.
Tom, I tried again now with FULLSCAN. Same thing. I don't
think I will be able to use Profiler. I can not see the
exec paln since this query never finish. It is using a
table with 186 mil rows. With SQL server 7 no problem.
>--Original Message--
>Update statistics with FULLSCAN on all indexes. Also,
using the Profiler,
>check for lock escalation events. If you see a lot, then
you may have to
>tune some queries.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
in message
>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>We are using SQL 7 and Forte application and Win NT. I
>have migrated DB to SQL 2000 and new Windows 2000 server.
>Our DB is big, 150 G. Testing on new 2000 server, I see
>that many of our procedures are running slower. One
>procedure is like not running. Taking all resources and
>hanging. I can ont even see the exec plan. I have tried
>set plan still not working. This particular procedure is
>using multiple unions and one of them using self join.
>I have other procedures they are not that compecated but
>the are slow too. I am having hard time convincing my boss
>that SQL 2000 is better than 7. We really don't see any.
>On top of that some procedure are not working at all.
>Please send me your expert opinion.
>.
>|||You can trace the lock escalation event, even if the statement does not
complete. Also, you can trace the SQL:BatchStarting event. That way, you
can see which statement is slow.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Aziz" <anonymous@.discussions.microsoft.com> wrote in message
news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
Thank you for your reply.
Tom, I tried again now with FULLSCAN. Same thing. I don't
think I will be able to use Profiler. I can not see the
exec paln since this query never finish. It is using a
table with 186 mil rows. With SQL server 7 no problem.
>--Original Message--
>Update statistics with FULLSCAN on all indexes. Also,
using the Profiler,
>check for lock escalation events. If you see a lot, then
you may have to
>tune some queries.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
in message
>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>We are using SQL 7 and Forte application and Win NT. I
>have migrated DB to SQL 2000 and new Windows 2000 server.
>Our DB is big, 150 G. Testing on new 2000 server, I see
>that many of our procedures are running slower. One
>procedure is like not running. Taking all resources and
>hanging. I can ont even see the exec plan. I have tried
>set plan still not working. This particular procedure is
>using multiple unions and one of them using self join.
>I have other procedures they are not that compecated but
>the are slow too. I am having hard time convincing my boss
>that SQL 2000 is better than 7. We really don't see any.
>On top of that some procedure are not working at all.
>Please send me your expert opinion.
>.
>|||Tom Moreau wrote:
> You can trace the lock escalation event, even if the statement does
> not complete. Also, you can trace the SQL:BatchStarting event. That
> way, you can see which statement is slow.
>
You can also add SQL:StmtStarting and SP:StmtStarting to nail it down
even further. You can also run an estimated execution plan from Query
Analyzer and see if anything stands out without executing the query.
--
David G.|||I know which statement is slow. I think SQL 2000 using
different path than 7 for this query. Do I have to fine
tune all of these slow query?
I am trying to find a general solution to solve all
problems.
Aziz
>--Original Message--
>You can trace the lock escalation event, even if the
statement does not
>complete. Also, you can trace the SQL:BatchStarting
event. That way, you
>can see which statement is slow.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
message
>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>Thank you for your reply.
>Tom, I tried again now with FULLSCAN. Same thing. I don't
>think I will be able to use Profiler. I can not see the
>exec paln since this query never finish. It is using a
>table with 186 mil rows. With SQL server 7 no problem.
>>--Original Message--
>>Update statistics with FULLSCAN on all indexes. Also,
>using the Profiler,
>>check for lock escalation events. If you see a lot, then
>you may have to
>>tune some queries.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
>in message
>>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>>We are using SQL 7 and Forte application and Win NT. I
>>have migrated DB to SQL 2000 and new Windows 2000 server.
>>Our DB is big, 150 G. Testing on new 2000 server, I see
>>that many of our procedures are running slower. One
>>procedure is like not running. Taking all resources and
>>hanging. I can ont even see the exec plan. I have tried
>>set plan still not working. This particular procedure is
>>using multiple unions and one of them using self join.
>>I have other procedures they are not that compecated but
>>the are slow too. I am having hard time convincing my
boss
>>that SQL 2000 is better than 7. We really don't see any.
>>On top of that some procedure are not working at all.
>>Please send me your expert opinion.
>>.
>.
>|||As with anything in software development, there is no magic bullet. It is
possible that the specific query is degraded when parallelism is used. If
so, try OPTION (MAXDOP 1).
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
<anonymous@.discussions.microsoft.com> wrote in message
news:187501c499ed$e5100df0$a301280a@.phx.gbl...
I know which statement is slow. I think SQL 2000 using
different path than 7 for this query. Do I have to fine
tune all of these slow query?
I am trying to find a general solution to solve all
problems.
Aziz
>--Original Message--
>You can trace the lock escalation event, even if the
statement does not
>complete. Also, you can trace the SQL:BatchStarting
event. That way, you
>can see which statement is slow.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
message
>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>Thank you for your reply.
>Tom, I tried again now with FULLSCAN. Same thing. I don't
>think I will be able to use Profiler. I can not see the
>exec paln since this query never finish. It is using a
>table with 186 mil rows. With SQL server 7 no problem.
>>--Original Message--
>>Update statistics with FULLSCAN on all indexes. Also,
>using the Profiler,
>>check for lock escalation events. If you see a lot, then
>you may have to
>>tune some queries.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
>in message
>>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>>We are using SQL 7 and Forte application and Win NT. I
>>have migrated DB to SQL 2000 and new Windows 2000 server.
>>Our DB is big, 150 G. Testing on new 2000 server, I see
>>that many of our procedures are running slower. One
>>procedure is like not running. Taking all resources and
>>hanging. I can ont even see the exec plan. I have tried
>>set plan still not working. This particular procedure is
>>using multiple unions and one of them using self join.
>>I have other procedures they are not that compecated but
>>the are slow too. I am having hard time convincing my
boss
>>that SQL 2000 is better than 7. We really don't see any.
>>On top of that some procedure are not working at all.
>>Please send me your expert opinion.
>>.
>.
>|||I appreciate your help Tom.
I used OPTION (MAXDOP1) but it is runnig for 30 min. In
SQl 7 takes only 8 min.
I see that my CPU is not that busy for this OPTION.
Also I found in MS website that sometimes this option may
not work. There is a bug.
>--Original Message--
>As with anything in software development, there is no
magic bullet. It is
>possible that the specific query is degraded when
parallelism is used. If
>so, try OPTION (MAXDOP 1).
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>..
><anonymous@.discussions.microsoft.com> wrote in message
>news:187501c499ed$e5100df0$a301280a@.phx.gbl...
>I know which statement is slow. I think SQL 2000 using
>different path than 7 for this query. Do I have to fine
>tune all of these slow query?
>I am trying to find a general solution to solve all
>problems.
>Aziz
>>--Original Message--
>>You can trace the lock escalation event, even if the
>statement does not
>>complete. Also, you can trace the SQL:BatchStarting
>event. That way, you
>>can see which statement is slow.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>>Thank you for your reply.
>>Tom, I tried again now with FULLSCAN. Same thing. I don't
>>think I will be able to use Profiler. I can not see the
>>exec paln since this query never finish. It is using a
>>table with 186 mil rows. With SQL server 7 no problem.
>>--Original Message--
>>Update statistics with FULLSCAN on all indexes. Also,
>>using the Profiler,
>>check for lock escalation events. If you see a lot,
then
>>you may have to
>>tune some queries.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
>>in message
>>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>>We are using SQL 7 and Forte application and Win NT. I
>>have migrated DB to SQL 2000 and new Windows 2000
server.
>>Our DB is big, 150 G. Testing on new 2000 server, I see
>>that many of our procedures are running slower. One
>>procedure is like not running. Taking all resources and
>>hanging. I can ont even see the exec plan. I have tried
>>set plan still not working. This particular procedure is
>>using multiple unions and one of them using self join.
>>I have other procedures they are not that compecated but
>>the are slow too. I am having hard time convincing my
>boss
>>that SQL 2000 is better than 7. We really don't see any.
>>On top of that some procedure are not working at all.
>>Please send me your expert opinion.
>>.
>>
>>.
>.
>|||I have also tried SET FORCEPLAN ON
Not helping either.
>--Original Message--
>As with anything in software development, there is no
magic bullet. It is
>possible that the specific query is degraded when
parallelism is used. If
>so, try OPTION (MAXDOP 1).
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>..
><anonymous@.discussions.microsoft.com> wrote in message
>news:187501c499ed$e5100df0$a301280a@.phx.gbl...
>I know which statement is slow. I think SQL 2000 using
>different path than 7 for this query. Do I have to fine
>tune all of these slow query?
>I am trying to find a general solution to solve all
>problems.
>Aziz
>>--Original Message--
>>You can trace the lock escalation event, even if the
>statement does not
>>complete. Also, you can trace the SQL:BatchStarting
>event. That way, you
>>can see which statement is slow.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>>Thank you for your reply.
>>Tom, I tried again now with FULLSCAN. Same thing. I don't
>>think I will be able to use Profiler. I can not see the
>>exec paln since this query never finish. It is using a
>>table with 186 mil rows. With SQL server 7 no problem.
>>--Original Message--
>>Update statistics with FULLSCAN on all indexes. Also,
>>using the Profiler,
>>check for lock escalation events. If you see a lot,
then
>>you may have to
>>tune some queries.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
>>in message
>>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>>We are using SQL 7 and Forte application and Win NT. I
>>have migrated DB to SQL 2000 and new Windows 2000
server.
>>Our DB is big, 150 G. Testing on new 2000 server, I see
>>that many of our procedures are running slower. One
>>procedure is like not running. Taking all resources and
>>hanging. I can ont even see the exec plan. I have tried
>>set plan still not working. This particular procedure is
>>using multiple unions and one of them using self join.
>>I have other procedures they are not that compecated but
>>the are slow too. I am having hard time convincing my
>boss
>>that SQL 2000 is better than 7. We really don't see any.
>>On top of that some procedure are not working at all.
>>Please send me your expert opinion.
>>.
>>
>>.
>.
>|||What does the plan tell you?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
<anonymous@.discussions.microsoft.com> wrote in message
news:1f5c01c49a6e$70780390$a301280a@.phx.gbl...
I have also tried SET FORCEPLAN ON
Not helping either.
>--Original Message--
>As with anything in software development, there is no
magic bullet. It is
>possible that the specific query is degraded when
parallelism is used. If
>so, try OPTION (MAXDOP 1).
>--
> Tom
>----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com
>..
><anonymous@.discussions.microsoft.com> wrote in message
>news:187501c499ed$e5100df0$a301280a@.phx.gbl...
>I know which statement is slow. I think SQL 2000 using
>different path than 7 for this query. Do I have to fine
>tune all of these slow query?
>I am trying to find a general solution to solve all
>problems.
>Aziz
>>--Original Message--
>>You can trace the lock escalation event, even if the
>statement does not
>>complete. Also, you can trace the SQL:BatchStarting
>event. That way, you
>>can see which statement is slow.
>>--
>>Tom
>>----
-
>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:18a701c499d3$e91e9020$a401280a@.phx.gbl...
>>Thank you for your reply.
>>Tom, I tried again now with FULLSCAN. Same thing. I don't
>>think I will be able to use Profiler. I can not see the
>>exec paln since this query never finish. It is using a
>>table with 186 mil rows. With SQL server 7 no problem.
>>--Original Message--
>>Update statistics with FULLSCAN on all indexes. Also,
>>using the Profiler,
>>check for lock escalation events. If you see a lot,
then
>>you may have to
>>tune some queries.
>>--
>>Tom
>>---
-
>-
>>--
>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>>SQL Server MVP
>>Columnist, SQL Server Professional
>>Toronto, ON Canada
>>www.pinnaclepublishing.com/sql
>>
>>"Aziz Karim" <anonymous@.discussions.microsoft.com> wrote
>>in message
>>news:145d01c499b4$34e51d50$a301280a@.phx.gbl...
>>We are using SQL 7 and Forte application and Win NT. I
>>have migrated DB to SQL 2000 and new Windows 2000
server.
>>Our DB is big, 150 G. Testing on new 2000 server, I see
>>that many of our procedures are running slower. One
>>procedure is like not running. Taking all resources and
>>hanging. I can ont even see the exec plan. I have tried
>>set plan still not working. This particular procedure is
>>using multiple unions and one of them using self join.
>>I have other procedures they are not that compecated but
>>the are slow too. I am having hard time convincing my
>boss
>>that SQL 2000 is better than 7. We really don't see any.
>>On top of that some procedure are not working at all.
>>Please send me your expert opinion.
>>.
>>
>>.
>.
>