Viewing 15 posts - 42,781 through 42,795 (of 49,552 total)
Change tracking
Change Data Capture
SQL Audit
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
November 30, 2008 at 3:48 am
I typically use triggers for auditing, though that use is getting reduced or eliminated on SQL 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
November 30, 2008 at 2:49 am
You've left a lot of important information out.
32 bit? 64 bit?
What OS
What edition of SQL 2005?
How much memory does the server have?
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
November 30, 2008 at 2:49 am
Jeff Moden (11/29/2008)
Your good explanation is, of course, the most accurate... I was just trying to give a 30,000 ft overview.
No prob. I was just worried that someone...
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
November 30, 2008 at 2:45 am
Jonathan Kehayias (11/29/2008)
GilaMonster (11/29/2008)
Does anyone know if Visual Studio Express allows database projects?
Gail,
The Visual Studio Express Editions don't include database projects in them, at least the last time I checked...
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
November 30, 2008 at 2:45 am
Hmm. That almost looks like the main plan's corrupted. Can you try recreating it? Can you also try backing up to that device not using the maint plan?
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
November 30, 2008 at 2:41 am
rbarryyoung (11/29/2008)
Like everyone else, I don't know everything, even in SQL Server (well, Gail might know everything, she's pretty darn close)
Hell, no! Plenty areas I don't know well (and 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
November 29, 2008 at 3:32 pm
Two more things.
Stored procedures should not be created with the sp_ name, That's for system procedures and means that SQL will look in one of the system databases first 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
November 29, 2008 at 3:23 pm
TCP Chimney I don't know. May I suggest a google search?
As for CU9, providing you're on SP2 (which I assume you are), you can request the cumulative update from microsoft....
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
November 29, 2008 at 3:21 pm
You're passing the value invoiceid to the procedure, but you're doing nothing with it within the procedure.
If you want to use the parameter to filter the query, 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
November 29, 2008 at 3:15 pm
I'd guess there's no data for the period in 2008 within the invoices 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
November 29, 2008 at 2:57 pm
Jeff Moden (11/29/2008)
So you're saying that a derived table takes no memory?
Considering that a derived table in a query isn't usually executed in 2 steps (ie, the query processor doesn'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
November 29, 2008 at 2:50 pm
I used to have some of mine in my sig. Not a laundry list. Just 2 or 3. I put them there after a bad experience (on another forum) where...
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
November 29, 2008 at 2:19 pm
If @DateMin < @DateMax
Begin
(Select InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceTotal-PaymentTotal-CreditTotal AS Balance
That bracket right after the begin that shouldn't be there.
InvoiceDate < @DateMax+1
Meaning 1 day later than the datemax that the user...
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
November 29, 2008 at 2:06 pm
t-pinto (11/29/2008)
If @DateMin < @DateMaxBegin
(Select InvoiceNumber, InvoiceDate, InvoiceTotal, InvoiceTotal-PaymentTotal-CreditTotal AS Balance
From Invoices
Order By InvoiceDate
END
The rest looks good (other than the varchar types)
What do you want to do with the resultset...
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
November 29, 2008 at 1:56 pm
Viewing 15 posts - 42,781 through 42,795 (of 49,552 total)