Viewing 15 posts - 16,846 through 16,860 (of 22,221 total)
Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had to do that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:49 am
To my knowledge, they'll see some of the other databases available in the server, but they'll only be able to connect to and perform actions on the db's that you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:46 am
jswong05 (7/16/2009)
2005 has missing index DMVs and DMFs, I use them.:-P:cool:
But you test their results, right? Those things are notorious for suggesting poor choices on indexes. You need to exercise...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:41 am
bhuvnesh.dogra (7/30/2009)
While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server
in the instance folder "REPORT_DEV"
REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder
therer should be one more folder "Tcp"
can u please tell me how can i generate...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:38 am
gochaithu (7/29/2009)
I have some doubt's in preparation of Online Exam database.My first doubt is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:34 am
Amit (7/29/2009)
Hi Grant,As admitted by you its the hard way, so this is not preferrable and also it can result in loss of data....
Thanks,
Amit
Too true, but I always like to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:30 am
I've never run into that one before. It sounds like a bug or possibly a coding error.
I'm recreating databases pretty regularly in 2008 and I haven't seen this. Just a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 12:14 pm
Luke L (7/29/2009)
Anyone else see anything odd about this person's posting history?http://www.sqlservercentral.com/Forums/UserInfo816418.aspx
:sigh:
Not really, no.
But you know, I was just thinking... If I had RAQ Report, I think it would solve...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 9:27 am
Since someone else may have the same problem and find this thread, can you post your solution?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 9:01 am
Thanks Roy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 8:33 am
You can't refer to an alias as a column. Instead of this:
AND CONVERT (INT ,[True Arrears Balance]) > 0
You would need to do this:
AND ((CAST(TEN.[curr-balance] AS INT) + CAST(TEN.[hb-arrears] AS...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 8:32 am
You're trying to add a string to an INT field in the first query, which isn't possible. Your attempted fix is trying to convert the string to a number, again,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 8:14 am
Except of course for the hard way, create a new table with the new structure, drop all the constraints on the old table, copy the data over, put the constraints...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 7:34 am
Oh, I made the mistake of following up on his thread... encouraging bad behavior. "Bad, Grant, Bad! Down! Stay!"
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 7:07 am
It sounds like it was building out execution plans for all the recursions (guess). Instead of trying to get the execution plan by running the query in SSMS, try querying...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 6:54 am
Viewing 15 posts - 16,846 through 16,860 (of 22,221 total)