Viewing 15 posts - 40,906 through 40,920 (of 49,571 total)
Steve Jones - Editor (2/20/2009)
SQL does mark the physical records in a heap, AFAIK, with something to be sure they are unique.
RID (Row Identifier). An 8 byte combination of...
February 20, 2009 at 1:05 pm
Alvin Ramard (2/20/2009)
Use [Regional Office Claims Adjudication Process-Disability (ROCAP)];
A government office? That explains everything!
Did anyone notice the one he started this morning?
http://www.sqlservercentral.com/Forums/Topic661280-338-1.aspx
Full outer joins on what appear to be date...
February 20, 2009 at 12:54 pm
Putts (2/20/2009)
Are there certain cases where distinct have always shown to increase performance?
None. It will either have no effect (if there's already an order by) or reduce performance (in all...
February 20, 2009 at 12:37 pm
GSquared (2/20/2009)
Judging by that, I'm going to say there isn't a connection between that and the SPID.
I've seen docs that say there was on SQL 2000, but not on 2005...
February 20, 2009 at 12:32 pm
Putts (2/20/2009)
February 20, 2009 at 12:32 pm
Ninja, can you please do a rough translation of these three errors?
La page (1:1407) n'a pas de référence dans la page précédente (1:1406). Possibilité d'un problème de liaison de chaîne.
La...
February 20, 2009 at 9:12 am
Mike Levan (2/20/2009)
If i cant use those procs then i may have to do regular maintanance plan as i dont have litespeed liscences anymore.
If you don't have litespeed licences then...
February 20, 2009 at 9:08 am
nikhil.verma (2/20/2009)
February 20, 2009 at 8:41 am
Wilfred van Dijk (2/20/2009)
Btw nice (new) picture of you, I didn't know you had a beard
😛
February 20, 2009 at 8:40 am
I'd love to, but I don't read French. 🙁
Any chance you can back the DB up, restore it on an english server (as a different database, don't overwrite MSDB) and...
February 20, 2009 at 8:32 am
MSDN (some versions at least) give all the editions of SQL server, but they're still just personal licences.
February 20, 2009 at 8:29 am
Mike Levan (2/20/2009)
Do you think if i migrate those it will not work??
How were you planning to migrate, seeing as extended procedures are not SQL code?
What's wrong with installing LiteSpeed...
February 20, 2009 at 8:28 am
Mike Levan (2/20/2009)
Can i just migrate those procs into my new server and perform by backups as if ido with other servers using LiteSpeed.
No.
Install LiteSpeed there if you...
February 20, 2009 at 8:19 am
Because it's not a standard extended proc. Probably created by a 3rd party backup tool.
February 20, 2009 at 8:11 am
As far as I know, the only way to encrypt a proc is to do an ALTER PROCEDURE.
ALTER PROCEDURE <Procedure Name>
WITH ENCRYPTION
AS
... rest of procedure here ...
GO
February 20, 2009 at 8:07 am
Viewing 15 posts - 40,906 through 40,920 (of 49,571 total)