Viewing 15 posts - 40,891 through 40,905 (of 49,552 total)
Putts (2/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 9:08 am
nikhil.verma (2/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
😛
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 8:19 am
Because it's not a standard extended proc. Probably created by a 3rd party backup tool.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 8:07 am
lavani.sari (2/20/2009)
I want to ultimately take MCDBA ...and I know this is the starting point...
No, it's not. The MCDBA was for SQL 2000 and is retired. It has nothing to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 8:06 am
josephptran2002 (2/20/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 7:59 am
jcrawf02 (2/20/2009)
Lynn's labeled SSCertifiable, I'm gonna start calling him 'Certifiable' for short. 😛
Hey, what does that make me?
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 7:42 am
Why are you joining on date columns? Why do you have FULL OUTER JOINS?
It's not displaying the total because there's no logic in that query to generate a total. You've...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 20, 2009 at 7:41 am
Viewing 15 posts - 40,891 through 40,905 (of 49,552 total)