Viewing 15 posts - 4,321 through 4,335 (of 5,103 total)
The First questions are:
Are you expecting High Volume?
Are you expecting a lot of users concurrently?
Do you have appropriate hardware/budget?
etc...
About the tools
Some People use ApexSQL, some TierDeveloper, some Codesmith, other simply use...
December 29, 2004 at 10:00 am
Markus,
1. By FAR when the transactional tables are large (+10 millions) and the number of users is large the Lockings are reduced DRAMATICALLY and it wont contend with people trying to...
December 29, 2004 at 9:32 am
Beware of Large composite keys, that's why surrogates exists (the speed of joins will be very noticeable as the table grow large).
Like I said there is no ABSOLUTE in design it will...
December 29, 2004 at 9:11 am
The method that Steve just described is the so-called Flag method. It works when the table involved is not large or the amount of users (concurrent) is not big. When the...
December 29, 2004 at 8:58 am
This is what happens when you try to execute an undocummented sp without reading (digging ) in its code (if at all possible) to...
December 28, 2004 at 3:42 pm
Ganesh,
your output is missing objectName because in SQL permissions are assigned to objects within the database, not to the database itself. At the Database level you allow or deny access...
December 28, 2004 at 3:15 pm
Andreas the code that you posted is exactly what is needed for differences on nullable columns you may skip the is null part for non nullable.
Usually the fastest way to...
December 28, 2004 at 1:21 pm
Greg,
AFAIR I was in a similar situation and I ended doing it on a job so that is asychronous and independent of your code and you could check for the Success or...
December 28, 2004 at 12:47 pm
do you really need immediate update of the central system?
if not, Merge replication, which by the way is supported by MSDE, is the tool of option but if the...
December 28, 2004 at 12:35 pm
Beryl,
You need to be more specific on what tables are involved?, what the result should look like?, what are the data types involved? and if possible put some DDL also....
December 28, 2004 at 12:27 pm
To start, let me make clear that I follow mlsmith advice and that, is the RIGHT way to do it but for the fun of it
I beleive that the...
December 28, 2004 at 10:53 am
Are you just trying to implement the third ooyion I just mentioned ?
December 28, 2004 at 7:40 am
Yes it is possible.
For some system sp you will have to feed the query with some tricks like: Select NULL, or SET FMTONLY ON, etc but if your sp is...
December 28, 2004 at 7:26 am
Ganesh,
I will be very easy to translate the code to dynamic SQL but the apparent ease of manintenace can also be interpreted as too tightly coupled. yes it is true...
December 27, 2004 at 2:26 pm
Viewing 15 posts - 4,321 through 4,335 (of 5,103 total)