Viewing 15 posts - 181 through 195 (of 447 total)
in SQL server 2005 result is 1.234568E+09
while in SQL 2000 result is 1.2345679E+9
Does it make any difference ?
June 29, 2009 at 10:58 am
Steve Newton (6/24/2009)
June 24, 2009 at 2:10 pm
I installed SQL Server 2008 on one machine which had SQL Server 2000 before. After installation 2000 stopped working. I have to uninstall both versions and then install...
June 24, 2009 at 2:01 pm
Good to know. I never knew this. - Disabling a nonclustered index or clustered index on a view physically deletes the index data.
June 24, 2009 at 8:23 am
Found answer after some googling. But, this is not related to SQL Server right?
June 24, 2009 at 8:21 am
P Jones (6/22/2009)
Run the performance dashboard reports and have a look at long running queries and missing indexes.
Also, check for duplicate indexes. In most the projects I had found...
June 22, 2009 at 12:39 pm
noeld (6/18/2009)
Ermm... Isn't this just a description of LogShipping ?
Yep. it is.
June 18, 2009 at 8:14 am
How come 10 % from 556 answered i.e. 55 people think Varchar and nvarchar has fixed value? var stands for varying.
June 18, 2009 at 8:11 am
Very good article and a very comprehensive approach, Scott. Was using same tech for single server but had not for multi-environment. Would definitely try out in near future.
Again,...
June 3, 2009 at 7:44 am
Good article. I am running something similar to extract report on daily basis. But, had not used Excel. Don't know if using Excel across different servers would...
June 2, 2009 at 11:42 am
Luke L (5/21/2009)
Any reason why this question's future dated to Sep 10, 2009 and posted today 2009-05-21?-Luke.
It happened before also, when future date question is posted.
May 22, 2009 at 11:17 am
Phew........I didn't get the article ! ! ! May be I am week at Mathematical analytical.
May 22, 2009 at 9:10 am
Viewing 15 posts - 181 through 195 (of 447 total)