Viewing 15 posts - 4,516 through 4,530 (of 5,678 total)
Hey Root,
What Toby said above looks right at a glance, but I believe the problem is more basic for you. You've misunderstood, or haven't been informed, of some basic...
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
December 29, 2010 at 5:27 pm
Hey guys. Blogging/articles and the like are relatively new to me, so I'd like your educated opinions on how I should look at this:
http://balapalani.blogspot.com/2010_12_01_archive.html
It's roughly a copy/paste of the...
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
December 29, 2010 at 5:20 pm
LutzM (12/29/2010)
Please provide the business rule for your conversion.How does "F" show up all of a sudden?
To add to this, why did C 3/4 only apply to 3 and D/E...
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
December 29, 2010 at 4:39 pm
Happy holidays all. Just got back from my Christmas vacation. I didn't bother throwing backup into that thread because... well... I didn't have anything to say but Ditto....
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
December 29, 2010 at 2:14 pm
I know this is an article about built in features, but there's a corollary to it.
The online community for SQL Server has saved more Professional's buttocks than any...
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
December 17, 2010 at 6:21 pm
Paul White NZ (12/17/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
December 17, 2010 at 5:31 pm
<--------------------------- This look on my face is getting to be a habit these past two weeks...
Paul White NZ (12/16/2010)
Craig Farrell (12/16/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
December 17, 2010 at 3:21 pm
Unmentioned so far, but useful, and easily hidden... cough drops. Halls in particular are my preferences, the Vitamin C ones with no menthol. They also don't excite the...
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
December 17, 2010 at 2:35 pm
Something like this perhaps?
BETWEEN DATEADD( mm, DATEDIFF( mm, 0, @StartDate) - 6, 0) AND DATEADD( dd, DATEDIFF( dd, 0, @StartDate), 0)
Note I removed your dbo.DateOnly function and swapped it out...
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
December 17, 2010 at 12:04 pm
Gianluca Sartori (12/17/2010)
GilaMonster (12/17/2010)
CirquedeSQLeil (12/17/2010)
I see an x86 and amd64 version. Too bad they don't have an intel 64 bit version.
The x64 processor architecture is sometimes known as AMD64...
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
December 17, 2010 at 10:45 am
Paul White NZ (12/16/2010)
CREATE TABLE dbo.Example
(
row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,
data AS...
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
December 16, 2010 at 6:49 pm
WayneS (12/16/2010)
I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....
Hehehe, and as usual, I'm...
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
December 16, 2010 at 5:28 pm
The short form, if I had to make a guess without the code/samples, is that you're using a where clause to limit the results to your actual ints.
This will fail...
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
December 16, 2010 at 5:26 pm
Malcolm Daughtree (12/16/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
December 16, 2010 at 5:22 pm
WayneS (12/16/2010)
@craig-2 - what does this last select return on your system?
As expected, 5001-5005, 7001-7005, 9001-9005, and the final select starts at 1 and carries through (for about 30 spot...
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
December 16, 2010 at 5:16 pm
Viewing 15 posts - 4,516 through 4,530 (of 5,678 total)