Viewing 15 posts - 37,486 through 37,500 (of 39,717 total)
SQL will take all the memory it thinks it needs to complete a query. If this is a large query, SQL may be caching the data to speed the update....
June 28, 2002 at 11:27 am
iif( condition, true, false)
translates to
if condition
begin
true statements
end
else
begin
false statements
end
Steve Jones
June 28, 2002 at 10:53 am
Are you looking at advanced options in sp_configure? There is nothing on lock timeout? Or perhaps query timeout?
Steve Jones
June 28, 2002 at 10:16 am
Good comment. The tests can teach you what you do not know, but they also let you validate what you do.
However, I do think they should be tougher.
Steve Jones
June 28, 2002 at 10:12 am
yes, you should place the ON after the join clause.
Steve Jones
June 28, 2002 at 10:09 am
Not sure how you'd do this. Maybe run profiler and look for activity on tables, then match this with page split data in Performance Monitor?
Steve Jones
June 28, 2002 at 10:03 am
I believe this is an sp_configure item. Check the Books Online for v6.5
Steve Jones
June 28, 2002 at 9:42 am
I thought sp_changeobjectowner would work, but it doesn't. Apparently a new datatype isn't an object, which makes some sense.
What symptoms are you seeing?
Steve Jones
June 28, 2002 at 9:38 am
Books on line has more information. The two result sets are problematic. I'd pull them using ADO or isql and then parse the text file or insert the results from...
June 28, 2002 at 9:27 am
BOL is a great resource for this type of stuff.
1. Permissions default to sysadmin and serveradmin
2. Public role, but users can only affect their procs (unless sys or server admin)
3....
June 28, 2002 at 9:24 am
Hint:
select case
when datepart() = 2 -- Monday
then dateadd( day, 5, @mydate)
when datepart() = 3 -- Tuesday
...
June 27, 2002 at 5:45 pm
Simple enough. Check the day (using datepart) and setup a case statement that will add 5, 6, 7, 8 days to the date to skip weekends.
Steve Jones
June 27, 2002 at 3:32 pm
the easiest way to do this is with an identity. For this, you would need to specify it when you create the table
create table tgt_pick_list
( pick_list_no int identity(1,1)
,...
June 27, 2002 at 2:42 pm
Only if they administer the domain (Add users, permissions, etc.). Otherwise, no.
Steve Jones
June 27, 2002 at 2:38 pm
June 27, 2002 at 1:12 pm
Viewing 15 posts - 37,486 through 37,500 (of 39,717 total)