Viewing 15 posts - 37,066 through 37,080 (of 49,552 total)
jacroberts (8/13/2009)
GilaMonster (8/13/2009)
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
August 13, 2009 at 12:22 pm
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...
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
August 13, 2009 at 9:25 am
Paul White (8/13/2009)
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
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.
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
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...
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
August 13, 2009 at 9:07 am
http://msdn.microsoft.com/en-us/library/ms186734(SQL.90).aspx
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
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...
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
August 13, 2009 at 8:44 am
sivark1 (8/12/2009)
pls tell how to c the o/p of the profiler
What?
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
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...
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
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...
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
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...
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
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...
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
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?
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
August 13, 2009 at 6:30 am
Did you read those articles?
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
August 13, 2009 at 5:01 am
Runs the batch 8 times
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
August 13, 2009 at 4:27 am
Viewing 15 posts - 37,066 through 37,080 (of 49,552 total)