Viewing 15 posts - 46,201 through 46,215 (of 49,552 total)
GSquared (6/16/2008)
Say an airplane's navigation system. That must not give an incorrect result.
It depends on "incorrect". If, for example, precision exceedes accuracy, that's wasted effort.
Naturally. I probably should have...
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
June 16, 2008 at 1:22 pm
No. Use sysprocesses on SQL 2000.
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
June 16, 2008 at 10:53 am
travis.whitley (6/16/2008)
was supposed to be funny. i guess cultural references dont work on forums;)
I think we all missed the joke.
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
June 16, 2008 at 10:51 am
IDENTIFIED BY is not part of SQL Server's create role statement. The form of create role is
CREATE ROLE role_name [ AUTHORIZATION owner_name ]
so, as an example,
CREATE ROLE buyers AUTHORIZATION...
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
June 16, 2008 at 10:23 am
Is it a domain account? If so, most likely it's a scheduled job that's using a domain account to connect to your server, and that account has expired within Active...
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
June 16, 2008 at 10:09 am
noeld (6/16/2008)
tmbasha (6/15/2008)
S.No.TableData Size(GB)Index Size(GB)Total No of Indexes3.X33753
... 53 indexes in one table? ... 🙁
Ouch. 3 GB data and 7GB indexes. I hope it's a read-only table
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
June 16, 2008 at 10:01 am
samuel_yanzu (6/16/2008)
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
June 16, 2008 at 9:40 am
You can decrypt them. Both SQL 2000 and SQL 2005, though the methods are different.
A google search should dig up more information for 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
June 16, 2008 at 9:23 am
Steve Jones - Editor (6/16/2008)
Functionality has to be 100%. Or what the client needs the software 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
June 16, 2008 at 9:12 am
Tomorrow. You're leaving things a bit to the last minute, aren't you?
Write up a high-level summary on what you need to say. Include major points and some rough notes on...
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
June 16, 2008 at 9:09 am
jcb (6/16/2008)
I guess the better way do do it is create TWO SPs and let the app chose one or another...but the developer don't want to change some VB6 dlls...
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
June 16, 2008 at 8:49 am
Ah. Now I see what you're getting at.
I'd probably call that a macro-type replacement than an inline function, but that's just nomenclature. Probably more of a parser enhancement than an...
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
June 13, 2008 at 7:28 am
I'm sorry I misunderstood you. If you're willing to explain more what you mean (or link to DB2 documetation) I'll try and help.
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
June 13, 2008 at 5:57 am
You mean like this?
create function dbo.cube(@x float)
returns FLOAT AS
BEGIN
return( @x * @x * @x )
END
GO
SELECT dbo.cube(4)
😉
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
June 13, 2008 at 5:34 am
I can't imagne a TechEd with 10000+ people. The local one is max 1200. PASS 2 years ago seemed huge to me, with a bit under 3000 people
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
June 13, 2008 at 5:29 am
Viewing 15 posts - 46,201 through 46,215 (of 49,552 total)