Viewing 15 posts - 40,921 through 40,935 (of 49,571 total)
lavani.sari (2/20/2009)
I want to ultimately take MCDBA ...and I know this is the starting point...
No, it's not. The MCDBA was for SQL 2000 and is retired. It has nothing to...
February 20, 2009 at 8:06 am
josephptran2002 (2/20/2009)
February 20, 2009 at 7:59 am
jcrawf02 (2/20/2009)
Lynn's labeled SSCertifiable, I'm gonna start calling him 'Certifiable' for short. 😛
Hey, what does that make me?
😀
February 20, 2009 at 7:42 am
Why are you joining on date columns? Why do you have FULL OUTER JOINS?
It's not displaying the total because there's no logic in that query to generate a total. You've...
February 20, 2009 at 7:41 am
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,...
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.
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...
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...
February 20, 2009 at 3:17 am
Config looks fine. Have you rebooted since adding the boot.ini switch?
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.
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.
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...
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.
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....
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...
February 20, 2009 at 2:19 am
Viewing 15 posts - 40,921 through 40,935 (of 49,571 total)