Viewing 15 posts - 48,121 through 48,135 (of 49,571 total)
Do you have a recent database backup? How critical is the data in that table?
You have some corruption in your data file, probably a data page that's damaged.
Run the following...
December 6, 2007 at 12:02 am
Perfomance-wise it's a bad idea to change the value of parameters in a proc before using them. Confuses the optimiser's row estimates.
Rather define a local variable, set the variable's value...
December 5, 2007 at 11:39 pm
TheSQLGuru (12/5/2007)
I personally LOVE such situations (and countless others out there)!!! It is one of the main reasons my services are in such high demand. 😎
If I was contracting...
December 5, 2007 at 2:10 pm
Not from the trace itself, as far as I know. What you can do is create a lookup table with the event ids and the text values, then join the...
December 5, 2007 at 2:03 pm
Do you have the definition of the following 2 views?
Comp.dbo.vwRestrictedPPP
Comp.dbo.vwLehmanPCAggSectorsByCusip
I'll second the dislike of the top and order by. Ordering should only be done in the final select statement...
December 5, 2007 at 1:57 pm
Necrox (12/5/2007)
Now i will try the 70-441 and 70-442 to be MCITP database developer.
I found those quite a bit harder than 431. They're in a case study format and some...
December 5, 2007 at 1:52 pm
It is strongly recommended to update all stats after moving a db from SQL 2000 to SQL 2005. 2005 keeps more detailed statistics than 2000 did. The 2005 optimiser can...
December 5, 2007 at 8:36 am
Without table schema, sample data or required output, I'm taking a guess here.
SELECT A_Table.A_Acct, B, C, D....W, A_Date
FROM A_Table inner join
(SELECT A_Acct, MAX(A_Date) as LatestDate
...
December 5, 2007 at 8:22 am
Ananth (12/5/2007)
My suggestions:-1) check the index in the table i.e your query should perform index seek and scan while executing the query.
Seeks preferably, as few scans as possible.
December 5, 2007 at 4:43 am
Could be out of date statistics or fragmented indexes. Is there any blocking? If you look at the sys.dm_exec_requests, can you see if the query is waiting for anything? If...
December 5, 2007 at 1:35 am
Since they're interview questions, I'm not going into great detail. You can research more yourself
irfan.sql (12/4/2007)
1}You created a query/store proc and the output result was in 1 2 second's everything...
December 4, 2007 at 11:52 pm
noeld (12/4/2007)
You don't have to be an SQL Server Ranger to know that there is something terribly wrong with 34 indexes in one table.
I've seen worse. 38 indexes on one...
December 4, 2007 at 11:12 pm
Thanks. Will check.
I do disagree with that summary though. I've seen many, many cases where the filter (where) is applied before the join.
Looking at that, it does say 'logical phases'...
December 4, 2007 at 6:01 am
Or add a column on the excel spreadsheet that gives the question order, import that column and order by that.
December 4, 2007 at 5:59 am
Piotr Rodak (12/4/2007)
There is something not right with the database logic, when it depends on physical order of data.
It doesn't. In SQL physical order of data is completely irrelivent....
December 4, 2007 at 5:38 am
Viewing 15 posts - 48,121 through 48,135 (of 49,571 total)