Viewing 15 posts - 41,326 through 41,340 (of 49,571 total)
Then try something like this:
select top 1000 * FROM
(SELECT lc.email
l.leadid,
...
January 29, 2009 at 1:38 pm
TS stands for Technical Specialist. The 'entry level' certification.
January 29, 2009 at 1:14 pm
SG (1/29/2009)
So I tried this but am still getting duplicates - why?
select top 1000 * from (
select
...
January 29, 2009 at 1:02 pm
Can you post the queries, the table schemas, the index definitions and the execution plans with that table as part of the query? (save as a .sqlplan file, zip and...
January 29, 2009 at 12:53 pm
sqlfriend (1/29/2009)
# of files per filegroup = # of CPUs in the system?
No. Not at all. That recommendation is give for TempDB and only for TempDB and only if you're...
January 29, 2009 at 12:48 pm
If it was a deadlock, you'd be getting a different error.
Msg 1205, Level 13, State 45, Line 5
Transaction (Process ID 53) was deadlocked on lock resources with another process and...
January 29, 2009 at 12:45 pm
A deadlock won't cause a job to hang. It would cause a job to fail. Are you sure you're getting deadlocks, and not regular blocking?
January 29, 2009 at 12:45 pm
ScottPletcher (1/29/2009)
January 29, 2009 at 12:29 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic645895-145-1.aspx
January 29, 2009 at 7:29 am
What I'd suggest is, instead of sending the mail direct from a trigger (which is usually a bad idea anyway), have the trigger write the info for the mails into...
January 29, 2009 at 7:14 am
Please create a new thread for a new question, don't just tag on to the end of an existing thread.
In addition, this is a repeat of a post tagged onto...
January 29, 2009 at 7:01 am
Sounds like you're trying to restore over an existing database. If this is a migration from MSDE to SQL 2005, why are you restoring over an existing database? You should...
January 29, 2009 at 6:59 am
sudhirbharti (1/29/2009)
@OldCity= d.City
FROM deleted d
SELECT @NewCity =...
January 29, 2009 at 6:58 am
Ninja's_RGR'us (1/29/2009)
I was under the impression you were only filthy rich :D.
I wish!
January 29, 2009 at 6:39 am
Ninja's_RGR'us (1/29/2009)
Ya Grant don't rub it in, she's not a consultant anymore :P:hehe::cool:
I'm not?
January 29, 2009 at 6:25 am
Viewing 15 posts - 41,326 through 41,340 (of 49,571 total)