Viewing 15 posts - 35,071 through 35,085 (of 49,552 total)
So it's not a login failure. The connection request is never reaching SQL. If it was, there would be a 'login failure' in the error log.
Is there a firewall between...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 8:06 am
After upgrading:
Set the page verify option to CheckSum
Run DBCC UpdateUsage
Update all statistics WITH FULLSCAN
Rebuild all indexes (writes the checksum on all index pages)
Run a DBCC CheckDB with the Data_Purity option
Set...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 7:22 am
Bhuvnesh (12/29/2009)
group by acct_id , evt_stub , cont_stub
having count(1) = 1
With above query , there is index scan but there is clustered index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 7:16 am
Post the queries please plus the two execution plans, one from running it as a query, one from running it via sp_executesql. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 3:37 am
Looks like you're trying to restore over the existing database. Don't. Drop the corrupt database and restore the new one from scratch.
Post the restore command that you're using.
Do you have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 12:07 am
Query sys.databases for the state.
Open the SQL error log and look for messages relating to that DB. If you see things like
"Recovering database <db name> (phase 2 of 3) Estimated...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 12:05 am
As the error says, run this and post the full results.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2009 at 12:00 am
What's the SPID? I'm going to guess it's way under 50. Means it's a system process and can be ignored.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 11:59 pm
WayneS (12/28/2009)
GilaMonster (12/28/2009)
WayneS (12/27/2009)
4. Open a new query. Connect as "ADMIN:ServerName" - login fails.
With what message? Check the error log for the reason that the login failed. Should a non-zero...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 11:51 pm
ravi_m_s (12/28/2009)
select substring(cast(44.8730084 as varchar),1,4)+'%'
Why would you want to convert to a varchar just to round a number off? String conversions are expensive operations.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 2:06 pm
jcrawf02 (12/28/2009)
heck with gaming, this looks to me like a way to change computer interfacing.
Precisely why I want it for the PC. Xbox and gaming is all well and good,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 2:04 pm
What kind of triggers are you talking about?
A DML trigger (insert/update/delete) will be in the triggers folder under the table that it's created on.
A database-scoped DDL trigger will be in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 1:13 pm
WayneS (12/27/2009)
4. Open a new query. Connect as "ADMIN:ServerName" - login fails.
With what message? Check the error log for the reason that the login failed. Should a non-zero state for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 1:09 pm
Bru Medishetty (12/28/2009)
Thinking about games remind me of this fantastic one from Microsoft, it's called Project Natal.
Not a game though. A new controller (motion sensor, face recognition, etc) for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 11:11 am
Matt Miller (#4) (12/28/2009)
GilaMonster (12/28/2009)
Am currently replaying BG1 (it aged very well) and have craving to replay KotOR or KotOR 2
I've been thinking of picking up BG1 again. Perhaps...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2009 at 10:58 am
Viewing 15 posts - 35,071 through 35,085 (of 49,552 total)