Viewing 15 posts - 19,696 through 19,710 (of 49,552 total)
drew.georgopulos (3/18/2012)
1) How can i know how often and by who a database object (table, view, function procedure) is selected, inserted, updated, deleted or called
Monitor (extended events, profiler, DDL triggers,...
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 18, 2012 at 6:22 am
pamarnath.basis (3/17/2012)
Can anyone explain how the data is stored into the disk with detail information.
By details, I assume you want me to write a couple hundred pages on it? That'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
March 18, 2012 at 5:56 am
Before you do anything...
What is the exact state of the database (check state_desc in sys.databases)
What error message are there for the DB in the SQL error 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
March 17, 2012 at 2:56 pm
shovankar (3/16/2012)
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 17, 2012 at 2:48 am
kl25 (3/16/2012)
Looking at the tables, it seems as though the non-clustered index on MO_ID could be dropped since it's the first column in the clustered index. When...
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 16, 2012 at 2:31 pm
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 16, 2012 at 1:04 pm
Koen Verbeeck (3/16/2012)
Back on-topic:http://www.sqlservercentral.com/Forums/Topic1268199-391-1.aspx
Or am I working with SQL too long to realize this is an ordinary beginner's question? Am I asking too much?
Or this one (same OP)?
http://www.sqlservercentral.com/Forums/Topic1268137-391-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
March 16, 2012 at 9:01 am
MysteryJimbo (3/16/2012)
GilaMonster (3/16/2012)
MysteryJimbo (3/16/2012)
Not the best wording.Feel free to improve on it.
Meant the question
Ah. Looking at the OP's other questions (about file and filegroup backups), I'm guessing he's asking about...
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 16, 2012 at 4:56 am
Might do.
This is going to take a fair amount of analysis to work through. Will try to make time, but won't be today.
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 16, 2012 at 4:37 am
MysteryJimbo (3/16/2012)
Not the best wording.
Feel free to improve on it.
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 16, 2012 at 4:32 am
So in other words you have no indexes. No wonder it's slow. See the recommendations that I made in an earlier 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 16, 2012 at 4:29 am
No, as I said you'd have to apply log backups to bring the restored filegroup up to exactly the same point as the rest of the DB, and that would...
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 16, 2012 at 4:28 am
I recommend to start with create the following indexes:
Table Trade: InvestorACRef, Status, TradeDate, include NetAmount, Instrument, TransactionType
Table TransactionHead: AccountRef, IsReversal, TradeDate Include Status, NetAmount, TRansactionType
That should get you a major...
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 16, 2012 at 4:27 am
Table definitions and index definitions 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
March 16, 2012 at 4:20 am
In addition to the costs of re-developing any application (and believe be, unless you're doing nothing more than trivial queries that is a huge amount of work), they also need...
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 16, 2012 at 4:19 am
Viewing 15 posts - 19,696 through 19,710 (of 49,552 total)