Viewing 15 posts - 151 through 165 (of 178 total)
Other than creating test tables and data, I just trimmed your code and did not change any logic. The table names are not relevant.
The only part of...
December 22, 2007 at 7:06 am
The join condition gives you everything in the second table matched on Hierarchy and does not take into account the coursecode.
so for every sessionname record in your...
December 21, 2007 at 9:16 pm
I agree 20 minutes for a thousand rows is a lot of time. If they would post the query, some data, schema information, etc then people could look...
December 21, 2007 at 11:06 am
Thanks for a great article Buck. I too, like Andy, am changing careers in a later stage of life. In the past I was a system...
December 21, 2007 at 10:45 am
In order to stay in your security scheme, could you put the code to insert the new rows into an sp supplying the number of inserts to do as a...
December 21, 2007 at 10:24 am
You could also try to split the query into multiples so you get an interim result set. This requires ordering the results so you get consistent output (also the...
December 21, 2007 at 9:51 am
You probably thought of this too but just to state the obvious. You could add a column, do the insert(s) then drop the column.
Toni
December 21, 2007 at 8:51 am
You could try the FAST n option for Select
For cursor....
SQL: sp_configure cursor threshold for SQL cursors can allow async fetch http://msdn2.microsoft.com/en-us/library/aa172570(SQL.80).aspx
EXEC...
December 21, 2007 at 8:04 am
This sounds like homework so I will give you guidance and you should be able to get the answer.
I have a table product with a field productid.
First,I have to calulate...
December 21, 2007 at 7:21 am
Thanks Sergiy. The GROUP BY was left over from having an aggregate function in the SELECT statement that I was using to test to make sure I got...
December 20, 2007 at 10:05 pm
Thanks Bill. /* added a little more */
I did see a post out on microsoft support about using MAXDOP 5 as an OPTION hint and tried that...
December 20, 2007 at 1:03 pm
If you do a UNION ALL you will get all the rows and take less resources as there is no need to sort out the DISTINCT rows.
There are also...
December 18, 2007 at 9:47 am
Hi.. try this.... change the TOP 3 clause to be TOP ( the number of invoices for each account) you want. It worked for what I tried.
DECLARE@Sample...
December 18, 2007 at 8:48 am
Hi. From the BOL.... you have to remove the access to the DB for the id before it can become the owner.
sp_changedbowner [ @loginame = ] 'login'...
December 13, 2007 at 10:51 am
Viewing 15 posts - 151 through 165 (of 178 total)