Viewing 15 posts - 47,026 through 47,040 (of 49,552 total)
Andre T (3/31/2008)
The big picture is a bit complicated. I certainly realize set based is better but this...
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
April 1, 2008 at 9:36 am
It specified on what columns the join is done.
Same as for a normal inner/outer join between two tables:
FROM Itable1 INNER JOIN Table2 On Table1.Col1 = Table2.Col2
Just in this case it's...
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
April 1, 2008 at 9:28 am
Any backup you've made since the problem started will have the damaged page in and hence is useless for recovering from this.
How long has this been going on? Why didn't...
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
March 31, 2008 at 2:35 pm
When was your last database backup? Is the database in full recovery mode, and , if so, do you have the transaction log backups since the last full backup.
How much...
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
March 31, 2008 at 1:57 pm
mostar5 (3/31/2008)
Anyone?
Sure.
Read what I wrote above. Help us with the table structures and sample data and someone will help 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
March 31, 2008 at 1:55 pm
Statistics time outputs in milliseconds. Microseconds would be 'us'. (iirc)
SQL Server Execution Times:
CPU time = 32 ms, elapsed time = 180 ms.
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
March 31, 2008 at 10:33 am
Hmmm....
What OS are you running? Please confirm that the drive is using the NTFS file system
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
March 31, 2008 at 10:29 am
I'll be 32 this year. I started the degree 2 years ago. Got another 2-3 years to go.
I would suggest you sit down and take a look at the reasons...
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
March 31, 2008 at 10:11 am
Anshu Wadhwa (3/31/2008)
There's no such encryption/decryption software on our server , no space issues either...What else can be the problem ..?
I take it you have a similar problem.
Can you post...
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
March 31, 2008 at 9:35 am
Ignacio A. Salom Rangel (3/30/2008)
GilaMonster (2/13/2008)
Can it be optimised to take less time? Can the indexes be tweaked so that it doesn't have 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
March 31, 2008 at 7:31 am
The date time problem's easy to fix. The variables need to be converted to string to concat them with the rest of the query. They also need to be wrapped...
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
March 31, 2008 at 7:28 am
I'm not familiar with DBISAM. Can you create a linked server from the SQL Server to the DBISAM? If so, you may be able to use triggers on the staff...
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
March 31, 2008 at 6:51 am
Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.
Many of us read all the forums.
Please don not reply to this thread, but direct comments 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
March 31, 2008 at 6:50 am
The profiler Gui will show duration in either milliseconds or microseconds, depending how the option is set (tools -> Options) However it will store the duration as microseconds and, if...
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
March 31, 2008 at 6:32 am
Standard edition will install on XP, so I don't know what's wrong.
Open the Services (under administrative tools) and see if you have any services with names like
SQL Server (MSSQLSERVER)
Or
SQL...
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
March 31, 2008 at 6:29 am
Viewing 15 posts - 47,026 through 47,040 (of 49,552 total)