Viewing 15 posts - 37,126 through 37,140 (of 49,552 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769122-5-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
August 12, 2009 at 12:44 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769122-5-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
August 12, 2009 at 12:43 am
jason (8/11/2009)
Grasshopper
No one named 'Grasshopper' here. That's his forum ranking, just as yours is 'Valued Member'
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
August 12, 2009 at 12:38 am
It's one of the ways of moving a database's data and log files to different locations, maybe different drives. Can also be used to move a database from one server...
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
August 11, 2009 at 3:39 pm
One other piece of advice that may sound strange. If you get a job offer and find that you'll be the sole DBA, run away. Learning by trial and 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
August 11, 2009 at 2:50 pm
jason (8/11/2009)
Does that make sense, or is my understanding a little garbled ?:-)
Pretty much. I'm busy writing up a blog post that'll go into more detail.
And does that mean any...
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
August 11, 2009 at 2:47 pm
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
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
August 11, 2009 at 2:03 pm
Just realised (after checking wikipedia) that District 9 is a movie, not a TV show. According to local cinema site, it's opening here Aug 28.
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
August 11, 2009 at 1:21 pm
GabyYYZ (8/11/2009)
Any of our South African members hearing some buzz about it or has it already shown in SA?
I've heard of it, but nothing more. Doubt it's shown...
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
August 11, 2009 at 1:19 pm
Chad Crawford (8/11/2009)
Gianluca Sartori (8/11/2009)
Maybe it's time to start the "Should you use your real...
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
August 11, 2009 at 12:04 pm
shopping (8/11/2009)
Gotcha. I ran the dbcc command as:DBCC SHRINKFILE('F:\\backup\\Artesia_Prod_log.ldf',2048)
but got the error:
You need the logical name of the file, not the physical name of the file. Run this in the...
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
August 11, 2009 at 11:33 am
Top recommendations for a clustered index - narrow, unique, non-changing (not an issue in a data warehouse), ever-increasing
Based on what you've said, I'd start with cluster on date_key (the partition...
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
August 11, 2009 at 10:19 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
August 11, 2009 at 10:09 am
Ok, couple things.
By truncating the log you have broken the log chain, will not be able to take log backups and will not be able to restore to a point...
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
August 11, 2009 at 10:07 am
sp_helptext
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
August 11, 2009 at 9:09 am
Viewing 15 posts - 37,126 through 37,140 (of 49,552 total)