Viewing 15 posts - 44,131 through 44,145 (of 49,571 total)
In 80 compat mode, none of the new 2005 or 2008 features will work. This includes (but is not limited to)
CTEs
Index Include columns
Table partitioning
OUTPUT clause
XML enhancements
CLR
TRY..CATCH error handling
DDL triggers
Ranking functions
DDL...
September 30, 2008 at 10:33 am
tfang (9/30/2008)
September 30, 2008 at 10:29 am
vanessachase81 (9/30/2008)
I am trying to join Orders.EEID to Shipping.EEID
Yes, but how does that relate to the row that you're trying to update in OrderDetails?
September 30, 2008 at 10:21 am
Don't we all.
Oh, and on SQL 2008, I get the following results for those two queries:
Subqueries: (35% cost)
Table 'Person'. Scan count 0, logical reads 45
Table 'Worktable'. Scan count 0, logical...
September 30, 2008 at 10:18 am
Are you looking to audit all data changes, or all queries run against the server?
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...
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...
September 30, 2008 at 9:50 am
What's the join between orders and orderdetails?
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)...
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...
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...
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...
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...
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...
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...
September 30, 2008 at 7:34 am
Viewing 15 posts - 44,131 through 44,145 (of 49,571 total)