Viewing 15 posts - 40,906 through 40,920 (of 49,552 total)
dana_turcanu1981 (2/20/2009)
I need to perform some actions on every row in the table. I decide to use the cursors. I this a good idea?
On 100 000 rows? Pack lunch,...
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
February 20, 2009 at 7:35 am
Mad-Dog (2/20/2009)
can SQL Server 2005 STD 32BIT on Windows Server 2003 ENT 32BIT work with more then 2-3GB mem(the 32bit mem limit)?
Yes.
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
February 20, 2009 at 7:31 am
It means somewhere within that procedure something's trying to convert a sql_variant to varchar.
Can you post the procedure?
Why are you using SQL_variants anywhere?
How are you constructing the parameter list 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
February 20, 2009 at 7:29 am
elay (2/20/2009)
2000 RTM??? Why has this never been patched?
You're vulnerable to the Slammer worm as well as a number of other serious issues, including some bugs that cause corruption. I...
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
February 20, 2009 at 3:17 am
Config looks fine. Have you rebooted since adding the boot.ini switch?
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
February 20, 2009 at 3:14 am
elay (2/20/2009)
Microsoft SQL Server 2000 - 8.00.760
I would suggest you consider applying Service pack 4. There were a number of fixes in that service pack.
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
February 20, 2009 at 3:09 am
elay (2/20/2009)
We already drop and re-create the corrupted index, then when we run checkdb again. I attached the result.
Looks fine.
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
February 20, 2009 at 3:06 am
Could be that SQL doesn't need more than 1.7 GB. In 2005 SQL won't allocate the min memory when it starts up. That's a value that once reached the memory...
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
February 20, 2009 at 2:50 am
Are you sure all the values in the column are numeric?
While it's not perfect, try using ISNUMERIC and see if there are any columns that it considers not numbers.
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
February 20, 2009 at 2:49 am
xgcmcbain (2/19/2009)
1) When creating a primary key on a column, is it still necessary to create an index on that column? or would that index serve good another purpose?
No....
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
February 20, 2009 at 2:27 am
nishantha0 (2/19/2009)
hi i am nishanthamy database suspect how can i recovary
thanks
Please post your problem in a new thread and explain, in detail, what happened and what 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
February 20, 2009 at 2:19 am
Please don't cross post. It just wastes peoples time and fragments replies. Was it really necessary to post this five times?
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic661081-146-1.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
February 20, 2009 at 2:17 am
Please don't cross post. It just wastes peoples time and fragments replies. Was it really necessary to post this four times?
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic661081-146-1.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
February 20, 2009 at 2:14 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic661114-148-1.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
February 20, 2009 at 2:11 am
karthikeyan (2/20/2009)
i dont have any limitations,if i get admission(part time) in good university, i will join immediately.
Most will require that you are in the same country for you to study...
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
February 20, 2009 at 2:08 am
Viewing 15 posts - 40,906 through 40,920 (of 49,552 total)