Viewing 15 posts - 44,101 through 44,115 (of 49,552 total)
Why do you need to rewrite?
Are they suddenly performing badly? Are they giving incorrect results?
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 1:15 pm
Same kind of thing as a select statement that has a derived table (subquery) in the from clause.
The subquery resolves to a rowset that's treated as if it were 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 1:06 pm
How big is the table in question? If I had to take a guess, I'd say it's fairly small, under 25 or so pages.
You can get the page count from...
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 12:55 pm
The query processor operates on pages in memory. If it needs a page and the page isn't there, it sends a request to the storage engine to fetch that page....
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 12:47 pm
Pro: SQL can use a lot of memory.
Con: SQL can use a lot of memory.
If you go 64 bit, make sure you set the max memory for SQL. 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
September 30, 2008 at 12:42 pm
Records won't be exactly be moved to make space.
If the row has to go onto a page and there isn't space on the page, the page is spit 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 12:39 pm
Trace to file, set a reasonable size for the files. Once a file is no longer been written to, load that into a database (preferably on a different server) with...
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 11:03 am
Luke L (9/30/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
September 30, 2008 at 10:50 am
Yup, so something like this should work
UPDATE OrderDetails
SET ShipID = LatestShipping
from 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 10:47 am
Then you're going to need some form of trace running. I recommend a server-side trace as it will have the least impact. Set up the trace within profiler, tracing 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
September 30, 2008 at 10:44 am
The reason you can't connect is that your login has, as its default DB, the database that you detached. It doesn't matter where the DB is, just that it's not...
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:38 am
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...
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:33 am
tfang (9/30/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
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?
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: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...
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:18 am
Viewing 15 posts - 44,101 through 44,115 (of 49,552 total)