Viewing 15 posts - 16 through 30 (of 72 total)
Why do you guys even reply, just delete his/her post.
November 24, 2008 at 6:27 am
Also check for orphan users, change compatibility level to 90 after upgrade, rebuild indexes.
November 23, 2008 at 7:15 am
3. I want to find out the size of this 75000 Rows
You can dump that 75000 rows in another table and get size of that table, that would be the...
November 23, 2008 at 6:30 am
jishar (11/22/2008)
Hi,Thanks for the reply..
i need to find the size utilized on OS by the data in a specific table.
Regards,
Jishar
So are you looking for table size in the database?...
November 22, 2008 at 11:02 am
Thanks Lynn Pettis. Atleast it cleared my doubts. Thanks Paresh for asking such a question.
November 22, 2008 at 10:58 am
As mentioned Visual Studio is a great tool for debugging SP.
November 20, 2008 at 11:26 am
....
Because I would like to monitor the following, But I did not find any options to choose from sql response. If we can monitor plz advice how to do that.
1.Dead...
November 19, 2008 at 8:32 pm
I guess back up restore would work. But before you do that you need to run SQL Server Upgrade Advisor.
November 19, 2008 at 8:07 pm
November 18, 2008 at 3:23 pm
First is SQL Server Upgrade Advisor. Pls run this before you start any migration process, will make your life easy. If there are any functionality or datatype which are not...
November 18, 2008 at 1:05 pm
The field is CHAR(2)
Users enter "1", "01","4","04"
I want to display it always as "01","02","03" format.
What is the best way to do it?
You mentioned in the beginning that it's CHAR(2)...
November 18, 2008 at 12:45 pm
I guess you can try this way also.
SELECT
CASE
WHEN LEN(COLUMNNAME) <>2 then '0'+ COLUMNNAME
ELSE COLUMNNAME
END
FROM TABLENAME
Hope this helps.
November 18, 2008 at 11:55 am
As mentioned SSIS is the answer.
November 18, 2008 at 10:00 am
check out this link will give you good idea about all RAID configurations.
November 18, 2008 at 9:55 am
Viewing 15 posts - 16 through 30 (of 72 total)