Viewing 15 posts - 781 through 795 (of 1,179 total)
you can get those information from the backup of msdb database. But restore msdb into test environment and get the required information.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 23, 2010 at 4:05 am
Try second suggestions....
export it to xls and delete a few rows and improt it again with different table and see if it works.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 5:39 am
With HTTP you can do entry to your database.
Once Data will be in Database you can use any type of replication as per your business needs.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 5:06 am
I guess it would be good to get intouch with Microsoft Sales/Marketing people to have exact clarity with respect to your environment and what Microsoft is offering.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 3:17 am
Yes, Inplace upgrade is not possible in your scenario.
But you can go with side by side upgrade or as mentioned by Steve do unistall/reinstall...
In side by side upgrade you will...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 2:58 am
check this out for the disk space....
http://www.sqlservercentral.com/scripts/disk+space/66656/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 2:48 am
If you do have free sapce in the datafile than you can shrink file else you have to purge some of the data with concent with the client.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 2:40 am
Can you check data type and data in the columns you are moving.
Also try with the other xls with very few data.
Also do one more experiment like export a small...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 2:28 am
Me too... went wrong and lost the point 🙁
The term used in question is SSRS which is not used for the SQL Server 2000 and the reference is given for...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 15, 2010 at 5:14 am
There is no price difference for 32 bit Vs 64 bit for SQL Server so better go with 64 bit.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2010 at 3:49 am
I guess it's purely depend on the application you are hosting on the database, database structure, table structure etc....
I prefer you do more performance R&D by setting various fill factors...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2010 at 3:46 am
see one more article:
http://www.sqlservercentral.com/Forums/Topic306817-146-1.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2010 at 3:26 am
Above DBCC displays the status of all trace flags that are currently enabled.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 10, 2010 at 5:32 am
Hello Adi,
Your explanation is very much correct and I guess it's with respect to non clustered index. What about clustered index?
Have a nice day!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2010 at 3:35 am
Yes, sometime poor maintenance of the database is also result into similar scenario.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2010 at 3:31 am
Viewing 15 posts - 781 through 795 (of 1,179 total)