Viewing 15 posts - 47,881 through 47,895 (of 49,571 total)
Matt Miller (1/1/2008)
You must have slept through that part of the 431 prep...:)
OK, I will admit I didn't do the 431 training. Did do all of the SQL developer training...
January 1, 2008 at 11:59 pm
Have you tried them?
Run them both with the execution plan enabled and see which SQL says has the higher cost. See which (if either) runs faster, and see which (if...
January 1, 2008 at 11:30 pm
Jeff Moden (1/1/2008)
what a "Triangular Join" actually is? They just don't teach the good stuff in the schools that are supposed to...
I haven't seen a course that...
January 1, 2008 at 1:55 pm
In doesn't work with a variable that contains a comma-delimited field. Your best option would be to split up the string with a table-valued function then use IN (SELECT ......
January 1, 2008 at 11:42 am
🙂 Thanks.
January 1, 2008 at 8:52 am
The inserted and deleted tables are only available inside triggers. In a trigger, you can select from them just like any other table.
January 1, 2008 at 8:19 am
Double post. Please continue thread here
January 1, 2008 at 6:05 am
Forgive me for again directing you elsewhere, but I wrote on this just a couple days ago
http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/%5B/url%5D
Again, if you have more questions, I'll be very happy to answer them.
January 1, 2008 at 6:04 am
karthikeyan (12/31/2007)
How to beefup our resume ?
Don't. A resume should be short and to the point. If I'm looking at a resume, there are three things I'm looking for.
1) Your...
January 1, 2008 at 3:52 am
And your QA environment (at the least) should have close to the same amount of data as the production. This is so that you don't get queries that run fine...
January 1, 2008 at 3:29 am
http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/%5B/url%5D
If you still have any questions, post them and I'll be happy to help.
January 1, 2008 at 3:26 am
Just before the MM_editCmd.Execute, could you add
response.write MM_editQuery
and post here the query that is written out?
January 1, 2008 at 3:23 am
A recursive CTE is perfect for this. This may not be 100%, but should give you the idea.
;WITH RecursiveEmployees (Emp, Supervisor, Dept) AS
(
SELECT Emp, Supervisor, Dept FROM Employees WHERE...
December 31, 2007 at 8:41 am
I will strongly agree with your last point. I've seen that over and over again, often with complaints about favouritism from those who don't focus on their careers.
December 31, 2007 at 7:42 am
It is possible to mark a procedure as a system procedure. It requires updating the system tables.
Modifying the system tables is not a good idea. It is a very...
December 31, 2007 at 7:19 am
Viewing 15 posts - 47,881 through 47,895 (of 49,571 total)