SQLCE Synchronization Solution Recommendations

Feb 15, 2008




I create data collection applications on Mobile Devices for field biologists. The biolgists need to sync thier field data with a local database upon returning from the field. I am planning on using sqlce as my mobile database and am trying to get a grasp of what my synchronization options are. Here are some of my questions.

1.) Is there any way to synchronize data between a SQLCE database on the mobile device and a SQLCE database on the desktop (third party or othewise)? It appears to me that the answer is no, which is a shame. Whats the use of having a free light weight database that you can use on a mobile device and as a backend on a desktop but not sync data between them?

2.) If my hunch is right, what are my sync options? Installing SQL Server on every field computer is not an option ($$$). If I'm bound to using SQL Server as the backend database, is it possible to have a single SQL Server database on a webserver that the field locations could sync to remotely?

Any feedback to get me started in the right direction would be greatly appreciated.

Mike



View 1 Replies


ADVERTISEMENT

Using SQLCE As A Middle Tier Caching Solution

Dec 26, 2007

Hi All,
Im trying to migrate a N tiered solution written in Java and Berkeley DB(in memory DB product) to MS stack. ie the in memory DB is being used as a middle tier caching solution.

Im considering using SQLCE where Berkely DB was being used, im guessing that SQLCE being an inproc DB may be faster than using SQLExpress etc.

Has any one tried to do this before? and if so can you share your experience?
Alternatively if you can provide any resources on the web that discuss SQLCE performance(ie not when run on WinCE etc)/ comparison of query performance between SQLCE and SQL Express/Standard that would be great.

Thanks in advance

-Melvin

View 1 Replies View Related

Pocket Pc 2002 Sqlce Data Synchronization With Sql Server 2000 (SP4)

Mar 11, 2006

i am using C#..net

I am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication
class.

the error is

"a call to sql server reconciler failed"

native error 29006

and sometimes

native error

29045.

View 4 Replies View Related

SQLCE, .Net 3.5 And Me Going Crazy Looking For A Lighweight Solution With Lightweight Prereqs

Feb 19, 2008

I take it SSCE 3.5 only runs under .Net 3.5? My project was updated from VS05 to VS08 but the target is still .Net 2.0 would this be why I cant use the SQLCE namespace.

