SqlServerKudos - Stories tagged with SQL Server 2005

SQL Server 2005

atom rss
1
kudos
spam Kudos Remove

Creating a unique constraint on a column that allows nulls
published 4 hours, 37 minutes ago posted by sasa 1 day, 6 hours, 42 minutes ago
Saturday, July 31, 2010 3:23:24 PM GMT Friday, July 30, 2010 1:18:30 PM GMT
Creating a unique constraint on a column that allows nulls
Primary keys, unique indexes and unique constraints all enforce uniqueness. The difference between the primary key and the unique index/constraint is that the primary key does not allow any NULL values. However whilst the unique index/constraints do allow...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

Scream if you want to go faster
published 65 days, 9 hours, 26 minutes ago posted by sasa 72 days, 11 hours, 55 minutes ago
Thursday, May 27, 2010 10:33:51 AM GMT Thursday, May 20, 2010 8:05:34 AM GMT
Scream if you want to go faster
My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

Enabling super single user mode with SQL Server
published 117 days, 13 hours, 20 minutes ago posted by sasa 126 days, 13 hours, 49 minutes ago
Monday, April 05, 2010 6:40:30 AM GMT Saturday, March 27, 2010 6:11:02 AM GMT
Enabling super single user mode with SQL Server
I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SSIS - XML Source Script
published 132 days, 14 hours, 24 minutes ago posted by sasa 141 days, 15 hours, 3 minutes ago
Sunday, March 21, 2010 5:35:37 AM GMT Friday, March 12, 2010 4:57:12 AM GMT
SSIS - XML Source Script
The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early versions of Biztalk with loaded the whole document into memory to map from one document type to another. This was fine for small documents but was an absolute killer for large documents. You therefore need a... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: c#, SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML
1
kudos
spam Kudos Remove

XML Validation in SQL Server Intergration Services
published 181 days, 20 hours, 10 minutes ago posted by sasa 191 days, 3 hours, 59 minutes ago
Saturday, January 30, 2010 11:50:28 PM GMT Thursday, January 21, 2010 4:01:27 PM GMT
XML Validation in SQL Server Intergration Services
I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL 2005 so you can imagine it was written along time ago, XML wasn't as standardised. So what if you want to validate an XML document against a XSD Schema. Well in true SQL Server Integration services mode th... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML
1
kudos
spam Kudos Remove

User defined function performance is awful, Micorosft please sort this out
published 187 days, 20 hours, 35 minutes ago posted by sasa 197 days, 4 hours, 29 minutes ago
Sunday, January 24, 2010 11:25:16 PM GMT Friday, January 15, 2010 3:30:46 PM GMT
User defined function performance is awful, Micorosft please sort this out
User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing. So what is the problem with SQL Server. Well the issue is that whilst there are great from a reducation of duplicated code the performance sucks, and sucks big time. I wrote about this a year ago  and have spoke about it at m... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Bugs, Performance, Query Tuning, SQL Engine, SQL Profiler, SQL Server 2005, SQL Server 2008, Tips and Tricks, TSQL
1
kudos
spam Kudos Remove

Pause the passive node to apply SQL2005 Service Pack or hotfix
published 285 days, 4 hours, 37 minutes ago posted by sasa 294 days, 23 hours, 43 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 8:16:42 PM GMT
Pause the passive node to apply SQL2005 Service Pack or hotfix
With SQL Server 2005, Microsoft tried to be helpful in enabling its installer to apply the service pack or hotfix automatically on the passive node(s) in a cluster. In my own experience, this has not worked out too well. Very often, when the installer flagged the upgrade status of the service pack ot the hotfix as failure next to Database Service, the information I found in the log file was that attempt to patch the passive node had failed. You could scour the log files, google the internet, and/or open... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Cluster, Installation, SQL Server 2005
1
kudos
spam Kudos Remove

