Viewing 15 posts - 42,166 through 42,180 (of 59,067 total)
CirquedeSQLeil (8/27/2009)
Ever thought of upgrading to a previous version. Sorry guys - not a fan of Office 2007, ribbons and frilly things - yuck.:-D
Man, do I agree with THAT!...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2009 at 12:46 pm
crookj (8/27/2009)
Another thing I came across is...Make sure that you have a licensed software version and that it has been activated.
Still looking.....
Joe
Thanks. Just to assure everyone, I'm so honest...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2009 at 12:11 pm
I think it's a bad idea because what will happen if two instances of your code are executed at the same time?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2009 at 11:52 am
There's really only one way to know for sure... try both with Profiler running. Select the one that uses the fewest resources for CPU and Reads. Both should...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2009 at 11:28 am
Rimvydas Gurskis (8/27/2009)
SET DATEFIRST 1
;WITH days(Date) AS
(
--Get 13th of this month
SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)
UNION ALL
--Get 13th...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2009 at 8:29 am
Elliott W (8/26/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2009 at 10:11 pm
glu (8/26/2009)
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
the query took 32 seconds, the next run 6 seconds. execution plan takes 1 seconds, recompile takes...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2009 at 10:08 pm
Elliott W (8/25/2009)
Good point... No flames... just thoughts.... If all you intend to do is split the octets, then the six line T-SQL solution that uses PARSENAME is almost as...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2009 at 12:31 am
Steve, great editorial, as usual. My recent bout with folks that have been copying my articles as my own has led me to take one extra step on any...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 11:00 pm
sjsubscribe (8/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 10:25 pm
Need to pass as many delimited strings as the number of parameters.
Not true... please consider the following...
http://www.sqlservercentral.com/articles/T-SQL/63003/
Since, delimited string would be passed as a string data type, so limitation...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 8:50 pm
RBarryYoung (8/25/2009)
Steve Jones - Editor (8/23/2009)
and...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 7:14 pm
Elliott W (8/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 6:36 pm
No, not yet. Still have too many fires with sticks in them. :hehe:
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 10:48 am
Bob Hovious (8/25/2009)
Most of the credit goes to Jeff. He taught me everything I know about Tally tables.
:blush: Thanks, Bob. I really appreciate the kudo. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2009 at 7:57 am
Viewing 15 posts - 42,166 through 42,180 (of 59,067 total)