Forgive me for being noobalishous but I have been thinking that SSCE 3.5 would be a great solution for my app as I want to be able to use SQL Server Express 2005 and some other Local DB system (SSE is too bulky for my app when networking is not required). But if the prereq is that the client must have .Net 3.5 installed then I am back to square 1 because .Net 3.5 is like 195Mb install (which i tried installing as a prereq on my friend's Vista Ultimate(?) machine yesterday and it crashed it). Aaargh!! How are you supposed to develop small DB apps (3.5Mb max for app footprint) in the VS environment that don't require massive installation prereqs???

Dont get me wrong I love VS but surely there has to be a way to minimise prereq overheads.

View 5 Replies View Related

Sqlce 3.0 Vs Sqlce 2.0 Memory Issue

Feb 6, 2006

I am currently upgrading our ppc app (written in .net 2003) to .net 2005 and from sqlce 2.0 to 3.0. The new application runs out memory(storage) when handling lots of data transactions (both in case of using sqlcedatareader, and dataset ). There is no memory leak issue here, sqlce 3.0 simply uses a lot more (3 times more) memory than sqlce 2.0.

Our applicaton runs fine using sqlce 2.0 and .net 2003, but fail due to memory shortage

with the upgrades(which has the same code). Anyone can shed some lights on this issue?

View 3 Replies View Related

Windows Synchronization Manager And Subscriber Web Synchronization

Dec 7, 2005

Hi,

View 5 Replies View Related

Web Synchronization - Completed Synchronization Starts Again

Sep 6, 2006

Hello everybody,

There is some strange behaviour i've recently noticed while watching synchronization progress in Replication Monitor on SQL 2005 Server Standard with merge replication configured. The merge process seems to repeat several times.

This is the initial synchronizaion (reinitalization at the subsciber). Client is using Microsoft.SQLServer.Replication objects from .net framework assemblies.

The synchronization starts normally (status is "Running"). The last message of selected session box shows (among other messages): "Beginning evaluating partial replication filters" then "Finished evaluating partial replication filters" and finally "Merge completed after processing xxx changes... etc." after a few seconds. Status changes to "Completed" and then... the merge process starts again!! "Beginning evaluating partial replication filters" etc. And this repeats about 15-20 times.

And so whole process takes about 15 minutes instead about 45 seconds to complete initial synchronization. The number of changes is "Merge completed after processing ..." never change since the first such message.

Is this some bug in web synchronization or some invalid configuration setting? Why does merge process repeat itself so many times??

Please help, thanks in advance.

Kuba

View 6 Replies View Related

How Do You Use The Upgrade.exe For Sqlce 2.0 To Sqlce 3.0?

Jun 9, 2006

Does anyone have any instructions on how to go about uprading a .sdf file
from sqlce 2.0 to sqlce 3.0?

I found this on an msdn website
(link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx) but
as you can see its very lacking on detail. (I included the link and content
referring to upgrading the database files so you won't have to go to the link
to see the part referring to upgrading the database.) I tried to run the upgrade.exe on my device but it doesn't explain how you're supposed to point it to the .sdf that you are trying to update. Here is the content on the above web page.

Upgrading Database Files
You can upgrade a database created with an earlier version of SQL Server CE
2.0 to a database created with SQL Server Mobile by using the SQL Server
Mobile Database Upgrade tool (upgrade.exe). The Database Upgrade tool runs on
a smart device.

When you run the SQL Server Mobile Database Upgrade tool, the new SQL Server
Mobile database is created on the smart device. The new database, with the
file name extension .sdf, contains all the data that was in the source
database. You need to reinitialize the upgraded database to continue using it
for replication.

Note: If you are using replication or remote data access (RDA) as a
connectivity solution before upgrading to SQL Server Mobile, you must
synchronize the source SQL Server CE database (subscription database) with
the SQL Server database (Publisher). The reason for synchronizing before
upgrading to SQL Server Mobile is to ensure that any changes that exist in
the tables on the SQL Server CE database are updated on the SQL Server
database, because after the upgrade you must resubscribe or repull using the
new database.

View 3 Replies View Related

SQLCE 2.0 And SQLCE 3.0, Both On Same Server

Oct 11, 2006

I presently run on my server SQL SERVER CE 2.0 and want to install, in addition on SQL Server 2.0, SQL Server Mobile 2005.

Is there a procedure to have both installed and running on a computer?



Thanks!



Marco

View 2 Replies View Related

SOLUTION! - VB.NET 2005 Express And SQL Server 2005 - NOT Saving Updates To DB - SOLUTION!

Nov 30, 2006

VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION!

-----------------------------------

The following article is bogus and confusing:

How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy'
http://msdn2.microsoft.com/en-us/library/ms246989.aspx

You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.

Do not copy








The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file yourself.

You must manually copy the database file to the output directory
AFTER setting 'Copy to Output Directory' to 'Do not copy'.

-----------------------------------

The above article is bogus and confusing.

This is rediculous!

This is the most vague and convoluted bunch of nonsince I've ever come accross!

Getting caught out on this issue for the 10th time!
And not being able to find an exact step-by-step solution.

--------------------------

I've tried it and it doesn't work for me.

Please don't try what the article eludes to as I'm still sorting out exactly what is supposed to be happening.



If you have a step-by-step procedure that can be reproduced this properly please PM me.

I would like to test its validity then update this exact post as a solution rather than just another dicussion thread.

Many thanks.



This is the exact procedure I have come up with:

NOTE 1: DO NOT allow VB.net to copy the database into its folders/directorys.

NOTE 2: DO NOT hand copy the database to a folder/directory in your project.

Yes, I know its hard not to do it because you want your project nice and tidy.
I just simply could NOT get it to work.
You should NOT have myData.mdf listed in the Solution Explorer. Ever.

Create a folder for your data following NOTE 2.

Copy your data to that folder. * mine was C:mydatamyData.mdf



Create a NEW project.

Remove any Data Connections. ( no matter what)

Save it.

Data | View Data Sources

Add New Data Source

select NEW CONNECTION ( No Matter what, do it!

Select the database. * again mine was C:mydatamyData.mdf

Answer NO to the question:
Would you like to copy the file to your project and modify the connection?
- NO ( no matter what - ANSWER NO ! - Absolutely NO )
Then select the tables you want in the DataSet.
and Finish.



To Test ----------

From the Solution Explorer | click the table name drop down arrow | select details
Now Drag the table name onto the form.

The form is then populated with a Navigation control
and matching Labels with corresponding Textboxes for each field in the table.

Save it.

1) Run the app.

Add one database record to the database by pressing the Add(+) icon

Just add some quick junk data that you don't mind getting lost if it doesn't save.

YOU MUST CLICK THE SAVE ICON to save the data you just entered.

Now exit the application.

2) Run the app again.

