SqlServerKudos - Stories tagged with SQL Server 2005

SQL Server 2005

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, 7 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1029 days, 20 hours, 20 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, 11 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1029 days, 20 hours, 37 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, 11 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1029 days, 20 hours, 43 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
2
kudos
spam Kudos Remove

SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
published 1027 days, 11 minutes ago posted by http://sqlchicken.blogspot.com/http://sqlchicken.blogspot.com/ 1029 days, 20 hours, 56 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:22:08 PM GMT
SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via T-SQL but to my dismay I didn’t see an article on how to create/set this up from SQL Server Profiler. So this will be a quick rundown on how to create your trace using the GUI of SQL Server Profiler and schedule your trace to run ... (more)
category: Management | clicked: 2 | comment | | source: sqlchicken.blogspot.com
tags: Administration, SQL Server 2005, SQL Server 2008
2
kudos
spam Kudos Remove

Looking for security vulnerabilities in database code
published 1029 days, 13 minutes ago posted by sasa 1031 days, 5 hours, 41 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Sunday, July 26, 2009 6:37:29 AM GMT
Looking for security vulnerabilities in database code
I've always been concerned with security and I've always stressed the importance of auditing the REAL user context not just the current user (see this post on EXECUTE AS and auditing). So, I generally try to avoid using dynamic string execution and if necessary create well tested/protected parameters (fyi - using QUOTENAME can be a fantasic solution to protectng identifiers as input paramet... (more)
category: Security | clicked: 1 | comment | | source: www.sqlskills.com
tags: Security, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

Internals and Query Tuning - in the Boston area October 12-16
published 1030 days, 5 minutes ago posted by sasa 1031 days, 6 hours, 38 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:39:43 AM GMT
Internals and Query Tuning - in the Boston area October 12-16
In case you missed Kalen's post, we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server course to be offered in the Boston area in the last 5 years, and this is the first time that Kalen has ever taught in the area. I hope that some of you will be able to take advantage of this rare opportunity to really take your SQL Server skills to the n... (more)
category: News | clicked: 1 | comment | | source: sqlblog.com
tags: Query Tuning, SQL Server 2005, SQL Server 2008, Training
Previous 1 2 Next