Viewing 15 posts - 286 through 300 (of 5,685 total)
I'm a little confused to your request. What do you mean 'by group'?
June 25, 2014 at 2:34 pm
There's a number of reasons your queue could be overloading.
Not enough processing, no activation proc (or error), endpoint not responsive, conversations not ending (as above), ...
Service Broker is an on-hand...
June 25, 2014 at 2:32 pm
Lynn Pettis (6/25/2014)
Really? Just because SQL Server setup defaults to a CI collation that makes it the "DEFAULT" collation?I give up.
I gotta say "Yes." to that one, Lynn. ...
June 25, 2014 at 2:30 pm
I believe my current signature speaks for my opinion on this article. If you come later and I've changed it, I agree, thoroughly.
Good editorial Andy.
June 25, 2014 at 1:43 pm
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
June 25, 2014 at 1:21 pm
raja.payani (6/25/2014)
can u help me with clear steps to do...
As soon as you provide clear steps as to what you're already doing rather than a vague description. I left...
June 25, 2014 at 12:16 pm
Koen Verbeeck (6/25/2014)
Yeah. I had this happen once in the SSIS forums. Some guy posted a solution for refreshing the metadata of the data flow.
At runtime?
June 25, 2014 at 12:15 pm
Arijit, from a high level view, do I understand what you're doing here correctly?
SourceSystem Proc with order by on output
-> OleDB Data Source in SSIS with advanced editing and...
June 22, 2014 at 3:34 pm
To clarify, you're looking for a catch-all query?
Something like:
WHERE ( ID = @ID or @ID IS NULL) AND (Somedate = @SomeDate OR @SomeDate IS NULL)
If so, look here:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
June 20, 2014 at 9:31 pm
Try delivering it to an xml or VARCHAR(MAX) datatype variable first (SELECT @xmlVar = Stuff FROM OPENQUERY...) before shipping it along to the webservice.
If I'm right, you can get that...
June 20, 2014 at 6:36 pm
jasona.work (6/20/2014)
The catalog is configured for Automatic change tracking, but we don't do scheduled rebuilds / optimizations of the catalog. Should we be doing such things?
Yes.
As of right now,...
June 20, 2014 at 6:08 pm
pwalter83 (6/20/2014)
I am trying to calculate running total in sql as its not giving me the desired result on SSRS (on the fly calculation).
What's happening in the SSRS that you're...
June 20, 2014 at 5:56 pm
shafirmubarak (6/20/2014)
I am using the batch file not the SQL agent. The batch file will be executed using an ESP job, so i have...
June 20, 2014 at 5:51 pm
Does this location have strict separation of DBA vs. Dev duties? If so, it's possible they want a senior on site for the one-off "HOLY CRAP ITS ON FIRE!"...
June 20, 2014 at 5:50 pm
The answer is probably yes to both. If you're going cross domain there may be enough advantage to moving the database locally for simple convenience. There's enough network...
June 20, 2014 at 1:14 am
Viewing 15 posts - 286 through 300 (of 5,685 total)