And verify there is one record already there.

Now add a second database record to the database by pressing the Add (+) icon.

NOW add some quick junk data that you WILL intentionally loose.

*** DO NOT *** press the save icon.

Just Exit the app.

3) Again, Run the app.

Verify that the first record is still there.

Verify that the Second record is NOT there.
Its NOT there because you didn't save the data before exiting the app.

Proving that YOU MUST CLICK THE SAVE ICON to save the data you just entered.

Also proving you must add your own code to catch the changes
and ask the user to save the data before exitiing or moving to another record.

As a side note, since vb.net uses detached datasets,
(a copy/snapshot of the dataset in memory and NOT directly linked to the database)
the dataset will reflect all changes made when moving around the detached datasets.
YOU MUT REMEMBER TO SUBMIT YOUR CHANGES TO THE DATABASE TO SAVE THEM.
Otherwise, they will simply be discarded without notice.

Whewh!

I hope this saves me some time the next time I want to start a new database project.

Oh, and uh, for anyone else reading this post.

Thanks,
Barry G. Sumpter

Currently working with:
Visual Basic 2005 Express
SQL Server 2005 Express

Developing Windows Forms with
101 Samples for Visual Basic 2005
using the DataGridView thru code
and every development wizard I can find within vb.net
unless otherwise individually stated within a thread.

View 17 Replies View Related

Any SQL Hardware Recommendations?

Jul 14, 2000

Hi

I've got a SQL database running on Windows NT 4 Server (P400, 256 Ram, 8Gb IDE & 18Gb SCSI HDD) and quite a few of the queries are taking a long time to run, and are also using a lot of the processor time. This affects other users who are also trying to query the db. Has anyone got any recommendations for upgrading the hardware spec to improve the overall performance? I presume just add more RAM, and get a dual processor system?

Thanks

Ben

View 1 Replies View Related

Pagination Recommendations

Apr 12, 2004

I am a PHP programmer for a small startup. We are storing person records and our MS SQL Server 2000 database has grown to the point where we wish to paginate the data before returning it to my PHP scripts.

I was wondering if anyone has any recommendations on an optimal way to manage this given the following requirements.

- Data must return only X number of rows at a time (user configurable).
- Must be able to search by several diffent criteria (name, date, birthday, location, ...)

Also, I was wondering if it is possible to return the total number of existant rows of data as the first row of a MSSQL procedure.

View 2 Replies View Related

Recommendations For Building An App.

Jun 19, 2008

I have a SQL 2005 database containing the location of graphics files. I want to start learning how to write a C# application that will get a path from the DB and display the file. Any recommendations on sites where I can start learning how to do this?

Thanks

View 1 Replies View Related

Book Recommendations?

Jul 21, 2006

Ok, let me start by saying that I already checked the FAQ. There was one link, but it just seemed to go to a review page with 5 books, with pretty specific themes. So I'm surprised that such a basic topic as book recommendations for SQL newbies wasn't covered.

In my case, I'm not a total newbie. I learned to write SQL queries for work on both Oracle and SQL Server, and I've gotten pretty good at all the basics. So I've got "SQL for Dummies" down cold, so to speak. Now I'm looking to take my query writing ability to the next level, which I guess would be the intermediate level. I'm also looking for books that are specific to just SQL Server, rather than the books about general querying on any DBMS. Speaking of which, just so you all know, "SAMS Teach Yourself SQL in 21 Days" is an Oracle book, no matter what it says on the cover.

It looks like the book "Inside Microsoft SQL Server 2005: T-SQL Querying" comes highly recommended, but I flipped through it on the shelf at a bookstore the other day, and I think it's over my head. It might be a good reference to have around, but I think I'd be totally lost trying to read it from cover to cover.

