Viewing 15 posts - 42,226 through 42,240 (of 49,571 total)
RBarryYoung (12/21/2008)
Or perhaps in the future it will understand "TOP 100%" to mean that we really do want it to sort the data.
Nope. 2000 worked that way, 2005 and 2008...
December 21, 2008 at 7:25 am
Domagoj Orec (12/21/2008)
That is right, Master cert is gr8 example
Yeah, but the Master cert is $20,000 and aimed at a very small percentage of IT people. What can be done...
December 21, 2008 at 7:19 am
Domagoj Orec (12/21/2008)
as you can take exam if you have some number of years of experience in working on SQL Server, with some proof of that, of course.
How would you...
December 21, 2008 at 5:50 am
mahamed_elsirty (12/18/2008)
i upload the exame for u this version is still validstudy this pass4sure good
This site does not permit the posting of links to brain dumps or copyrighted...
December 21, 2008 at 2:29 am
Please read through the links I posted. There are pages of examples in there, much better than I can think up in a few minutes.
December 21, 2008 at 2:07 am
RBarryYoung (12/20/2008)
But it does have to respect the interior ORDER BY's for local TOP clauses, right?
Yes, providing the TOP is row-limiting. Currently, that just means not TOP 100 %,...
December 21, 2008 at 2:07 am
Read the links I posted. There should be lots of examples there.
December 20, 2008 at 1:10 pm
sql server developer (12/20/2008)
When we update data in the first database how the service broker automatically sends the message to the second database and updates it in the second database?
Service...
December 20, 2008 at 1:00 pm
sql server developer (12/20/2008)
Can you send me a sample code for synchronizing two databases using Service Broker if possible?
That's a pretty huge request. There's a lot that goes into service...
December 20, 2008 at 11:03 am
Osmar Fernandez (12/20/2008)
Let's Say that I use an Encrypted Pwd.1. Does SQL have a way to internally Decrypt The Pwd?
No. The encryption I'm talking about is purely within the...
December 20, 2008 at 10:55 am
In that case, look up Snapshot Replication in SQL's Books Online. That should give you a good overview of the subject. If you have specific questions afterwards, post them.
December 20, 2008 at 6:04 am
Ahmad Osama (12/20/2008)
Do I need to stop sql server services before starting the instance in single user mode.......
Of course. An instance can't be running twice, it would conflict on network...
December 20, 2008 at 5:28 am
What do you mean by database replication?
December 20, 2008 at 5:26 am
Paul (12/20/2008)
Honestly if it is performance then I'm worried.
That probably is the root cause. Timeout simply means that the query took longer than the client app was willing to...
December 20, 2008 at 5:18 am
Read this - http://www.sommarskog.se/dyn-search.html
December 20, 2008 at 12:48 am
Viewing 15 posts - 42,226 through 42,240 (of 49,571 total)