Windows Settings for DBA: MPIO Disks
published 317 days, 6 hours, 53 minutes ago posted by sasa 326 days, 1 hour, 32 minutes ago
Thursday, September 17, 2009 1:07:08 PM GMT Tuesday, September 08, 2009 6:27:45 PM GMT
Windows Settings for DBA: MPIO Disks
September 8, 2009 · Posted in SQL Server  I have written about other often overlooked like the write cache policy and file cache tuning. Here we will talk about another one: Multipath disks. This is can be one of those magical performance doubling drop down boxes that if you change when you app is sucking wind, you get nothing but high 5’s from the Veeps down. Of course, it only makes a difference in certain scenarios. We will talk more about that shortly. The default setting when you install MPIO ... (more)
category: News | clicked: 18 | comment | | source: jasonmassie.com
tags: Hardware, SAN, SQL Server 2005, SQL Server 2008, windows, Windows Server 2008
1
kudos
spam Kudos Remove

Column order doesn't matter... generally, but - IT DEPENDS!
published 348 days, 6 hours, 35 minutes ago posted by sasa 354 days, 23 hours, 4 minutes ago
Monday, August 17, 2009 1:25:13 PM GMT Monday, August 10, 2009 8:55:59 PM GMT
Column order doesn't matter... generally, but - IT DEPENDS!
OK, for years I've been saying that SQL Server doesn't care about the order in which you define the columns of your table because internally SQL Server will re-arrange your columns to store all of the fixed width columns first and the variable columns last. In both the fixed-width portion of the row as well as the variable-width portion of the row, the columns are defined in the order in which they are declared. So, what does matter? (more)
category: Management | clicked: 4 | comment | | source: www.sqlskills.com
tags: Design, SQL Server 2005, SQL Server 2008, Storage Engine
1
kudos
spam Kudos Remove

Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
published 355 days, 5 hours, 27 minutes ago posted by sasa 359 days, 23 hours, 14 minutes ago
Monday, August 10, 2009 2:33:32 PM GMT Wednesday, August 05, 2009 8:46:05 PM GMT
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is a feature that allows you to expand\collapse regions of code in the editor to make it easier to focus on specific sections of code. SQL Server Management Studio is based on the Visual Studio editor but it wasn't until SSMS 2008 that IntelliSense, which includes code outlining, was added. One of the drawbacks, however, is that IntelliSense only works when connected to a 2008 server…sort of.... (more)
category: Management | clicked: 1 | comment | | source: kendalvandyke.blogspot.com
tags: SQL Server 2005, SQL Server 2008, Syndication, Tips
1
kudos
spam Kudos Remove

Sending List of Complex objects
published 367 days, 7 hours, 49 minutes ago posted by sasa 368 days, 3 hours, 3 minutes ago
Wednesday, July 29, 2009 12:11:04 PM GMT Tuesday, July 28, 2009 4:56:38 PM GMT
Sending List of Complex objects
There are situations when you have to do multiple inserts on a single event there are multiple ways to handle this situation.The simplest and which most of the developers do and make a blunder is making individual calls to the database. One common example can be a grid which have facility of multiple Insert in such a situation on a single add button click you have to make hundreds of insert or even thousands,there are more genuine scenarios such as, suppose you are making a Silverlight CMS system and yo... (more)
category: Query | clicked: 0 | comment | | source: smallworkarounds.blogspot.com
tags: SQL Server 2005, Stored Procedures
1
kudos
spam Kudos Remove

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model | John Sansom - SQL Server DBA in the UK
published 365 days, 7 hours, 49 minutes ago posted by http://johnsansom.myopenid.com/http://johnsansom.myopenid.com/ 369 days, 1 hour, 32 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 6:27:49 PM GMT
SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model | John Sansom - SQL Server DBA in the UK
In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility. Given that your data is so important, how can you manage and ensure it’s safekeeping?...... (more)
category: Management | clicked: 4 | comment | | source: www.johnsansom.com
tags: Administration, Backup, SQL Server 2005
1
kudos
spam Kudos Remove

Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
published 365 days, 7 hours, 49 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 2 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 366 days, 7 hours, 53 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 19 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 366 days, 7 hours, 53 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 369 days, 4 hours, 25 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 366 days, 7 hours, 53 minutes ago posted by http://sqlchicken.blogspot.com/http://sqlchicken.blogspot.com/ 369 days, 4 hours, 38 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 368 days, 7 hours, 55 minutes ago posted by sasa 370 days, 13 hours, 23 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 369 days, 7 hours, 46 minutes ago posted by sasa 370 days, 14 hours, 20 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