Viewing 15 posts - 181 through 195 (of 790 total)
Ok, let me say that I'm wrong and let consider the small databases!
😎
I said before that large and medium DBs have tables that the Identity Col has generated value...
January 12, 2010 at 7:24 am
brainy (1/12/2010)
on same lines can you tell me which operating system we can use...?
The best is the OS with all features like Windows Server 2008 R2 Enterprise or Datacenter editions.
January 12, 2010 at 7:11 am
S Hodkinson (1/12/2010)
Correction it was the standard edition.What are the issues with the virtual machine that it could be?
I said issue, because, it depends also what you installed in your...
January 12, 2010 at 6:53 am
Yes, it can be done with Virtual Machine installed in your only server...!
January 12, 2010 at 6:31 am
Maybe any issue with your virtual machine, but I don't believe so!
Which SQL Server edition you installed in VMachine!?
January 12, 2010 at 6:22 am
I said, because meant if you start form 1 till 2 000 000 000 will take long time (maybe 1 year on large companies like banks and telephony), I think....
January 12, 2010 at 5:51 am
...also GilaMonster has great experience with SQL Server (she's MVP also) and I think that she wrote enough info for what you ask!
January 12, 2010 at 5:19 am
Vivek29 (1/12/2010)
After 2 billion insertions or max of the datatype limit the identity column has reached what will happen and how to tackle that?
Did you reach a 2 billion records...
January 12, 2010 at 5:15 am
The Order is MCTS then MCITP, I think that you should go first with MCTS, and after that with MCITP!
January 11, 2010 at 12:01 pm
sudhakara (1/10/2010)
Are you getting error messages while starting the sql server services manually ?
As he mentioned above NO, he can starts services manually without any error msgs!
But reasons that...
January 10, 2010 at 10:44 am
Did you change your password!
If you changed your password, you should go to configure manually to start services with new password!
January 10, 2010 at 9:04 am
I think one of the solution is to use Row_number() function but for more precise result, please post table structure and some sample data as GilaMonster said!
January 10, 2010 at 2:46 am
January 9, 2010 at 9:41 am
Viewing 15 posts - 181 through 195 (of 790 total)