Viewing 15 posts - 17,041 through 17,055 (of 49,552 total)
You rebuild the clustered indexes onto the new filegroup. You have 2 files in FG3. When you do a shrink with EmptyFile on one of them, the objects will be...
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 21, 2012 at 9:35 am
Don't script data. Not unless your DB's a few MB. Any more than that will kill SSMS.
Script the objects, use bcp or SSIS for the data.
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 21, 2012 at 9:19 am
The requirements are for the Always On setup. If you're willing to skip practicing that (which does need 3-5 machines), then any old computer can run SQL Server for 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 21, 2012 at 9:17 am
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1347848-146-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 21, 2012 at 9:15 am
No. You'll have to create a new file in a new filegroup, then shrink the one you want to remove with the EMPTYFILE option and then drop it. The move...
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 21, 2012 at 9:06 am
Just a note, when restoring across versions a backup will either restore correctly or it won't restore at all.
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 21, 2012 at 7:17 am
Yes.
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 21, 2012 at 6:59 am
It's the Now Reading Redux plugin. No custom dev required at all http://wordpress.org/extend/plugins/now-reading-redux/
You'll need an amazon associate ID to look up books, plus an amazon web services account (it's free)
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 21, 2012 at 6:09 am
ananda.murugesan (8/21/2012)
Is it sufficent for data tranfer to mirror server.
No way to answer that. You need to check that the network is adequate for the workload you have on your...
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 21, 2012 at 6:08 am
Synchronous mirroring (whether it's automatic or manual failover) can affect performance. Make sure that the network is adequate for the load and the mirror server is appropriately specced.
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 21, 2012 at 5:02 am
Is this what you want to do? http://sqlinthewild.co.za/?now_reading_library=true
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 21, 2012 at 5:01 am
No way to answer from that little information.
http://www.sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.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 21, 2012 at 4:41 am
If automatic failover's required then your only option (of the ones listed) is mirroring. Replication provides neither a failover mechanism nor a fail back. Logshipping the failover is manual.
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 21, 2012 at 4:36 am
No where near enough information.
What's the RTO? What's the RPO? Is automatic failover required? How difficult can the fail-back process be? What edition do you have? etc...
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 21, 2012 at 3:24 am
dwain.c (8/21/2012)
I have written some WHILE loops but they don't count.
Why not? They're just about the same as cursors just without the syntax.
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 21, 2012 at 3:21 am
Viewing 15 posts - 17,041 through 17,055 (of 49,552 total)