Viewing 15 posts - 23,446 through 23,460 (of 49,552 total)
p.s. http://support.microsoft.com/kb/105763
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
September 19, 2011 at 7:18 am
WayneS (9/19/2011)
The Oops.txt file is EMPTY???? (At least Windows Explorer shows it to be 0 bytes, so this is consistent.)
Yes it is. If you take the DB offline or stop...
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
September 19, 2011 at 7:16 am
You cannot make any changes to the default trace. You can't change the name of the files, number of files, size of files or events in any way.
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
September 19, 2011 at 6:45 am
Unless there's something in your SQL code that's time-dependant (do check), it won't have any effect.
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
September 19, 2011 at 6:39 am
PaulB-TheOneAndOnly (9/19/2011)
As a rule of thumbs, your partitioning strategy should help either Performance or Archiving/Purging - if your strategy doesn't help at least one of those processes forget about partitioning.
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
September 19, 2011 at 5:25 am
Please note: 6 year old thread
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
September 19, 2011 at 3:56 am
Both 1 and 2 have the same answer: 'It depends'
Depends why you are partitioning, what the usage of the table is, the access patterns of the DB and a few...
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
September 19, 2011 at 3:55 am
If the database is in full recovery, you can buy Apex SQL Log (~ $1000). If the DB is in simple recovery, the log records may have been overwritten already.
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
September 19, 2011 at 3:50 am
Do those two files exist? Does SQL have full permission to them?
Recovery Pending means SQL can't start the DB due to missing files (or a few other reasons). 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
September 19, 2011 at 3:01 am
Tom.Thomson (9/18/2011)
SQLRNNR (9/18/2011)
Tom.Thomson (9/17/2011)
Lynn Pettis (9/17/2011)
We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???
Out of date Lynn, we are now going...
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
September 18, 2011 at 1:06 pm
For some general silliness...
CREATE DATABASE [Oops]
ON PRIMARY (
NAME = N'Oops', FILENAME = N'D:\Develop\Databases\Oops.txt:Data'
)
LOG ON (
NAME = N'Oops_log', FILENAME = N'D:\Develop\Databases\Oops.txt:Log'
)
GO
Data files, what data files? 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
September 18, 2011 at 12:58 pm
Ok, so what exactly is it that you're stuck on?
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
September 18, 2011 at 10:18 am
50 thread notifications since I went to bed....
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
September 18, 2011 at 4:38 am
Evil Kraig F (9/17/2011)
The request? I thought we were just hoping to break Steve's spirit in general.CRAP, I've been doing it wrong again!;-)
Knowing Steve, it'll take far more than...
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
September 17, 2011 at 1:29 pm
We don't do people's homework. You learn nothing that way.
Show what you have so far, explain where you are stuck.
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
September 17, 2011 at 12:23 pm
Viewing 15 posts - 23,446 through 23,460 (of 49,552 total)