Viewing 15 posts - 4,936 through 4,950 (of 5,678 total)
Ran into the same problem myself tinkering with EXCEPT. No, it's not going to do what you want, it can't completely replace LEFT JOIN t ON x/y WHERE t.x...
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 15, 2010 at 3:06 pm
Digs (11/15/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 15, 2010 at 3:05 pm
Learner1 (11/15/2010)
its again an interview question but I got an answer already...
this can be done using a corelated query
SELECT DISTINCT (a.age) FROM test55...
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 15, 2010 at 2:50 pm
Lowell (11/15/2010)
wow, so even if you were to drop the table itself in the original database, the space will not be recovered? is that right?
Apparently, no. It's documented here...
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 15, 2010 at 2:41 pm
GrassHopper (11/15/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 15, 2010 at 2:34 pm
Michael Valentine Jones (11/15/2010)
That's good, as long as they don't actually decide to go out and buy a cheap laptop to replace the server. :crying:
"So, that's your blade 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
November 15, 2010 at 2:33 pm
Remove the GO after the Drop Table statement. It ends the batch.
If you want an in-proc terminator, use ;
It's not necessary here though.
Go forces the following script to happen...
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 15, 2010 at 2:29 pm
paul.olson.dba (11/15/2010)
In the back of by head I thought that migrating to an empty db would be the last resort but it is looking like this is my only...
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 15, 2010 at 2:02 pm
Well, since you showed your work this will be easy to help get you back on track.
T2512 (11/15/2010)
selectA.studentid
, A.[year] ,
b.[year],
a.avgpmtamt,
B.avgpmtamt
, (B.avgpmtamt-A.avgpmtamt)/ B.avgpmtamt as change
This is 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
November 15, 2010 at 1:55 pm
I've seen this before. It's not pretty, and you're going to need downtime to fix this if it's production.
For whatever reason, 2k5 and LOBs don't play nicely. 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 15, 2010 at 1:43 pm
To add to what Roy said, and he's right, that just means it's more expensive data wise than it is computationally, there's a few other things you need to see.
No...
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 15, 2010 at 1:38 pm
CirquedeSQLeil (11/15/2010)
WayneS (11/15/2010)
Craig Farrell (11/15/2010)
your girlfriend no longer remembers if you prefer meat sauce on the Italian food.
Now, just need to find a new girlfriend who actually CARES what sauce...
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 15, 2010 at 1:33 pm
Might sound odd, but was the table filled with LOB data?
Example datatypes: text, VARCHAR(max), XML...
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 15, 2010 at 12:49 pm
Stefan Krzywicki (11/15/2010)
What kind of models?
I'm a geek... Warhammer40k. 😀 (The Tyrannid shall EAT 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 15, 2010 at 12:46 pm
wannalearn (11/15/2010)
I created
DELETE ABCDEF FROM dbo.XYZ
WHERE Column = 'ABCDEF100'
want to delete ABCDEF AND LEAVE 100 IN THAT COLUMN
Plz help me create statement 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
November 15, 2010 at 12:29 pm
Viewing 15 posts - 4,936 through 4,950 (of 5,678 total)