Viewing 15 posts - 1,246 through 1,260 (of 3,221 total)
raj_paandy
The output similar to my question. All what I want to see is when user input an Employee Id, it should show their superior manager (means manager's manager). In...
April 29, 2011 at 5:29 pm
Jason Selburg (4/28/2011)
SELECT
NAME, LASTNAME,
CASE WHEN AGE > 25 THEN '1' ELSE '' END AS QUALIFIED
FROM
...
April 29, 2011 at 9:10 am
When running your code (eight consequtive runs) on SQL 2008 Developer edition as
CREATE TABLE #pwdTbl(Pwd Char(10),C2 CHAR(6),C3 DATE)
declare @ctr int
declare @seed int
set @ctr =1
WHILE @ctr < 10
BEGIN
set @seed=@ctr + 2048
insert...
April 28, 2011 at 9:54 am
Steve Jones - SSC Editor (4/27/2011)
April 27, 2011 at 11:48 am
You might want to also read this blog posting of Paul Randal
It is a survey of what other DBA's feel is their most pressing performance problems.
http://www.sqlskills.com/BLOGS/PAUL/post/What-do-you-look-for-when-analyzing-query-plans.aspx
Edited to correct...
April 27, 2011 at 10:01 am
One thing I would STRONGLY suggest is to NOT SHRINK THE DATABASE.
In the normal course of working it will only grow again, and shrinking can/may introduce more problems that I...
April 27, 2011 at 9:34 am
Jason Selburg (4/27/2011)
Judging from some people's anger level at question semantics, the points are worth more than a gallon of gas. :hehe:
It is a matter of pride, of self assurance,y...
April 27, 2011 at 9:07 am
GilaMonster (4/26/2011)
I don't do epic verse.Though... (read attached at your own risk, very amateur attempt)
I take exception to the words "very amateur". Read both and thoroughly enjoyed both.
Thanks...
April 26, 2011 at 2:56 pm
Kiara (4/26/2011)
bitbucket-25253 (4/25/2011)
JeffSent to you via email, the latest test results for the 4K splitter test. Just letting you know here to draw your attention to your e-mail
Wait...
April 26, 2011 at 6:11 am
Jeff
Sent to you via email, the latest test results for the 4K splitter test. Just letting you know here to draw your attention to your e-mail
April 25, 2011 at 5:02 pm
Jason Selburg (4/25/2011)
But I will again state, that the purpose was to spark conversation.
My appologies to...
April 25, 2011 at 4:12 pm
david.holley (4/25/2011)
April 25, 2011 at 4:03 pm
From:
http://dictionary.reference.com/browse/guarantee
"something that assures a particular outcome or condition:"
Sorry but my language comprehension is that means the ONLY answers are 2 or 9 or 11 and NEVER another value.
But the given...
April 24, 2011 at 9:00 am
Brandie Tarvin (4/22/2011)
I haven't gone through all the QotDs yet. Can someone tell me if there's been one on identities and transactions?
Just on transactions (not specifically including identities)
1. Published...
April 22, 2011 at 12:21 pm
Now none of these are mine but I failed to record who informed me of them.
select DATEADD(wk,DATEDIFF(wk,0,dateadd(dd,6 - datepart(day,getdate()),getdate())), 0)
AS 'First Monday'
--add 4 days of it to get...
April 21, 2011 at 9:05 pm
Viewing 15 posts - 1,246 through 1,260 (of 3,221 total)