Viewing 15 posts - 37,636 through 37,650 (of 49,552 total)
isabel (7/15/2009)
Does your command for MIRROR TO DISK supported by MS SQL Server 2000?
No, but you posted in the 2005 forum, that's why I specified 2005 features.
On 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
July 15, 2009 at 2:24 am
A friend sent me this, I thought people here might get a laugh out of it.
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
July 15, 2009 at 2:00 am
Do not delete the log file. The transaction log is not an optional piece of the database, it's not an error log. It's critical in ensuring database integrity and there's...
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
July 15, 2009 at 1:33 am
isabel (7/15/2009)
BACKUP DATABASE [Northwind] TO DISK = '\\externaldevice\databasename.bak',
DISK='\\serverB\databasename.bak'
WITH INIT , NOUNLOAD , NAME = N'northwind backup',...
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
July 15, 2009 at 1:29 am
A SQL instance needs exclusive access to its data files, hence only one SQL instance at a time can be using a particular data file.
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
July 15, 2009 at 12:33 am
No. That would be the data integrity task.
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
July 15, 2009 at 12:29 am
Jeff Moden (7/14/2009)
Something else is going on as well. Look at the difference in durations on your machine compared to mine.
Look at the difference in reads as...
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
July 15, 2009 at 12:28 am
Slick84 (7/14/2009)
Hi,I want to know how long does it take for the "Begin Transaction" in SQL Server 2005 to time out?
It doesn't timeout. If you start a transaction and...
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
July 14, 2009 at 2:21 pm
GSquared (7/14/2009)
Tropical beach for me, I think
Niiiiiiice!
I haven't ever been there. It is on my list of planned holiday destinations. Sometime.....
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
July 14, 2009 at 2:17 pm
Jan Van der Eecken (7/14/2009)
Are you saying I'm out of the office at an inapproriate time?
It's 10pm. What self-respecting IT person is not still working at this .... oh wait,...
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
July 14, 2009 at 2:13 pm
Jan Van der Eecken (7/14/2009)
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
July 14, 2009 at 2:11 pm
Interesting. I tested with profiler and the durations were much the same as I saw with stats time. The insert into with the cluster existing was faster by a factor...
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
July 14, 2009 at 2:01 pm
And schedule regular backups of the system databases. Weekly's probably enough, unless you make lots of changes to the system databases.
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
July 14, 2009 at 1:49 pm
I'm not too familiar with mirroring, but I'd be surprised if you could back the log up on the mirror. If you can, it shouldn't affect anything. It's the principal...
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
July 14, 2009 at 1:48 pm
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Auto-shrink-e28093-turn-it-OFF!.aspx
http://www.straightpathsql.com/blog/2009/1/6/dont-touch-that-shrink-button.html
http://www.straightpathsql.com/blog/2009/6/18/a-picture-that-says-dont-shrink-and-other-things.html
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
July 14, 2009 at 1:06 pm
Viewing 15 posts - 37,636 through 37,650 (of 49,552 total)