Viewing 15 posts - 5,086 through 5,100 (of 5,678 total)
Demin, you're aware that's not proc based, right?
To help with the query(s) in question, we'd need to see schema, script, and execution plans. Check out the 'optimization' link in...
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
November 3, 2010 at 4:33 pm
WayneS (11/3/2010)
Craig Farrell (11/3/2010)
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
November 3, 2010 at 4:02 pm
WayneS (11/3/2010)
Thus: why drop all tables instead of starting over with a clean database?
I've got two reasons I've done it in the past, mostly scenario specific though.
1) Dev database, 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
November 3, 2010 at 3:58 pm
DECLARE @startDate DATETIME,
@EndDate DATETIME
SET @StartDate = '09/01/2007'
SET @EndDate = '05/20/2009'
SELECT
N AS [Year],
CASE WHEN N = YEAR( @StartDate)
THEN DATEDIFF( mm, @startdate, DATEADD( yy, YEAR( @StartDate) - 1900 + 1, 0))
WHEN...
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
November 3, 2010 at 3:52 pm
raistlinx (11/3/2010)
Craig Farrell (11/3/2010)Raid... slower? Than what?
For writing? Slower than a single drive.
Sorry, reading back that was a bit rougher sounding than the joke I meant it to...
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
November 3, 2010 at 3:18 pm
raistlinx (11/3/2010)
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
November 3, 2010 at 2:50 pm
Some very brief google research:
Run the webservice as admin:
http://database.itags.org/sql-server/274814/
Same starter post, more clarification at the end, needs fully trusted in .NET:
http://www.windows-tech.info/15/35c56638890ee860.php
Some information about custom assemblies which I don't fully understand...
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
November 3, 2010 at 1:00 pm
Offhand, without integrating it into your code (or testing this pseudocode, for that matter, just trying to give you an idea):
You'd use the CHAR() function which turns a numeric into...
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
November 3, 2010 at 12:27 pm
[SecurityException: That assembly does not allow partially trusted callers.]
Double-hop security issue, I think. Not sure how to work around that for SSIS though. Either that or are you...
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
November 3, 2010 at 12:18 pm
I'm not sure I get the new concept of 'swarm'. Nope, not at all. Most of my experience with swarming is me trying to fix some issue with...
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
November 3, 2010 at 12:14 pm
TJonsek,
It's not a lack of interest, but time, that's probably got a lot of people delaying on getting involved in this thread. There's a lot of information in your...
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
November 3, 2010 at 11:51 am
These are estimates, not actuals, but it still gives us some idea of what's going on. The actuals are more useful, however.
In the massive statement (SELECT DISTINCT, 5th statement,...
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
November 3, 2010 at 11:23 am
VGish,
Help me out here. I didn't dig through your code, sorry, but from the first entry you're looking for your data to be gap filled? How do you...
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
November 2, 2010 at 6:14 pm
CirquedeSQLeil (11/2/2010)
Do you use websense at work?
I know I do, and it occassionally screws up for me too. They're related, I take it?
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
November 2, 2010 at 6:11 pm
mymail.default (11/2/2010)
Thanks Craig.The processer is a quad core with 16g ram.
I found the CPU for this stmt in question is 377678
Which means nothing out of context, other than it's not...
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
November 2, 2010 at 4:08 pm
Viewing 15 posts - 5,086 through 5,100 (of 5,678 total)