Viewing 15 posts - 286 through 300 (of 389 total)
He does say 'scripting operations' so I'm assuming he's talking about scripting objects etc..
Is this what you're referring to, Jeff, when you talk about a T-SQL solution? (String building?)
I've...
January 28, 2009 at 6:10 am
Hi Jeff.....are you replying to someones post from 2006!?
Perhaps he's found a solution by now! 😉
January 27, 2009 at 12:59 am
bteague (1/23/2009)
Nice article. Do you have any recommendation regarding CTEs vs. temporary tables in 2005 or 2008?
2008 I haven't used yet...so can't say.
I think you've got to situate CTEs somewhere...
January 25, 2009 at 3:49 am
A CTE is a temporary result set, which is valid for the scope of a single Select Update Insert or Delete statement.
A CTE is instead incorporated into the SQL statement...
January 23, 2009 at 9:06 am
Aaron Gonzalez (1/23/2009)
Déjà vu...I did add this article to my briefcase last year...Anyway...nice article, David.
yeah....friday is repeats day!
January 23, 2009 at 8:06 am
stianl72 (1/23/2009)
If just ms would implement the lead() and lag() analytical functions, this stuff would be straight forward.(http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254388)
Thanks for that info....very interesting. I just added my vote, and would...
January 23, 2009 at 6:19 am
hariraj_r (1/23/2009)
Do we have any functionality in SQL 2000 to acheive the same. I have a similar problem to address in the organisation I work for other...
January 23, 2009 at 3:04 am
Thanks for the tips Adam,
I expect that the command line I quoted is doing much the same "setup.exe /q /ACTION=RebuildDatabase ...." i.e rebuilding the system databases(?).
In any case the conclusion...
January 7, 2009 at 10:08 am
Briefly, as for my reasons for doing this:
I have a live server with binary collation (case sensitive) and a database with a Case insensitive collation.
On the Dev server, both the...
January 7, 2009 at 9:58 am
Hi Adam,
I'm not sure I've been clear enough, about what my 2 options are (or else I've misread your response.)
OPTION 1
Rebuild server and start again (with the new collation.)
OPTION 2
Use...
January 7, 2009 at 9:53 am
Your solution suffers from a rather obvious defect: it doesn't handle views
Look at the title...Tables referenced by a stored proc!
It does what it says on the tin....and there's a warning...
January 5, 2009 at 12:47 am
Hi Doug,
I confirm (as I mentioned in the article) that table names which are commented will be picked up.
The script does a purely textual search on the stored procedure (the...
January 2, 2009 at 6:23 am
Hi Carlo,
I've just tried out your latest post, compared against my script.
Against a (random) sample stored procedure, yours retrieves 9 tables (listed below)
ATTR_LN_PTF_BENCH
BENCHMARK
D_TIME
PORTF_SHARE
PORTFOLIO
PORTFOLIO_PERFORMANCES
S_PORTF_SHARE_PERF
SHARE_PERF_SETTING
T_SHARE_CLASS
whereas mine retrieves 13 tables (also listed)
ATTR_LN_PTF_BENCH
BENCHMARK
D_TIME
PERF_CALENDAR
PORTF_SHARE
PORTFOLIO
PORTFOLIO_PERFORMANCES
S_PORTF_SHARE_CARAC
S_PORTF_SHARE_PERF
S_PORTFOLIO_CARAC
SHARE_NET_VALUE
SHARE_PERF_SETTING
T_SHARE_CLASS
I've checked...
January 2, 2009 at 2:18 am
Hi Doug,
Thanks for your feedback! The table names it displays come from sysobjects which is dependent on the database you're running under i.e. the USE statement. I can't...
January 2, 2009 at 12:52 am
Hi Andy,
"One of the rules is that partitioning columns have to be a part of any unique index (as I understand it, this helps the optimizer know that it only...
December 30, 2008 at 1:14 am
Viewing 15 posts - 286 through 300 (of 389 total)