Viewing 15 posts - 32,251 through 32,265 (of 49,552 total)
Not sure I understand, are you trying to make a database suspect or are you trying to fix a suspect database?
A missing data file won't send a DB suspect, it'll...
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
June 23, 2010 at 8:59 am
MothInTheMachine (6/23/2010)
What effect does the Query Timeout setting in SQL Server 2008 have?
There isn't a query timeout setting in SQL. There's a remote query timeout, which affects queries that SQL...
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
June 23, 2010 at 8:28 am
sree-879715 (6/23/2010)
I checked everything and tried again but not able to run the script to alter the sa login name
Why not?
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
June 23, 2010 at 8:22 am
Gianluca Sartori (6/23/2010)
You would generally want to turn
datetimecolumn = @dateparameterinto
datetimecolumn between @dateparameter AND DATEADD(day,1,@dateparameter).
Careful, the second is inclusive on the upper bound (next day at midnight). That's generally not...
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
June 23, 2010 at 8:17 am
It's worth noting that ! is the logical NOT operator.
!= : not equals
!> : not greater than
!< : not less than
http://msdn.microsoft.com/en-us/library/ms189863%28SQL.90%29.aspx
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
June 23, 2010 at 8:08 am
WayneS (6/23/2010)
Hopefully, while you are cleaning up these procedures, you're taking care of that bigger problem at the beginning of that line: "WHILE @@fetch_status"
And the one that starts DECLARE CURSOR
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
June 23, 2010 at 7:58 am
You're confusing concepts. Log chain has to do with whether you can do point in time restores (restore a database to any time) using RESTORE DATABASE and RESTORE LOG.
Recovery (restart...
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
June 23, 2010 at 7:39 am
From Books Online (SQL 2008)
!= (Not Equal To) (Transact-SQL)
Tests whether one expression is not equal to another expression (a comparison operator). If either or both operands are...
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
June 23, 2010 at 7:37 am
Maybe.
Depends what is the current bottleneck. If it's not IO, separating the data from indexes may not help. Also depends on where you're putting the files. Same spindles or separate...
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
June 23, 2010 at 7:22 am
We're not going to give you the answer to interview questions. The point of an interview is to see what you know, not what other people know.
For triggers, start with...
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
June 23, 2010 at 5:52 am
Homework? Interview questions?
The first I'm not sure what you're asking, the second is rather vague.
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
June 23, 2010 at 5:35 am
You'll probably have to get a new backup if the drive that it was on is faulty.
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
June 23, 2010 at 5:27 am
Bhuvnesh (6/23/2010)
this error generally comes when there is corruption in data.
Check the error. It's the log file that its complaining about, not the data file.
I'm not sure how valid those...
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
June 23, 2010 at 5:17 am
Apply SQL Service pack 3 to the client machine. It'll update the tools and allow SSMS to connect to SQL 2008.
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
June 23, 2010 at 4:52 am
What's the error?
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
June 23, 2010 at 4:10 am
Viewing 15 posts - 32,251 through 32,265 (of 49,552 total)