Viewing 15 posts - 47,536 through 47,550 (of 49,571 total)
Subqueries in the select clause (corrolated sub queries) have a tendency to perform very, very badly. Unless the optimiser is really smart (generally only on simpler queries) the subquery can...
January 30, 2008 at 11:28 pm
Linked server drivers use the MemToLeave area. I've had a case of a buggly driver leaking memory in MemToLeave and causing slow backups and eventually a system crash.
The thread stacks...
January 30, 2008 at 11:15 pm
Adam Bean (1/29/2008) Two different SQL Server support techs informed me that issuing a DBCC DBREINDEX, ALTER INDEX REBUILD/REORGANIZE, will NOT update the statistics with fullscan. They recommended having a...
January 30, 2008 at 1:36 pm
Miranda Johnson (1/30/2008)
January 30, 2008 at 1:09 pm
Pretty much, assuming the table tower.nbdoc exists.
You just need to specify the column names for the insert and in the select. eg
INSERT INTO ATable (Col1, col2, col3, col4)
SELECT Value1, value2,...
January 30, 2008 at 1:07 pm
gova (1/30/2008)
You beat me on that Gilamonster when I was typing the sample code.
🙂 I'm feeling a bit lazy tonight, so very simple sample code
BTW.
order by case when @sortorder...
January 30, 2008 at 1:05 pm
Yes and no.
I prefer not to force row locks unless I know that only a very small number of rows are going to be updated. Preferably tune the trigger so...
January 30, 2008 at 12:39 pm
Then you can try something like this.
select col1, col2 from
(Select distinct col1, col2, col3 from sometable) subquery
order by case when @sortorder = 1 then col1 else col3 end...
January 30, 2008 at 12:29 pm
aruram (1/30/2008)
January 30, 2008 at 12:24 pm
1st suggestion - rewrite the trigger and remove the cursor.
2nd suggestion - same as the first. 😉
What's the idea behind the trigger? What are you trying to do when the...
January 30, 2008 at 11:57 am
Matt Miller (1/30/2008)
If the procedure in MASTER is marked as a system stored proc, then it overrides the...
January 30, 2008 at 11:48 am
DonaldW (1/30/2008)
Significantly slower than you saw in your test.
Probably because you cleared the cache. I tend to prime the cache before running tests (run the query once so that I...
January 30, 2008 at 11:41 am
Also note that truncating a log (removing inactive log entries) and shrinking the log (reducing the size on disk) are two separate things.
January 30, 2008 at 11:37 am
goran (1/30/2008)
Gail, when you have found one (1!) application in the whole universe that uses the same name on a system stored procedure as on...
January 30, 2008 at 11:36 am
Viewing 15 posts - 47,536 through 47,550 (of 49,571 total)