Viewing 15 posts - 31,801 through 31,815 (of 49,552 total)
What recovery model is the database in?
How often are you doing log backups?
the procedure I am trying is as under :-
1) Noting down the lsn number from dbcc log(aknagar)
2)deleting 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
July 16, 2010 at 2:23 am
jeff.mason (7/15/2010)
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
July 15, 2010 at 11:03 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic953285-162-1.aspx
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
July 15, 2010 at 10:20 am
Why schedule the diff at the same time as the full?
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
July 15, 2010 at 10:20 am
The clustered index is the table, so the table with the cluster there's only one copy of the data.
The second table has only a nonclustered index, that means there's two...
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
July 15, 2010 at 10:19 am
Salmon Hunter (7/15/2010)
but is there any benefit in creating a non clustered index on the same column as the clustered index?
Virtually none.
It will be smaller, hence you may get...
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
July 15, 2010 at 10:15 am
Probably the clustered index, since the nonclustered is a second copy of the data that would have to be separately maintained.
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
July 15, 2010 at 10:07 am
Anything in the application log?
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
July 15, 2010 at 10:06 am
It won't reduce the amount of memory that the SQL process is using. It just marks internal buffers as clear, making SQL repopulate them as it needs.
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
July 15, 2010 at 10:06 am
johnnycash (7/14/2010)
if you are still interested, we could work out something for you to do the consulting remotely. Just something to think about.
In my case it's not just remote,...
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
July 15, 2010 at 10:05 am
Then may I suggest you do your own research and ask for clarifications here if necessary. Google's a great 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
July 15, 2010 at 10:04 am
Not like that.
Look up computed columns. If a computed column adheres to a list of requirements, it can be persisted and indexed.
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
July 15, 2010 at 7:52 am
Which 3rd party backup tool are you using?
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
July 15, 2010 at 7:51 am
Continues at http://www.sqlservercentral.com/Forums/Topic953050-149-1.aspx. No further replies to this thread please.
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
July 15, 2010 at 6:30 am
CirquedeSQLeil (7/14/2010)
I think this article will help to distinguish the differences and help to understand the different principles.http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/
Also: http://www.sqlservercentral.com/articles/Indexing/68439/
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
July 15, 2010 at 6:21 am
Viewing 15 posts - 31,801 through 31,815 (of 49,552 total)