Viewing 15 posts - 3,301 through 3,315 (of 5,678 total)
Kevin, running quickly for one ID and not another usually ends up as parameter sniffing.
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server...
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
April 27, 2011 at 11:13 am
opc.three (4/26/2011)
I think this constitutes a triangular JOIN:
ON A.RowNum = B.RowNum - 1
I didn't go through everything, but that's not a triangular join. This is:
A.RowNum < B.RowNum
A common running...
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
April 26, 2011 at 4:37 pm
When you say bandwidth, I think network.
The only way this could start eating tons of network is if you're constantly getting polled by the app server on the same proc...
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
April 26, 2011 at 3:45 pm
LutzM (4/26/2011)
GilaMonster (4/26/2011)
I dabble in a lot of stuff, some works out well, some doesn't. It's been several years since I last wrote fiction of any form....
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
April 26, 2011 at 3:26 pm
If you want to do this all in one command, you need to turn cascading deletes on for foreign keys. That's what it's built for.
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
April 26, 2011 at 3:25 pm
GilaMonster (4/26/2011)
I don't do epic verse.Though... (read attached at your own risk, very amateur attempt)
Nice, no reason to be concerned at all. If you spent time on that instead...
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
April 26, 2011 at 3:16 pm
Thanks for the feedback, Nick. Appreciated and glad your found what you needed. Don't mind Phil and I if we abduct your thread for further testing, review, 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
April 26, 2011 at 2:32 pm
Phil Parkin (4/26/2011)
I made the assumption that the file was already sorted by VendorID within CustomerID...
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
April 26, 2011 at 1:17 pm
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
An abstract of limericks! 🙂
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
April 26, 2011 at 1:02 pm
A few items here.
One, this field is a DATETIME, right? There's no DDL so I'm assuming it is.
Second, what parameters are you passing in? Just passing in a...
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
April 26, 2011 at 2:53 am
Phil Parkin (4/26/2011)
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
April 26, 2011 at 2:45 am
vidubhushan 49100 (4/25/2011)
I have a database with 3800 tables and because of huge number we decided not use referential integrity between the table. the functional experts and DBAs...
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
April 25, 2011 at 4:58 pm
Steve Jones - SSC Editor (4/25/2011)
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
April 25, 2011 at 4:58 pm
[Jim].[dba].[Murphy] (4/25/2011)
Ya, one...
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
April 25, 2011 at 3:22 pm
You need to turn them into left/right join mechanics, like so:
SELECT
tblacc.*
FROM
tblacc AS a
JOIN
tblreceipt AS r
ONa.rkey = r.rkey
JOIN
tblst AS l
ONa.stkey = l.stkey
LEFT JOIN
tblitem AS i
ONa.stkey = i.stkey
AND a.itkey =...
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
April 25, 2011 at 3:20 pm
Viewing 15 posts - 3,301 through 3,315 (of 5,678 total)