Viewing 15 posts - 47,866 through 47,880 (of 49,552 total)
🙂 Thanks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 1, 2008 at 8:19 am
Double post. Please continue thread here
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 7:19 am
I would recommend, rather than trying to write a single query, you write three seperate stored procs, and call the one that you need from the front end.
With a stored...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 7:18 am
Please don't post multiple times for the same problem. It fragments replies and wastes people's time
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 7:15 am
For SQL 2005, the first exam you need to write is the Technical Specialist exam. After that, you'll probably want to do the IT Professional Database Developer Certification.
All the info...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 7:09 am
Did you try it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 31, 2007 at 3:39 am
Viewing 15 posts - 47,866 through 47,880 (of 49,552 total)