So does anyone have recommendations for books that go beyond "This is how to do a SELECT, and here's how to do a JOIN", but won't make my head explode?

Thanks in advance,

--Fromper

View 4 Replies View Related

Book Recommendations?

Jul 17, 2006

I do software support for software that works with both Oracle and SQLServer, so I mostly just write queries to look at the data related tothe software. When I first started, I bought a couple of books to learnthe basics, intentionally going with generic books that would help withboth types of databases. I've got the basics down, and now I'm lookingfor a really detailed reference book that goes really indepth intoquerying for SQL Server specifically. Currently, we only work with the2000 version, but we'll be going to 2005 soon, so I think I'd rather gowith a book on 2005, although if you know one that covers thedifferences between them, that would be great. Any recommendations?Besides just writing queries, I'd also like to learn more about SQLServer in general. DBA software support, so I'd like to head mycareer in that direction. I was looking at Microsoft's newcertification path for SQL 2005. Given that my company won't pay tosend me for training, and I really don't want to have to put down$2200+ to pay for a class, I was thinking that I might be able to learnenough on my own to pass the first test and get the MCTS title. Iordered the Training Kit from Microsoft Press for that, which comeswith a 180 day trial of SQL Server 2005 to play with, along with a hugebook. Does anyone have any other recommendations for resources to helplearn this stuff?--Richard

View 4 Replies View Related

ADO Or ODBC Recommendations

Jul 20, 2005

Hello -Anyone have any thoughts on which API to use - ADO or ODBC?I have a fat client written in C++ using MFC ODBC classes to access a Jetdatabase.The app is going to be modified to write to a SQL Server central databasewith multiple users accessing their local copies of the database ( usingreplication technology on the clients side).Most of the performance benchmarks give an edge to ODBC over ADO whenwriting to an Access database. Anyone know of any benchmarks for a c/senvironment?I've seen references that ADO has some client side cursor features forfilters and sorting which are a benefit over ODBC. I'd also like to usethe asynchronous fetch that OLE DB provides and am not sure if this isimplemented in ODBC.Thanks for the help.Bruce

View 1 Replies View Related

SQL Book Recommendations For Newbie?

Sep 15, 1999

Hi all,

I've recently been tasked with doing some SQL 7.0 administration and was wondering if anyone could recommend a good book to get started. The bulk of my IT experience is in SMS, IIS and messaging so my database fundamentals are pretty weak.

As I see it, it's probably a three-step process to get me at least halfway comfortable - a first book to get some solid general database / SQL-language exposure, a second book that takes the knowledge to a more advanced level and finally a MS-specific book that covers the Microsoft implementation of a SQL server.

Any comments / suggestions would be much appreciated!

Cheers,
RM

View 2 Replies View Related

Schema And SP Compare Recommendations

Dec 3, 1999

I've searched quite a bit, and have found several leads on schema, stored procedure, and database contents comparison scripts and tools.

I'm now looking for recommendations on which ones are best, easiest:

ObjCompare.exe
sb_ABCompareDb.sql
sp_db_comp.sql

There's a mythical script from Andrew Z <mumble> that Mike Hotek talks about...

There's a DBCompare on the Back Office Resource Kit 2 CD, which of course is not in the umpteen MSDN CDs :-(

There's some *other* command line dbcompare, or maybe db_compare.

There's a DBA Compare.

I need to be able to compare divergent schemas from two developers to integrate their changes, so need schema and stored procedures compared only, and would also like to have something to compare staging servers and production servers.

Leads on other choices also welcome. I'd be happy to summarize and post, if warranted.

View 1 Replies View Related

Looking For Training Recommendations In London

Jun 29, 2004

Hi,

I've been using Sybase for some years but by employer is moving (you guessed it) to MSSQL.

Can anyone recommend a TSQL and performance tuning training course for MSSQL in the London area?

Thanks,

Rob.

View 1 Replies View Related

?Recommendations For Training/conferences?

Mar 22, 2006

I'm a solid SQL developer/dba and have some funds earmarked for training this year. I'd like to expand my dba skills...more specifically, I'd like to become a rock-solid enterprise level dba that has not only a solid foundation of skills but some innovative techniques for managing our corporate SQL servers.

