Viewing 15 posts - 16,846 through 16,860 (of 22,219 total)
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
As long as you don't use the INIT clause, you can simply add differentials to the same backup file. That's not how I prefer to do it. I like the...
"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:40 am
And fill factor is applicable when creating or rebuilding an index. Once an index is operation or it gets reorganized, fill factor is no longer taken into account.
"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:39 am
Viewing 15 posts - 16,846 through 16,860 (of 22,219 total)