Viewing 15 posts - 1,186 through 1,200 (of 1,412 total)
Did you do the updates as 1000 single row updates, or one update that updated 1000 rows at once? What does your trigger do?
--
March 22, 2003 at 1:56 am
The reason this query is taking a long time to execute is probably not the fact that you join three tables, it's the last where clause:
PATINDEX('%'+@REVIEWER+'%',FDIS_CLAIMSET.EXAMINER_ID) > 0
No matter what...
March 22, 2003 at 1:48 am
Matt, dbo doesn't own databases, dbo is a special user in all databases that sysadmin logins map to. As Tim shows, set sa as owner of your databases by using...
March 21, 2003 at 10:09 am
Hmm, you must have answered while I was writing my own answer Brian. Good post however. A question for you:
quote:
SQL Server captures...
March 21, 2003 at 8:03 am
The simple answer: No, it can't be done in SQL Server. If a connection attempt fails then no row is added to sysprocesses. You can have your server audit failed...
March 21, 2003 at 8:00 am
quote:
Chrhedga, do you imply sequential / asynch versus set based?
Absolutely not (and I think you...
March 21, 2003 at 1:39 am
You could run the ddl-statement through a dynamic sql statement together with a 'USE otherdb' statement, or through a OPENQUERY link back to the same server. Why would you want...
March 21, 2003 at 1:27 am
It should, because as I said, Windows don't really need more than that half gigabyte it will get (instead of 1.6 GB without the /3GB switch). However, if you are...
March 21, 2003 at 1:25 am
Another solution is to add the rows to be added to a temporary table first, then do a single INSERT INTO xyz SELECT * FROM #zyx to insert them at...
March 21, 2003 at 1:11 am
Do you mean you have a detached database (just a single mdf file) and you need an ldf for it? If so, then by attaching the mdf a new ldf...
March 21, 2003 at 1:10 am
I don't think there is a way to test it, but you could of course issue a really simple query just to see if you get a respone. Something like:
SELECT...
March 21, 2003 at 1:07 am
Normally yes, because the memory on a Windows machine is managed in such a way that applications share the first 2 GB, while the OS uses the last 2 GB...
March 20, 2003 at 4:11 pm
I've had MySQL on my dev machine once for a project with SQL Server running at the same time. I didn't have any conflicts, but I wouldn't have it on...
March 20, 2003 at 4:07 pm
The hostname can be 'spoofed' by simply setting it to some arbitrary name in a connection string, so if you really need to log this for security reasons that wouldn't...
March 20, 2003 at 4:03 pm
Select substring(convert(char(10), GetDate(), 103), 4, 7)
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 20, 2003 at 12:35 pm
Viewing 15 posts - 1,186 through 1,200 (of 1,412 total)