I'm curious if anybody has recommendations on training or conferences that might help me dig into those skillsets for a couple of days.

Thanks for your insight.

alex8675

View 1 Replies View Related

Book Recommendations Needed

Jul 20, 2005

I am looking for a book that discusses query tuning, index tuning, executionplans, etc. Can anyone recommend something?--BV.WebPorgmaster - www.IHeartMyPond.comWork at Home, Save the Environment - www.amothersdream.com

View 1 Replies View Related

Volume Size Recommendations

Apr 24, 2007

We have an application that was built and testing using SQL Server Express. One of our clients is deploying it using SQL Server Standard and plans to put the data files and log files on separate disk volumes.



In allocating the available disks to the volumes, they are looking for a recommendation on how big the log file volume versus the data file volume should be. Over time there will several years worth of data in the data files. I assume the log files need to be at least big enough to log all the changes between back-ups. Are there any general rules of thumb? Or whitepapers that discuss the trade-offs?



Thanks in advance...



View 1 Replies View Related

Need Recommendations For Some Connection Properties

Sep 27, 2007

Howdy folks,

I'm trying to get a better idea of how I should set some of the SSCE connection properties. I will be deploying the application on a WinCE5 board with a 4G flash storage card and 512MB RAM. The application must run 24/7 with a medium amount of traffic. At any given point I expect up to 3 connections to the same database. I'd really like to keep performance high without risking any database corruption issues. As such, I need to make sure my connection properties are optimized.

I read from Joao's article that setting DBPROP_SSCE_MAXBUFFERSIZE = 1024 gave a considerable performance increase, while anything higher gave diminishing returns. Is this for a certain amount of RAM, or is it uncorrelated to RAM size?

What's the best practice for specifying DBPROP_SSCE_TEMPFILE_DIRECTORY and DBPROP_SSCE_TEMPFILE_MAX_SIZE? Is it possible in WinCE5 to directly put it in RAM? How big do these temp files get?

I've read of some bad experiences with autoshrink. Are there any reasons not to set DBPROP_SSCE_AUTO_SHRINK_THRESHOLD to 100 if the database will be compacted regularly?

Any other advice for the more obscure settings such as DBPROP_SSCE_FLUSH_INTERVAL or all the lock settings?

Thanks a bunch!

View 5 Replies View Related

Any Recommendations On Reference Material

Nov 27, 2007



I am in the process of creating a user interface that will give the users a list of reports to choose from. I wanted to write an interface in ASP .NET with C# to pull information for different reports from the reporting services web service. I have successfully done this with C# Windows Form. The project requires it to be web-based.

Problem is, I am new to web forms and would like a recommendation for reference materials to help me program ASP .NET with C# and using the web service. I am still learning ASP .NET and C#, so I would like something fairly basic.

Any help is appreciated.

View 3 Replies View Related

I Need To Rise To The Next Level Of SQL Programming, Recommendations?

Jun 13, 2007

This really isn't a SQL Server specific question, but more tword SQL in general. I am pretty good at SQL, being able to perform joins on several tables at one time. I am looking for more challenges in SQL though as I want to learn more and to rise to the next level. Can anyone recommend some good resources to me?
It would be challenging to me to learn how to do more complex queries involving three or more tables.
Ralph

View 2 Replies View Related

Multilanguage Database Design Recommendations

May 18, 2008

Dear friends
I'm developping a multilanguage human muscle database and wanted to know your opinion about my design
Table Muscle:-MuscleID(PK)-Name_DE...............german is standart-Description_DE
Table Muscle_LANG (for appr. languages):-MuscleID(PK)-Name_EN-Name_FR-Name_ES-Description_EN-Description_FR-Description_ES
Many thanks for your tips

View 7 Replies View Related

Test Cluster Environment Recommendations

Apr 23, 2001

I want to build a SQL testing environment in an active/active setup. Any recommendations on what I could use if I want to set up the most bare-bones system. I want to do it as cheaply as possible.

Thanks

View 1 Replies View Related

Memory Recommendations For Cluster Sql Server

Jun 20, 2006

We have a win2003 cluster with sql 2000 with 16 gig of memory. Should you leave more memory for the OS versus if this was a stand-alone server

