Viewing 15 posts - 42,226 through 42,240 (of 49,563 total)
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
Osmar Fernandez (12/19/2008)
Still, If I can Access the Store Procedure from Another App (ex: Access) I can push incorrect data or modify data with no integrity.
Which is also the case...
December 20, 2008 at 12:42 am
kathyoshea (12/19/2008)
Is there something in 2005 that won't see the order by?
Order by is only valid in the outermost select statement, ie the one calling the function. If it's any...
December 20, 2008 at 12:38 am
weitzera (12/19/2008)
December 19, 2008 at 2:32 pm
Lynn Pettis (12/19/2008)
December 19, 2008 at 2:20 pm
Paul (12/19/2008)
It works happily for a few hours, then suddenly comes apart in a mass of "System.Data.SqlClient.SqlException, Timeout expired" exceptions
Sounds like the data volumes in prod are causing perf problems....
December 19, 2008 at 2:13 pm
Eric Butler (12/19/2008)
Simple question which I thought would be straight forward.Is it necessary to perform an sp_recompile after performing batch UPDATE STATISTICS operations.
No. A stats update invalidates all plans based...
December 19, 2008 at 1:56 pm
Osmar Fernandez (12/19/2008)
December 19, 2008 at 1:47 pm
Leave it at 0. No real need to fiddle with that.
The main reason to change that is for servers that have multiple instances of SQL on them.
December 19, 2008 at 1:43 pm
Viewing 15 posts - 42,226 through 42,240 (of 49,563 total)