Viewing 15 posts - 44,041 through 44,055 (of 49,552 total)
Just bear in mind that SQL 2005 is not fully supported in any virtual environment. If you encounter a problems and call Customer Support, they will probably ask you 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
October 3, 2008 at 10:50 am
binaryspiral (10/3/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
October 3, 2008 at 10:44 am
Andrew Gothard (10/3/2008)
* Well, no rules hold fast all the time. Sure someone'll think of a situation where this wouldn't be the case I'm sure
Depends how fast the 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
October 3, 2008 at 5:43 am
Does that username match the account that SQL agent runs as?
Most of the replication jobs run continually, rather than frequently starting and stopping.
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
October 3, 2008 at 5:39 am
First, run DBCC OPENTRAN and see if there's any reference to replicated and non-replicated transactions. If not, skip to the 3rd paragraph.
Drop any publication that may exist, and make sure...
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
October 3, 2008 at 5:26 am
Have you considered using the full-text search? It's one of the easier ways to do rating of matches.
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
October 3, 2008 at 5:16 am
You can read the transaction log raw if you like. It's not easy to understand though. Also it will only have up to the last log backup (in full recovery)...
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
October 3, 2008 at 4:44 am
There's no syntax errors with the function. The problem is how you're calling it.
... FROM [InfraDesk_ASP_3].[dbo].[RPT_nSLA_REPORT] ( 'All Priorities',1222799400,1225391399,null,null,('Software'),
('Client/Server Application',' Intel Engineering',' INTERNET'), ('Appliance',' Application'), ('')...
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
October 3, 2008 at 4:40 am
A history table that isn't mostly queried by date?
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
October 3, 2008 at 4:32 am
DNA (10/3/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
October 3, 2008 at 4:24 am
I think part of that got cut off. (The forum software doesn't like triangular brackets)
From what I can see, all you need to do is change the definition of the...
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
October 3, 2008 at 1:35 am
So help_publication doesn't show any result set at all?
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
October 3, 2008 at 1:32 am
To be a little pedantic...
Transaction log backups don't backup changes. They backup a list of operations that occurred since the last log backup, including the time that they occurred. 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
October 3, 2008 at 1:31 am
Hemalatha (10/3/2008)
I have seen reply of using partitions, but tats not the remedy.
Why are partitions not appropriate?
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
October 3, 2008 at 1:26 am
kotlas7 (10/3/2008)
Hi Gail Shaw,I observed that the Optimization and Intigrity checks jobs are scheduled to run at the same time.
Is this cause to fail the intigrity job?
No.
George said exactly...
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
October 3, 2008 at 1:23 am
Viewing 15 posts - 44,041 through 44,055 (of 49,552 total)