Viewing 15 posts - 25,411 through 25,425 (of 49,552 total)
SQLRNNR (6/18/2011)
Once user tables are on a file in the primary file group can they be moved to another filegroup or are you stuck in that group?
Thanks!
No. Tables can...
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
June 19, 2011 at 12:52 pm
Jim Murphy (6/18/2011)
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
June 19, 2011 at 12:50 pm
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
June 18, 2011 at 4:58 am
Please read through this - Managing Transaction Logs[/url]
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
June 18, 2011 at 4:58 am
I'm still trying to get my laptop reinstalled. Windows, office, Visual Studio all fine. SQL 2008 won't install, 2008 R2 won't install...
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
June 18, 2011 at 2:37 am
To have SQL write simultaneously to multiple files, those files have to be in the same filegroup. SQL will never start using a different filegroup for writes.
Multiple files in one...
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
June 18, 2011 at 2:23 am
Syed Jahanzaib Bin hassan (6/18/2011)
multiple data files as well as multiple log files give you benefits on loaded servers
Multiple log files do NOT give any benefit. SQL uses log files...
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
June 18, 2011 at 2:21 am
Table variables ignore explicit rollbacks. It's a feature of theirs. Try with temp tables, you'll see what you expect.
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
June 18, 2011 at 1:58 am
Which would you prefer?
1) Finding out the backup is damaged and unrestorable right after making it, when you can make another
2) Finding out the backup is damaged after the 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
June 17, 2011 at 2:41 pm
Anyone got a magic wand? http://www.sqlservercentral.com/Forums/FindPost1127588.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
June 17, 2011 at 12:27 pm
Why?
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
June 17, 2011 at 12:05 pm
Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid advice?
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
June 17, 2011 at 11:41 am
Providing you haven't used any persistent enterprise-specific features there should be no problem.
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
June 17, 2011 at 11:40 am
Rich Yarger (6/17/2011)
Cuz you all are nuts!
Whatever gave you that idea?
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
June 17, 2011 at 11:38 am
Brandie Tarvin (6/17/2011)
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
June 17, 2011 at 11:17 am
Viewing 15 posts - 25,411 through 25,425 (of 49,552 total)