Viewing 15 posts - 286 through 300 (of 5,678 total)
I'm a little confused to your request. What do you mean 'by group'?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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/
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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!"...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 20, 2014 at 1:14 am
Viewing 15 posts - 286 through 300 (of 5,678 total)