Viewing 15 posts - 1,321 through 1,335 (of 7,636 total)
support.sql (11/26/2009)
...Please evaluate @nalytics Performance Free Data Collector for Microsoft SQL Server & Windows Server...
You know, this kind of constant product spamming would go down a lot easier if you...
December 1, 2009 at 2:33 pm
SBS-291204 (11/24/2009)
Mate, I think you'll find Jamie Thomson is a man... unless he's not telling us something?
Actually, I think that you'll find that Jamie Thomson is THE Man, especially when...
December 1, 2009 at 9:01 am
First have the profiler break it down to the statement level, and then compare the times, statement by statement between the two. Find which statement(s) have the most different...
December 1, 2009 at 8:10 am
checkitoutcouk (8/25/2009)
November 30, 2009 at 10:36 am
GSquared (11/30/2009)
Insert dbo.TheThread (Messages)Values ("Welcome Back Barry")
Heh, thanks, Gus.
November 30, 2009 at 10:22 am
You cannot use an ORDER BY clause in a DELETE statement. Wouldn't make any sense anyway.
November 29, 2009 at 1:23 pm
This is because SMO is a .Net API, but sp_OACreate (and DMO) are COM facilities.
To do this you would first have to create and out-of-process COM Server which then called...
November 28, 2009 at 4:33 pm
What are you using to send the Email? I ask because this looks very much like a series of known problems with SQL Mail, that are generally fixed in...
November 28, 2009 at 3:49 pm
November 28, 2009 at 3:30 pm
I am not familiar with DataEnvironment, but I would suggest that you use SQL Server profiling to see what is really happening on your SQL Server. My offhand guess...
November 28, 2009 at 2:53 pm
deepakkn (11/20/2009)
2. We need to Integrate Service Broker and .NET. Can anyone help in giving the overview of the same?
It's the same as any other SQL features, the best approach...
November 28, 2009 at 2:09 pm
deepakkn (11/20/2009)
1. How can we create the Message and send it to a Queue, if a record is added or modified in a table.
You create a trigger on the table...
November 28, 2009 at 2:06 pm
I do think that these multi-selection questions should be worth at least 2 points.
November 28, 2009 at 1:44 pm
Great job Tim, very useful stuff!
November 28, 2009 at 1:12 pm
What do you mean by an "Association" between tables? AFAIK, that's an OO term, not a Relational DB one.
November 28, 2009 at 12:36 pm
Viewing 15 posts - 1,321 through 1,335 (of 7,636 total)