Viewing 15 posts - 42,586 through 42,600 (of 59,067 total)
GilaMonster (8/1/2009)
Jeff Moden (8/1/2009)
It would be a great addition to your blog but it would also make a hellofa nice article for SSC, too!
Maybe what I'll do is blog it,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 2:38 pm
Man, you're on a roll with great topics and write-ups about those topics.
In Jeff Attwood's article, he posted "what we do is craftsmanship, not engineering" and I have to take...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 2:03 pm
I'm doing great. Thanks for asking.
You also told me that I should write books on SQL way back then. I'm actually in the process of writing one. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 1:27 pm
Thanks for the feedback, Labneh. We aim to please... we sometimes miss but we we're still aiming. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 1:16 pm
This is a good subject. The military realized the fallacy of "If it ain't broke, don't fix it." a long, long time ago. Daily, weekly, monthly, quarterly, yearly,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 1:08 pm
With the exception of the occasional view or UDF, I'd say write everything into stored procedures and use scripts or a GUI to call them. You can also create...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:48 pm
It's more than just that... you also have to quote encapsulate the dates...
SELECT QUOTENAME(GETDATE(),'''')
ALTER PROCEDURE TraceReport
@server varchar(6),@FromDate datetime,@ToDate datetime
AS
BEGIN
SET NOCOUNT ON;
EXEC('SELECT databasename,starttime,eventclass,LoginName,TargetUsername,Objectname
FROM ' + @server + '.TRACEDB.dbo.TraceTable where starttime between...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:42 pm
You can't comment out the step but you can comment out the code it runs. Use whatever constitutes a comment or rem for whatever type of code the block...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:30 pm
Set your mind at ease, the Developer's Edition is identical the the full blown Enterprise Edition except for the licensing restristictions and the operating systems it can run on. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:27 pm
Allister Reid (8/1/2009)
I thought someone might try to unpick what he was doing to try to help with the bigger picture...
I did just exactly that. I'm not sure...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:19 pm
Ah! Got it. Thanks for taking the time to explain. Heh... it's funny... I knew that could be the case in a single query but I wasn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:15 pm
Just from a practical standpoint, the less you select, the fewer bytes need to make it across the pipe, go through implicit conversions, etc, etc. If you don't need...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 11:13 am
Heh... nope. I knew that and I've asked the question incorrectly... What I should have as about the following is...
GilaMonster (8/1/2009)
Jeffrey Williams (7/31/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 10:11 am
Tejas Shah (8/1/2009)
I face this problem in one of my project's reports, so I keep practice to not convert the field.
I actually agree. Formatting dates and times in T-SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 9:46 am
You bet... thanks for the feedback, Ghanta.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 9:34 am
Viewing 15 posts - 42,586 through 42,600 (of 59,067 total)