http://datarealized.wordpress.com/

http://datarealized.wordpress.com/
Name: http://datarealized.wordpress.com/
Score: 97.01
Last Seen: 1028 days, 11 hours, 6 minutes ago
Member Since: 27 July, 2009
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
published 1026 days, 20 hours, 9 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1030 days, 16 hours, 22 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 3:57:49 PM GMT
Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive.  In SQL Server 2005 and earlier, you could get out of the jam quickly, by issuing a BACKUP LOG WITH TRUNCATE_ONLY (followed by DBCC SHRINKFILE).  In SQL Server 2008, this "feature" within BACKUP LOG is no longer available, and with good reason; however, there are other - shall we say, "clever" - ways to achieve this.  But too many people pass this advice off casually, and this gives p... (more)
category: Management | clicked: 3 | comment | | source: sqlblog.com
tags: LogFile, LOGS, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
published 1027 days, 20 hours, 13 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1030 days, 16 hours, 39 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:41:35 PM GMT
The Rambling DBA: Jonathan Kehayias : Digging into the SQL Plan Cache: Finding Missing Indexes
This is one of those topics I planned to blog about a long time ago, but never actually got around to it, and consequently I keep having to hit search engines to find the code I provided in a forums post when I need to use it again.  A while back, I helped fellow SQL enthusiast Jeremiah Peschka (@peschkaj) out via twitter with finding plans that included missing index information in them.  Then a bit later I used the same code on a Forums Post and then again with Michelle Ufford (@sqlfool) who actually t... (more)
category: Analysis | clicked: 0 | comment | | source: sqlblog.com
tags: analysis, Performance, plan cache, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Move non clustered indexes to a new filegroup « Data Realized – The Blog
published 1027 days, 20 hours, 13 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1030 days, 16 hours, 45 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:35:22 PM GMT
Move non clustered indexes to a new filegroup « Data Realized – The Blog
So, over the years I have needed to move an index or a set of indexes to a new or different file group. I’ve written scripts for this in the past and lost them along the way and I couldn’t find anything out there on the bing or google interwebs. The concept of multiple files and file groups for a database is beginning to sink in with a lot of developers and dba’s. The rationale for using them is typically sound and in my experience it’s one of wanting to decrease the internal file fragmentation of the d... (more)
category: Analysis | clicked: 9 | comment | | source: datarealized.wordpress.com
tags: file groups, index management, SQL Server 2005