Viewing 15 posts - 44,116 through 44,130 (of 49,552 total)
Are you looking to audit all data changes, or all queries run against the server?
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
September 30, 2008 at 10:17 am
Grant Fritchey (9/30/2008)
I must be regurgitating bad stuff again. Sorry. It's when it's a delimited list that it behaves like that, right?
You mean something like this?
select ProductID from Sales.SalesOrderDetail 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
September 30, 2008 at 10:07 am
yulichka (9/30/2008)
Transaction logs should be two seperate jobs one for system, one for user right? Thank you
Most (if not all) of the system databases are in simple recovery model and...
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
September 30, 2008 at 9:50 am
What's the join between orders and orderdetails?
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
September 30, 2008 at 9:49 am
Try something like this:
UPDATE OrderDetails
SET ShipID = LatestShipping
from OrderDetails INNER JOIN
(Select EEID , MAX(Shipping.ShipID)...
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
September 30, 2008 at 9:30 am
Clustering is for redundancy of the entire server, mirroring is for redundancy of individual databases. They both have their place and neither is a replacement for the other.
Neither is a...
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
September 30, 2008 at 9:21 am
I prefer integrity before database backup, as there's no point in backing up a corrupt database.
Log backups shouldn't go in the same maint plan, as you need to run 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
September 30, 2008 at 9:15 am
Grant Fritchey (9/30/2008)
IN basically is an OR statement. It's one of those hidden RBAR (row-by-agonizing-row, TM: Jeff Moden) operations because it's going to check each row of the IN...
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
September 30, 2008 at 8:55 am
I think that it was a tinyint in SQL 7 or earlier. I know it was at one point.
It's a full int in SQL 2008 (at least if you look...
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
September 30, 2008 at 8:45 am
Jason Crider (9/30/2008)
So how would you work that in practice?Do you setup a standard where you say the linked server name is the same in dev and prod?
Just so. I...
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
September 30, 2008 at 7:44 am
Checkpoint doesn't happen once a day. Do you perhaps have an agent job that kicks off around the same time?
The frequency of the checkpoint is determined by the amount of...
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
September 30, 2008 at 7:34 am
I'd use linked servers, ensure that the linked server name remains the same and change where it points when necessary.
Bear in mind though, that if you use linked servers...
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
September 30, 2008 at 7:23 am
Vladan (9/30/2008)
DECLARE @newvar varchar(8)
IF @APRIORITY = 1 THEN
SET...
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
September 30, 2008 at 7:10 am
There's a very detailed look at this in one of the chapters of the book "Practical troubleshooting: The database engine", edited by Ken Henderson. The book's well worth buying.
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
September 30, 2008 at 7:08 am
Take the THEN keyword out (as SQL does not use THEN in its if statements) and replace ELSEIF with ELSE IF and your query should work as you intend.
Also 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
September 30, 2008 at 7:07 am
Viewing 15 posts - 44,116 through 44,130 (of 49,552 total)