Viewing 15 posts - 20,281 through 20,295 (of 22,197 total)
sherlockian21 (5/30/2008)
Select *
from
(
select (top 500 row_number() OVER (ORDER BY(rank desc) as resnum, rank, description, table2.col, table3.col, table4.col
from table1 inner...
May 30, 2008 at 5:43 am
To determine what the queries are doing your friend needs to look at the execution plans. That will identify where the time is being spent and suggest possible solutions.
Also, I...
May 29, 2008 at 11:52 am
So, if I understand this correctly, the plan is to break down a title into it's component words, store each word in seperate table with a link back the title...
May 29, 2008 at 10:20 am
OK. Run Profiler. Be sure you have one of your ADO connections on line. You can just use the defaults. Check the connection settings of the ADO connections. I'll be...
May 29, 2008 at 9:13 am
So the query would run fine in SSMS, but when run from VB it times out?
May 29, 2008 at 8:46 am
If he already has a design that has 1.2 million rows and he's "considering indexing" then he's way behind the eight-ball already. I'd suggest focusing on one thing, clustered indexes....
May 29, 2008 at 8:26 am
The first thing that comes to mind... Have you updated the statistics and/or rebuilt the indexes after moving the data from 7 to 2005? It's my understanding that this is...
May 29, 2008 at 6:00 am
Everyone else has nailed it. The one other thing you might consider is using NVARCHAR(MAX) if you are potentially storing more than 50 characters. Well, more than 4000 in this...
May 29, 2008 at 5:56 am
Here's Microsoft's Life Cycle Support page. Here's the SQL Server 2005 page. We've got to 2011. Which isn't that far off.
May 29, 2008 at 5:15 am
You can't. SQL Server doesn't support cross-database referential integrity enforcement through the DRI statements. You can set up a triggers, one to check the child table in the event of...
May 28, 2008 at 12:24 pm
Do you mean something like this:
SELECT...
FROM...
WHERE...
ORDER BY CASE WHEN @MyVariable = 52 THEN Column1
WHEN @MyVariable =...
May 28, 2008 at 11:44 am
It doesn't sound like you need to worry about page splits.
I've seen situations where dropping the index and recreate it work better and I've seen places where it made things...
May 28, 2008 at 8:58 am
Short answer, it depends. If the data comes in ordered the same was as the index you'll minimize the amount of work the index has to do as it inserts...
May 28, 2008 at 8:38 am
You should look to use the TOP (1) with an ORDER BY statement. You can modify the ORDER by to get a descending value, going from highest to lowest, by...
May 28, 2008 at 5:49 am
Native speakers of any language talk much faster than non-native speakers. Ask him to slow down a bit too. That usually helps.
May 28, 2008 at 5:24 am
Viewing 15 posts - 20,281 through 20,295 (of 22,197 total)