Viewing 15 posts - 1,636 through 1,650 (of 5,678 total)
Steve Jones - SSC Editor (4/12/2012)
SQLRNNR (4/12/2012)
Sean Lange (4/12/2012)
SQLRNNR (4/12/2012)
Steve Jones - SSC Editor (4/12/2012)
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 12, 2012 at 1:57 pm
I am all for the concept of versioning. However, after reading through this, I find noone's addressed a few key issues that I have with traditional software versioning. ...
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 6, 2012 at 12:11 am
Lynn Pettis (4/5/2012)
Unclaimed briefcase in the lobby and now we aren't working. The CSPD Bomb Squad is here to remove the briefcase.
20 years ago, you saw something like 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
April 5, 2012 at 2:46 pm
Wayne West (4/4/2012)
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 5, 2012 at 2:44 pm
Up is the direction of the local friendly liquor establishment.
"You comin' to the bar later?"
"Yeah, I'm up to 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
April 5, 2012 at 2:37 pm
Mac1986 (4/4/2012)
Thanks Evil for your input.Yes we can use TablockX but this might increase the granularity level of the lock.
Exact opposite, actually, but that's the point.
The other query...
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 5, 2012 at 1:31 am
Koen Verbeeck (4/5/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
I think the attitude comes from a lot of frustration.
I would agree. I...
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 5, 2012 at 1:25 am
peter 82125 (4/4/2012)
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 5, 2012 at 1:22 am
maheshkrishnas (4/5/2012)
i have a 100 records in a flat file source , i need to send only the
first 97...
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 5, 2012 at 1:13 am
If it works and you understand it, roll with it. If you'd like further help and have code that does exactly what you need it to do, post 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
April 4, 2012 at 6:02 pm
Mac1986 (4/4/2012)
I see the query UPDATE [dbo].[WorkQueue]
SET WorkQueueStatus = 'DataLoaded'
WorkQueueStatusDate = GETDATE()
WorkQueueStatusUTCDate = GETUTCDATE()
WorkQueueEndWorkDate = GETDATE()
WorkQueueProcessingMSG = 'DataLoaded:...
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 4, 2012 at 5:56 pm
aptlogix (4/4/2012)
S0001 - 2 - SOF-550
S0003 - 1 - SOF-550
S0004 - 1 - SOF-200 <-- This guy was PRESENT in the last lecture of SOF-550 but was absent...
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 4, 2012 at 2:59 pm
Like so?
DECLARE @RunForDate DATETIME
--SET @RunForDate = '20120126'
SET @RunForDate = GETDATE()
;WITH LastPresent AS
(SELECT
StudentID,
MAX( Attendance_Date) AS MaxDate
FROM
@tblStudents
WHERE
Attendance = 'PRESENT'
AND Attendance_Date <= @RunForDate
GROUP BY
StudentID
)
SELECT
lp.StudentID,
COUNT(*) AS NumAbsents
FROM
LastPresent AS lp
JOIN
@tblStudents AS s
ONlp.StudentID = s.StudentID
WHERE
s.Attendance_Date...
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 4, 2012 at 2:14 pm
GSquared (4/4/2012)
Evil Kraig F (4/4/2012)
http://www.sqlservercentral.com/Forums/FindPost1278324.aspx
Is that supposed to mean something or am I just over-sensitive due to frustration...
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 4, 2012 at 1:26 pm
Let me rephrase the question as to how I understand it and it might help.
Basically, what you're looking to do is take the existing list, re-order it by student, 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 4, 2012 at 1:25 pm
Viewing 15 posts - 1,636 through 1,650 (of 5,678 total)