Viewing 15 posts - 30,271 through 30,285 (of 49,552 total)
Stefan Krzywicki (9/30/2010)
Maybe the PM isn't good with MS Project? Show them how to modify the gannt chart.
Oh it's not that. He knows how to use Project.
Doing the work (3...
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 30, 2010 at 2:45 pm
What's Sanctuary?
In other news relating to my bitching around project management yesterday ... Spent 4 days doing crit fixes on another system, but am still expected to meet the deadlines....
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 30, 2010 at 2:26 pm
Bear in mind that in read-heavy (or read only) situations (reporting DB, data warehouse) many more indexes may be desirable than for an OLTP system.
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 30, 2010 at 2:11 pm
Hardy21 (9/30/2010)
If I have taken backup in SQL 2008 R2 - is it possible to restore the database to Sql 2008/2005 anyhow?
No.
If database compatibility is 90 and server is...
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 30, 2010 at 2:06 pm
Craig Farrell (9/30/2010)
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 30, 2010 at 1:19 pm
Because the sysdatabases view is deprecated, included only for backward compatibility with SQL 2000 and will be removed in a future version of the product.
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 30, 2010 at 1:14 pm
Ray K (9/30/2010)
Steve Jones - Editor (9/30/2010)
Mr. Celko does enjoy stretching people's patience and tolerance.
Steve, I think this is an issue, and someone really needs to talk to him. ...
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 30, 2010 at 1:09 pm
Can you just clarify first whether you mean RAID 1 when you said 'mirrored' or something else.
Also, what exactly does it mean when the logs are 'deleted'?
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 30, 2010 at 1:08 pm
Yup. You can get the version of a database with this:
DBCC TRACEON(3604)
DBCC DBINFO
DBCC TRACEOFF(3604)
The field of interest is dbi_version. Run that against master on a 2008 instance and the result...
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 30, 2010 at 11:33 am
SwayneBell (9/30/2010)
I'm told that what's happening here is that we do full backups each night. The following morning, the log files are 'deleted' and allowed to fill through the day...
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 30, 2010 at 11:14 am
I really did not need to see 'One of more drives needs to be checked for consistency' on booting my laptop today. Better not be a hard drive failure...
Edit: 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 30, 2010 at 11:06 am
Grant Fritchey (9/30/2010)
I like to play craps, as long as its with other people's money.
Blackjack's my preference. Smallish group of people at the table, not such a complex game that...
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 30, 2010 at 11:05 am
Definitely, absolutely not number 1.
Set recovery to bulk logged if that's an option. Note the recovery limitations.
Rebuild only indexes that need rebuilding
Make sure that the tran log is large enough...
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 30, 2010 at 11:01 am
Roy Ernest (9/30/2010)
On another note, who all are going for the pass summit and who all will be going for SSC Party?
Nope. Sorry. Maybe next year.
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 30, 2010 at 11:00 am
Database version 661 is SQL 2008 R2. So the client does not have a 2005 server, they have a SQL 2008 R2 server. The only versions you'll be able to...
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 30, 2010 at 10:59 am
Viewing 15 posts - 30,271 through 30,285 (of 49,552 total)