Viewing 15 posts - 46,246 through 46,260 (of 49,552 total)
It's always recommended to put TempDB on its own drive, especially if it's heavily used.
The recomendations to split TempDB into multiple files is usually to avoud contention on allocation pages,...
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 12, 2008 at 2:14 am
Try the yyyy/mm/dd date format.
set @fromdate = '2008/06/16'
set @todate = '2008/07/22'
Edit:
Oh, and this is also a problem
'set @date1 = ' + @fromdate + '; set @date2 =, ' + @todate...
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 12, 2008 at 2:10 am
Check that there's no automatic log backup job running and that the log hasn't been truncated between the full backup and the log backup you took.
The error 'too recent...' implies...
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 12, 2008 at 2:07 am
If you're in simple recovery mode the log automatically truncates at checkpoints. There's nothing you need to do.
The log file contains inside it a number of log segments. These store...
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 12, 2008 at 2:04 am
Compat mode 80 just means that the SQL 2005 features are not enabled. It does not mean that the database structure is still that of a SQL 2000 database.
Underneath...
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 12, 2008 at 12:42 am
Please run a checkDB on that database.
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 12, 2008 at 12:37 am
You actually don't need trace flag 3605. Just 1222 or 1204 is enough to write the deadlock info into the error log.
1204 puts the deadlock graph into the error log...
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 12, 2008 at 12:35 am
The statistics won't be there. They are not kept on table variables.
For this reason mainly, table variables are best used for small numbers of rows. I prefer < 100.
It's 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 12, 2008 at 12:32 am
Full backups do not truncate transaction logs. If you're in full or bulk logged recovery modes, only a log backup will truncate teh transaction log and make the space available.
Since...
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 12, 2008 at 12:27 am
It still doesn't have row statistics. Run the following with the execution plan enabled
DECLARE @testing TABLE (
id INT PRIMARY KEY,
somecolumn uniqueidentifier
)
INSERT INTO @testing
SELECT number, NEWID()
FROM...
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 12, 2008 at 12:23 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to the following:
http://www.sqlservercentral.com/Forums/Topic515651-360-1.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 12, 2008 at 12:13 am
Bart Read (6/11/2008)
SQL Prompt does support this, but you need to switch it on.
:blush:
Thanks. Somehow I've missed that every time I looked at the 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
June 11, 2008 at 6:23 am
Grant Fritchey (6/11/2008)
You are quick, Gail! I haven't even been able to download the bloody thing yet, let alone get my virtual's upgraded.
Not me actually. I'll be installing it tonight....
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 11, 2008 at 6:13 am
guptaajay1985 (6/10/2008)
Please...
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 11, 2008 at 5:31 am
I just checked SQL 2008 RC0 and the intellisense (and syntax checking) only works to a SQL 2008 server. :angry:
This was one of the features I was really, really looking...
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 11, 2008 at 5:17 am
Viewing 15 posts - 46,246 through 46,260 (of 49,552 total)