SqlServerKudos

SQL Server 2005

2
kudos

Kudos

SQL Server BOL and Visual Studio 2005 SP1 notes from SQL Server 2005 SP4 release

published 400 days, 1 hour, 6 minutes ago posted by

sa 409 days, 1 hour, 42 minutes ago

SQL Server BOL and Visual Studio 2005 SP1 notes from SQL Server 2005 SP4 release

The recent posts about SQL Server 2005 Service Pack 4 were referred as to download the documentation (aka BOL) and update your local copies. In fact you do not need to update the BOL as the help documentation have not been updated for SP4 and only reference you will find as SP3 (as current) or latest release (so do not panic). Also the SP4 readme documentation refers that you need to install Visual Studio 2005 SP1 before you install SQL2005SP4 Because SQL Server 2005 Books Online has not been updated...(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, BOL, no changes, sp4, sql express, SQL Server, SQL Server 2005, Upgrade, visual studio 2005lsp1

2
kudos

Kudos

SQL Server 2005 Service Pack 4 RTM - test and download

published 403 days, 1 hour, 21 minutes ago posted by

sa 413 days, 47 minutes ago

SQL Server 2005 Service Pack 4 RTM - test and download

Here is the announcement about SQL Server 2005 Service Pack 4 RTM which has been CTP for a month or so to test and apply on your current 2005 production estate. Before downloading make sure to go through the ReadmeSQL2005SP4.htm and go through the Release notes section, additionally make sure to update your local copies of SQL Server 2005 Books online. As per hte line you can obtain Books Online in the following ways: Install Books Online by selecting the SQL Server 2005 Books Online feature in this...(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, DBA, download, environment, service pack, SQL Server, SQL Server 2005, Upgrade, x64

1
kudos

Kudos

Restricting logons during certain hours for certain users

published 419 days, 2 hours, 23 minutes ago posted by

sa 428 days, 3 hours, 58 minutes ago

Restricting logons during certain hours for certain users

Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Logon Triggers, Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2011

1
kudos

Kudos

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

published 454 days, 4 hours, 55 minutes ago posted by

sa 463 days, 8 hours, 35 minutes ago

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

When writing CLR code for SQL you need to handle nulls. You can do this in two ways, either your data types are nullable or you configure your functions to always return null when a parameter is null. The last only works for some objects and so understanding...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: c#, SQL Server 2005, SQL Server 2008

1
kudos

Kudos

How to downgrade Integration Services 2008 packages to 2005

published 462 days, 6 hours, 31 minutes ago posted by

sa 471 days, 8 hours, 59 minutes ago

How to downgrade Integration Services 2008 packages to 2005

Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tools and Components

1
kudos

Kudos

Cumulative update package 12 for SQL Server 2005 Service Pack 3 released

published 464 days, 6 hours, 40 minutes ago posted by

sa 473 days, 7 hours, 19 minutes ago

Cumulative update package 12 for SQL Server 2005 Service Pack 3 released

Here is another instalment of Cumulative update package 12 for SQL Server 2005 SP3 is ready for download & testing. The build number for CU package will be 9.00.4311, also after applying this CU12 you may need to restart the server to apply the changes. Also a stand-alone package of SQL Native Client (SQLNCLI) is available to download. Further to know about list of files that are updated by this CU12 refer to KBA2345499 and an additonal note states that: You must enable the SQL Server Management...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: cumulative update, dbcc checkdb, download, output, package, query designer, SQL Server, SQL Server 2005, support, Testing, XML

1
kudos

Kudos

SQL Server 2008 R2: SYSPREP - Rule Unsupported for SysPrep SQL Server Products failed

published 483 days, 7 hours, 53 minutes ago posted by

sa 493 days, 6 hours, 40 minutes ago

SQL Server 2008 R2: SYSPREP - Rule Unsupported for SysPrep SQL Server Products failed

SysPrep is the new functionality for SQL Server 2008 R2 installation feature that has been added with R2 version. The installatino of SQL Server always pass-thru 2 actions, prepare and complete which is integrated from SQL Server 2008 version onwards. But now with SQL Server 2008 R2, in addition to the integrated one step installation of a stand-alone instance of SQL Server, a two step installation is also available. The steps include the following: Prepare Image - This step stops the installation...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, downgrade, installallation, sql express, SQL Server, SQL Server 2005, SQL Server 2008 R2, sysprep

1
kudos

Kudos

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

published 527 days, 10 hours, 57 minutes ago posted by

sa 536 days, 11 hours, 53 minutes ago

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

If you are following the patching of your SQL Server instances with Cumulative Updates then here is another instalment available for testing & deployment. To obtain and apply this CU #11 hotfix release for SQL Server 2005 SP3 you must apply the Sp3 for SQL Serve 2005 instance. Here is the KBA913089 to get the latest service pack on SQL Server 2005. For more information on the list of files that are updated as a part of this CU11 release, see KBA2258854 link, also there is an information about...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: cumulative update, downgrade, native client, sp3, SQL Server, SQL Server 2005, support, Testing, uninstall

1
kudos

Kudos

Creating a unique constraint on a column that allows nulls

published 545 days, 12 hours, 10 minutes ago posted by

sa 554 days, 14 hours, 53 minutes ago

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

Kudos

Scream if you want to go faster

published 618 days, 17 hours, 38 minutes ago posted by

sa 625 days, 20 hours, 6 minutes ago

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

Kudos

Enabling super single user mode with SQL Server

published 670 days, 21 hours, 31 minutes ago posted by

sa 679 days, 22 hours, 1 minute ago

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

Kudos

SSIS - XML Source Script

published 685 days, 22 hours, 36 minutes ago posted by

sa 694 days, 23 hours, 14 minutes ago

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

Kudos

XML Validation in SQL Server Intergration Services

published 735 days, 4 hours, 21 minutes ago posted by

sa 744 days, 12 hours, 10 minutes ago

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

Kudos

User defined function performance is awful, Micorosft please sort this out

published 741 days, 4 hours, 46 minutes ago posted by

sa 750 days, 12 hours, 41 minutes ago

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

Kudos

Pause the passive node to apply SQL2005 Service Pack or hotfix

published 838 days, 12 hours, 49 minutes ago posted by

sa 848 days, 7 hours, 55 minutes ago

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: 2 | comment | | source: sqlblog.com

tags: Cluster, Installation, SQL Server 2005

1
kudos

Kudos

Windows Settings for DBA: MPIO Disks

published 870 days, 15 hours, 5 minutes ago posted by

sa 879 days, 9 hours, 44 minutes ago

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: 36 | comment | | source: jasonmassie.com

tags: Hardware, SAN, SQL Server 2005, SQL Server 2008, windows, Windows Server 2008

1
kudos

Kudos

Column order doesn't matter... generally, but - IT DEPENDS!

published 901 days, 14 hours, 46 minutes ago posted by

sa 908 days, 7 hours, 16 minutes ago

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

Kudos

Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?

published 908 days, 13 hours, 38 minutes ago posted by

sa 913 days, 7 hours, 26 minutes ago

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

Kudos

Sending List of Complex objects

published 920 days, 16 hours, 1 minute ago posted by

sa 921 days, 11 hours, 15 minutes ago

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

Kudos

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model | John Sansom - SQL Server DBA in the UK

published 918 days, 16 hours ago posted by

http://johnsansom.myopenid.com/ 922 days, 9 hours, 44 minutes ago

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

Welcome!

SQL Server 2005

SQL Server BOL and Visual Studio 2005 SP1 notes from SQL Server 2005 SP4 release

SQL Server 2005 Service Pack 4 RTM - test and download

Restricting logons during certain hours for certain users

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

How to downgrade Integration Services 2008 packages to 2005

Cumulative update package 12 for SQL Server 2005 Service Pack 3 released

SQL Server 2008 R2: SYSPREP - Rule Unsupported for SysPrep SQL Server Products failed

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

Creating a unique constraint on a column that allows nulls

Scream if you want to go faster

Enabling super single user mode with SQL Server

SSIS - XML Source Script

XML Validation in SQL Server Intergration Services

User defined function performance is awful, Micorosft please sort this out

Pause the passive node to apply SQL2005 Service Pack or hotfix

Windows Settings for DBA: MPIO Disks

Column order doesn't matter... generally, but - IT DEPENDS!

Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?

Sending List of Complex objects

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model | John Sansom - SQL Server DBA in the UK

Open ID Login

Standard Login

Forgot Password?

Sign up