Viewing 15 posts - 42,211 through 42,225 (of 49,552 total)
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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 %,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2008 at 2:07 am
Read the links I posted. There should be lots of examples there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2008 at 5:28 am
What do you mean by database replication?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2008 at 5:18 am
Read this - http://www.sommarskog.se/dyn-search.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2008 at 12:38 am
weitzera (12/19/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2008 at 2:32 pm
Lynn Pettis (12/19/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2008 at 2:20 pm
Viewing 15 posts - 42,211 through 42,225 (of 49,552 total)