Viewing 15 posts - 26,101 through 26,115 (of 49,552 total)
jpSQLDude (5/16/2011)
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
May 16, 2011 at 8:39 am
Ninja's_RGR'us (5/16/2011)
ALTER DATABASE [PROD] SET RECOVERY SIMPLE WITH NO_WAITGO
ALTER DATABASE [PROD] SET RECOVERY SIMPLE
GO
No need for the No_Wait keyword. That's used with database setting changes that require exclusive access...
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
May 16, 2011 at 8:36 am
No locks are needed.
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
May 16, 2011 at 8:33 am
There's no need for a constraint on the int column.
Int columns only accept numeric data, someone tries to insert character data and you'll get a type conversion error long...
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
May 16, 2011 at 8:32 am
Sure it was the same DB? (seen that and done that before)
Log backup in code or GUI? If code, what command? If GUI, what options?
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
May 16, 2011 at 8:21 am
jpSQLDude (5/16/2011)
So I backed up the database (truncated the log), did DBCC SHRINKFILE against the log file, checked my VLFs with DBCC LOGINFO, etc, but log_reuse_wait_desc kept on returning LOG_BACKUP.
Backing...
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
May 16, 2011 at 7:58 am
A database attached to SQL 2005 is a SQL 2005 database in every sense of the word.
All the compat level does is tell the query execution engine what T-SQL constructs...
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
May 16, 2011 at 7:56 am
SKYBVI (5/16/2011)
Ninja's_RGR'us (5/16/2011)
#1 culprit is reindex jobI had the impression that reindex jobs increase the size of log file (ldf) not the data file(mdf)
Rebuild can increase both. The log because...
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
May 16, 2011 at 7:40 am
azhar.iqbal499 (5/16/2011)
My another Question isWe have data file of size 7.5 GB then what should be the ideal size of Log file.
No way to tell. Depends on activity, interval...
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
May 16, 2011 at 7:32 am
Ed Dasig (5/16/2011)
Anyway I will try your advised using 4...
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
May 16, 2011 at 6:52 am
naresh.talla (5/16/2011)
in my jobstep 1-- re indexing
EXEC sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")'
DBCC DBREINDEX is deprecated, should not be used for new development, will be removed in a...
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
May 16, 2011 at 6:42 am
azhar.iqbal499 (5/16/2011)
Thanks Gail,How can we bring the log file back to normal size b/c we have no log backup.
Database properties and change the file size. If the DB is...
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
May 16, 2011 at 6:23 am
Yes, as I said, if there's a pre-install rule that says it cannot be done, then I highly doubt there's any way to trick SQL into installing.
I know a lot...
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
May 16, 2011 at 6:20 am
And LoggedDT will always be passed? Does it have a time or is it just a date? What about the column in the table?
Why are partial usernames getting passed?
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
May 16, 2011 at 6:04 am
You're not giving enough info for anyone to help you. Explain what you are trying to do, we can't read your mind.
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
May 16, 2011 at 5:57 am
Viewing 15 posts - 26,101 through 26,115 (of 49,552 total)