View 3 Replies View Related

Database Engine Tuning Recommendations

Feb 11, 2008

Hi,

I'm just testing the database engine tuning advisor.

I created a basic trace file in SQL Server profiler by randomly opening a number of views in the Adventureworks db. I then used the Database Engine Tuning advisor to analyse this.

The tuning advisors recommendation was to drop about 2-3 dozen indexes, which sounds like a really dumb idea.

Is it normal for DET to recommend that any index not referenced by the workload file be dropped?

View 3 Replies View Related

SQL Server 2000 Hardware Recommendations

Jul 20, 2005

I'm on the IS team of a medium-sized non-profit with internationalreach. We're trying to make some decisions regarding our Web serverand database server as we expand our web site to have more dynamiccontent. Currently the database server houses all data pertinent tothe organization (membership data, events, products, etc) in onedatabase (~2.2 GB) as well as the web site content in a separatedatabase (~40 MB). The web site pulls from both databases but hits thecontent database more often.In a nutshell, our database server appears to be struggling duringperformance testing of the new Web site. We are trying to determinewhether we simply need new hardware, or if there are things we can doto help MS SQL make better use of the resources we have. The hardwareis a COMPAQ ML370, 1266mhz Pentium III, 1gb RAM, RAID 5 with 3 HD(10,000rpm) and a COMPAQ Smart Array 5i SCSI controller. The OS isWindows 2000 (standard) running Microsoft SQL 2000, SP 3a. The Webserver is a 2.8ghz Pentium IV with 2.5gb RAM, RAID 5 with 3 HD (15,000rpm) running Windows 2000 standard and IIS 5.0. While stress testingour web site under a moderate load (simulating approximately 20simultaneous users), the database server processor tends to max outand stay that way for the duration of the test. Memory and disk accessappear to remain fairly stable -- there isn't a lot of paging goingon, and the disk queue doesn't escalate much if any. The Web servershows spikes in processor use, but appears to be coping well. However,under a heavy load, a sql-heavy page can take as long as 90 seconds toload! We've been assuming that the network is not the issue, as theservers are communicating over a gigibit backbone and while we'veidentified aspects of the ASP code that we can optimize, the databaseserver seems to be a large part of the problem.We've reviewed our SQL configuration settings, and they appear toalign with the best practices, which in our case are the defaultsettings for SQL 2000. We have rebuilt our indexes, and havedefragmented the hard disks on both the database and Web servers.This, along with changes to the structure of the Web pages themselves,has led to improvements, but the processor on the database serverseems to be groaning under the strain, and pages are still taking anunacceptable amount of time to load.What else should we be looking at? Are there steps we could take tominimize the load generated by client/server and Web-related traffic,or specific performance counters that would help us to identify theproblem? Do we just need to look at getting some new hardware? If newhardware is unavoidable, is there anyone running a similar environmentwho could suggest what minimum requirements we should be looking for?Any suggestions would be much appreciated!

View 5 Replies View Related

Recommendations For Placement Of ZIPCode Table

Apr 30, 2007

We are creating a company-wide table of ZipCodes, States, GPS info, etc. This table can be used by our development and production servers (many of them.) We could place the table on a given server and use linked servers to grant access to that table to the other servers. But is there a better way to handle this globally-useful table?



Barkingdog



P.S. Clearly, we don't want to have multiple copies of this table scattered around on various servers. That introduces synchronization issues.

View 1 Replies View Related

SQL Server 2005 And File Systems, Any Recommendations

Aug 4, 2006

We're planning to migrate our db to new and more disk drives, fasterRAID levels and more dedicated disk usage(e.g. placing the translog ondedicated disks). The db server runs on Win2003.Right now we're thinking about what file system to use on the newdrives. We opt for performance, but expect reliability as well.(Goeswithout saying, IMHO ;-))


Quote:

View 18 Replies View Related

Advanced Transact-SQL Reference Book - Need Recommendations!

Jul 20, 2005

I currently have two SQL server books for MS SQL Server 2000. One is aprep book for the 70-229 exam, the other is a Wrox book: "professionalSQL Server 2000 Programming."I'm looking for more T-SQL books that give me PRACTICAL tips onwriting advanced queries. What book do you refer to? Please post them.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved