Viewing 15 posts - 46,411 through 46,425 (of 49,552 total)
Grant Fritchey (5/23/2008)
BTW, keeping this a bit on topic, I'd be perfectly happy to just study all this stuff and learn, but they do ask us to test every so...
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
May 23, 2008 at 6:40 am
Books online has some examples of triggers.
Most likely you want something like this (pseudo code only. Will not work as written)
CREATE TRIGGER trg_Audit ON <Name of table to be monitored>
FOR...
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
May 23, 2008 at 6:33 am
Profiler may help you locate where the hacks are coming from. It depends how your app is set up.
Do you have any logging implemented in the appllcaton?
Ultimatly, the only real...
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
May 23, 2008 at 4:06 am
A trigger fires only when data is changed (in the caseof an insert trigger on insert) in the table that the trigger is on.
Your trigger is only going to fire...
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
May 23, 2008 at 2:26 am
Find me a server with 100,000 TB of storage, and then we can talk.
Asking if something will have good performance is like asking how long a piece of string is....
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
May 23, 2008 at 1:31 am
Try books online.
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
May 23, 2008 at 1:10 am
I think what you need is a scheduled job.
The trigger as you've written it will select a whole bunch of data whenever someone inserts into the master..log_tbl table.
From what 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
May 23, 2008 at 1:08 am
The technical limitations are listed in Books Online.
Max size of a single file - 16 TB. Max size of a log - 2TB, max files per DB 32767, max database...
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
May 23, 2008 at 12:53 am
(Reposting my earlier comments here to keep all the discussion in one place)
Start with profiler. Run during busy periods (I would recommend you use server-side trace events rather than 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
May 23, 2008 at 12:26 am
Posted in wrong forum. Please direct replies to the following thread.
http://www.sqlservercentral.com/Forums/Topic505583-65-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
May 23, 2008 at 12:25 am
Grant Fritchey (5/22/2008)
I picked martial arts just because its something that I'm into.
What style?
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
May 23, 2008 at 12:22 am
Gordon (5/22/2008)
Understood, but I can see how one might wonder if instant file initialization makes use of sparse files...
Yup. Right now I'm wondering what could be going on.
Steven: Have 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
May 22, 2008 at 12:23 pm
Steve Jones - Editor (5/22/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
May 22, 2008 at 12:14 pm
Could you take a look see if you have any comebacks from my email also please? I'm not getting the newsletters but I do get the forum reply notifications. 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
May 22, 2008 at 12:12 pm
The system databases shouldn't be changing often, with the exception of distribution, which can always be recreated.
You shouldn't need to make frequent backups of them
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
May 22, 2008 at 11:57 am
Viewing 15 posts - 46,411 through 46,425 (of 49,552 total)