Viewing 15 posts - 9,211 through 9,225 (of 49,552 total)
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
April 25, 2014 at 1:28 pm
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
April 25, 2014 at 1:26 pm
Another job I wouldn't qualify for. The T-SQL and basic Pl-SQL are fine, however I don't meet any of the front end coding requirements.
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
April 25, 2014 at 4:23 am
I'd second the 'restore from last good backup', but might be possible to hack-attach the database. Last resort though.
http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-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
April 25, 2014 at 1:33 am
Eirikur Eiriksson (4/24/2014)
How about using the TABLOCK hint?😎
May or may not be sufficient, depending on the code (which we haven't seen), and not necessarily the best option.
There are many ways...
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
April 25, 2014 at 1:32 am
smtzac (4/24/2014)
My question is this a normal logfile size of 585GB Datafile? any suggestions to reduce log file size besides SHRINKFILE?
Why do you want to shrink the file? What...
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
April 24, 2014 at 2:57 pm
On what aspect of it specifically?
Have you read Kalen's whitepaper on it? Have you read the many blog posts from the SQL dev team or people who have played with...
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
April 24, 2014 at 11:18 am
rodjkidd (4/24/2014)
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
April 24, 2014 at 11:09 am
Steve Jones - SSC Editor (4/24/2014)
GilaMonster (4/24/2014)
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for...
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
April 24, 2014 at 11:05 am
SQL_Surfer (4/24/2014)
If we go that route now, it can mess up reports and other files that we already sent to the client.
Why?
Any other options you can think of?
...
Or use...
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
April 24, 2014 at 11:01 am
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for Bits, and planning on it.
Yay!
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
April 24, 2014 at 10:18 am
Make the column an identity? Or use a sequence?
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
April 24, 2014 at 10:11 am
david.john.gilligan (4/24/2014)
ALTER ANY CONNECTION is exactly what I needed!!
Err.. Thanks.
I have no idea which post you're referring to, but you're welcome.
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
April 24, 2014 at 10:07 am
Finally making some progress on at article on premature optimisation. Anyone willing to be a proof-reader? Hopefully will be done this week or next.
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
April 24, 2014 at 10:04 am
I'd start by looking through other procedures to see if there's any which drop and recreate that table. Sounds like there might be another procedure which does a DROP TABLE......
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
April 24, 2014 at 10:02 am
Viewing 15 posts - 9,211 through 9,225 (of 49,552 total)