Viewing 15 posts - 8,131 through 8,145 (of 8,416 total)
Soki (4/29/2009)
Actually yes, when dealing with .... blah blah blah
Soki,
I don't have time for a comprehensive reply, so I would just invite you to read the other posts on this...
April 29, 2009 at 9:12 pm
Off the top of my head, I think there would be one procedure cache miss when it looks for tables owner by the user (assuming the user is not aliased...
April 29, 2009 at 9:09 pm
Jeff Moden (4/29/2009)
Well, I knew that you didn't know that I didn't know that your knew about it. 😛
I knew you were going to say that...
Jeff Moden (4/29/2009)
April 29, 2009 at 9:04 pm
Jeff Moden (4/29/2009)
Thanks, Paul. I appreciate the feedback... didn't know you already knew about it.
😎 I didn't know that you didn't know I knew about it...over to you 😉
April 29, 2009 at 8:04 pm
Lynn Pettis (4/29/2009)
I can find APP_NAME() in BOL...I can't find an entry in BOL for PROGRAM_NAME.
Hey Lynn,
I remember this from years ago - PROGRAM_NAME does work, and returns the same...
April 29, 2009 at 7:54 pm
Hi,
Just agreeing with everyone else - but strictly the poll should ask whether to include the schema name, rather than 'database owner'. On first read, I was wondering why...
April 29, 2009 at 7:44 pm
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff,
I have read that before, and use that approach currently.
When Adam asked for ideas to extend the string-split, this came to mind.
It would be interesting to compare...
April 29, 2009 at 6:27 pm
Hey Brendan,
This is a complex area, so I have some questions, as well as opinions:
Why do you feel the need to full scan? In VLDBs, a 10% sample is...
April 29, 2009 at 6:23 pm
Hey Bruce,
I would encourage you too!
You seem to have me all wrong by the way 😀
Paul
April 29, 2009 at 7:23 am
Bob Hovious (4/29/2009)
Hey... what's an "UPDATE" ?? Can I use it to increment a date?
Not in 2005.
2008 SP1 adds a much-requested feature so you can just...
April 29, 2009 at 6:55 am
(original post is here)
Dallas Martin (4/29/2009)
A trigger in this instance would hardly bring the system to its knees.
Sure, I was just pointing out that it isn't a good solution. ...
April 29, 2009 at 6:52 am
Jack Corbett (4/29/2009)
Flonternet?
:laugh: :laugh: :laugh:
Better, yes.
Paul
April 29, 2009 at 6:36 am
It's ok everyone! Crisis over! The problem is solved!!!
I will simply run this query over the interweb interface:
UPDATE records
SET UserName = 'The *real* karthikeyan'
FROM SQLServerCentral.com AS records
WHERE user_id...
April 29, 2009 at 6:33 am
Happy to help:
SELECT readily_available_info
FROM BooksOnline AS MyPrimaryReferenceBook
WHERE contents_title = 'cascading referential integrity constraints'
OR index_title = 'ON DELETE clauses'
(1 row(s) affected)
Table 'BOL'. Scan count 0, logical reads 3, physical reads...
April 29, 2009 at 6:17 am
cavellbd (4/29/2009)
i might be wrong, but cant we easily use a query like this?SELECT * FROM EmployeeHours WHERE CONVERT(VARCHAR(10), Date, 121) = '2009-06-02'
You are not wrong, but as been...
April 29, 2009 at 5:48 am
Viewing 15 posts - 8,131 through 8,145 (of 8,416 total)