Viewing 15 posts - 37,081 through 37,095 (of 49,566 total)
jswong05 (8/13/2009)
ANSI SQL92 is the other code, instead. which will work for Oracle adn other SQL-92 DBs. Microsofter always uses tactics to push other people away, reader beware. :hehe:
Oh, so...
August 13, 2009 at 9:25 am
Paul White (8/13/2009)
August 13, 2009 at 9:22 am
Exactly the scenario that the OP asked about. Finding the 3rd row ordered by some criteria.
Anther use is assigning unique values to rows in a resultset, perhaps for paging.
August 13, 2009 at 9:22 am
vishal sharda (8/13/2009)
but do you mean to say that row_number returns only the row number.
It doesn't return the row number because SQL doesn't have any concept of a row's...
August 13, 2009 at 9:07 am
August 13, 2009 at 8:48 am
Can't help much, but root cause is that some other app's listening on the SQL port. Only one app can listen on a port at a time (AFAIK). First st4ep...
August 13, 2009 at 8:44 am
sivark1 (8/12/2009)
pls tell how to c the o/p of the profiler
What?
August 13, 2009 at 8:14 am
Do you have a clean backup? (backup from before this problem started) This is not a repairable error.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/. There's a section towards the end...
August 13, 2009 at 8:10 am
I would suggest change the reindex to switch to bulk-logged instead of simple then back to full afterwards. The log will still grow, be prepared for that, but the log...
August 13, 2009 at 7:54 am
Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It may go unnoticed...
August 13, 2009 at 7:54 am
dal hit (8/13/2009)
What knowledge / key points the interviewer is looking in the candidate in relation to above skills ?
In my experience, statements like that mean they want someone who...
August 13, 2009 at 7:36 am
Please run the following and post the full output.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup of this database?
August 13, 2009 at 6:30 am
Run repair with allow_data_loss (it won't actually lost any data in this case). Those may be errors left over from before the service pack was applied.
If, after repairing you...
August 13, 2009 at 4:22 am
Viewing 15 posts - 37,081 through 37,095 (of 49,566 total)