The thing is , in that database there is a table of size 170 Gb, with 512 columns. when i created a maintenance plan in sql server 2005 sp1, for...
Hi Satya, So, how was the Microsoft Conference. Size of the database # 390 Gb. The size of bulk inserts depends on the files we get in every day,...
Its a batch processing .It involves more bulk inserts than reads. But, this does not mean that, there are no reads, reports are generated there....
Luis, Could you plz explain the benefit of going with Option 2. What is Your opinion on this option -- Keep the Tempdb & User Databases on new big...
Hi all, Need Some Advice… Current Setup of the Databases: All “system databases†+ “reportserver & reportservertempdb†are on “ D...
Hi All, Does anyone know how can we grant a user access to only one particular job( Existing job), out of many jobs. So, that he can use that...
Its all numeric. Actually, its the result of perfmon log file. Thanks.
After i execute , got the error:Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value 'column_name' to data type...
Hi all. I have some integer data in a table which is enclosed in double quotes. But, I want to perform some sum(), avg() function on those columns,...
I rebooted the server , now i am not getting that error about the permission regarding the SQL Server service account. But, when i run the...
Database is in SIMPLE recovery mode and the database is not accessed 24x7, its not OLTP. So, i need your suggestion now satya, Like i am thinking to...
Hi all, Need some advice. I have a huge table 170 Gb of size. On that table we have 10 indexes of around 12 GB in size. The application is designed...
Hi all , Need some help... We enabled /3GB Switch from boot.ini file,and then reboooted the server and then I try to enable from SQL Server...
Hi All, Actually i m new in sql server administration. And i m in the process of building our production box with sql server 2005. ( win 2003 std )...
Thanks Deepak, Got it. Najeed
Hi Deepak, Actually, my table has around 20 million rows. So, it is not fitting in the excel sheet. I read the...
Hi satya, Below are the details: Sql server 2005 sp1 -32 bit( sql server and reporting services) Win 2003 standard sp1 Thanks. Najeed.
Hello all, Actally i posted this topic under Reporting Services section, but no reply there, so i m removed from there and posted here....
Hi all, Is there any way to check the integrity of .Mdf file before Attaching it to a database means to check whether its valid (or) not....
Hi Mohammed, Like u said , restore the database in standby mode, i did that. Because, my requirement was, i was getting a...
Separate names with a comma.
