forums.sqlteam.com

sqlteam.com

More Trees & Hierarchies in SQL - SQLTeam.com

http://www.sqlteam.com/article/more-trees-hierarchies-in-sql

All Articles by Tag. More Trees and Hierarchies in SQL. On 1 May 2002. Hierarchies are sometimes difficult to store in SQL tables.things like trees, threaded forums, org charts and the like.and it's usually even harder to retrieve the hierarchy once you do store it. Here's a method that's easy to understand and maintain, and gives you the full hierarchy (or any piece of it) very quickly and easily. The table would look like this:. David St. Hubbins. And the org chart/indented list looks like this:. SELEC...

sqlteam.com

SQL Server Newsletter at SQLTeam.com

http://www.sqlteam.com/newsletter.aspx

All Articles by Tag. The SQLTeam.com newsletter goes out weekly. You can sign up on the right side of the site. Each newsletter has an unsubscribe link at the bottom and process those immediately. You can also subscribe and unsubscribe through your forum profile page. This is what youll find in a typical newsletter:. Notes on anything interesting that happened during the week such as a service pack release or product announcement. New SQLTeam.com articles. A few previous newsletters are listed below.

sqlteam.com

Using DDL Triggers in SQL Server 2005 to Capture Schema Changes - SQLTeam.com

http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

All Articles by Tag. Using DDL Triggers in SQL Server 2005 to Capture Schema Changes. On 13 August 2007. This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced. This is where you are lucky. I think I found a way for you, the DBA, psuedo-DBA, forced DBA, etc to get the same type of change log system with just a little setup. FYI, Those rotisseries rock! DROP XML S...

sqlteam.com

Implementing a Dynamic WHERE Clause - SQLTeam.com

http://www.sqlteam.com/article/implementing-a-dynamic-where-clause

All Articles by Tag. Implementing a Dynamic WHERE Clause. On 14 January 2001. Passed on another article to us. This one covers building a dynamic where clause. And the really neat part is that you don't actually need to write dynamic SQL. This is soooo much simpler. Let's look at an example that shows how this works. Assume you have a table called Customers created with the following statement. A more efficient approach to creating dynamic WHERE clauses involves using the COALESCE function. This func...

sqlteam.com

SQL Server Forums

http://www.sqlteam.com/forums

All Articles by Tag. Please start any new threads on our new site at http:/ forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums. We've restricted the ability to create new threads on these forums. And get your question answered! General SQL Server Forums. New to SQL Server Programming. New to SQL Server Administration. Database Design and Application Architecture. SQL Server 2012 Forums. SQL Server Administration (2012).

sqlteam.com

SQL Server Forums

http://www.sqlteam.com/forums/password.asp

All Articles by Tag. Please start any new threads on our new site at http:/ forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums. We've restricted the ability to create new threads on these forums. And get your question answered! This is a 3 step process:. Enter your e-mail address in the form below to receive an e-mail containing a code to verify that you are who you say you are. Choose your new password.

sqlteam.com

SQL Server Version - SQLTeam.com

http://www.sqlteam.com/article/sql-server-versions

All Articles by Tag. On 29 January 2009. I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article. SQL Server 2008 R2. SQL Server 2008 R2 CU2. SQL Server 2008 R2 CU1. SQL Server 2008 SP1.

sqlteam.com

Handling SQL Server Errors - SQLTeam.com

http://www.sqlteam.com/article/handling-sql-server-errors

All Articles by Tag. Handling SQL Server Errors. On 5 April 2010. SQL Server 2008 Features. This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions. SQL Server uses the following syntax to capture errors in Transact-SQL statements:. First] = 1 SELECT. Second] = 1/0 SELECT. Third] = 3 END. The complete text of the err...

sqlteam.com

SQL Server Articles on SQLTeam.com

http://www.sqlteam.com/tag.aspx

All Articles by Tag. SQL for CE (3). SQL Server 2000 Release (15). SQL Server 2005 (37). SQL Server 2008 Features (7). SQL Server 2008 Release (3). SQL Server 7.0 (2). Profiler and Trace (12). User Defined Functions (6). Subscribe to SQLTeam.com. Weekly SQL Server newsletter. With articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers. SQLTeam.com Articles via RSS. SQLTeam.com Weblog via RSS. Advertise on SQLTeam.com.

sqlteam.com

Fast CSV Import in PowerShell to SQL Server - SQLTeam.com

http://www.sqlteam.com/article/fast-csv-import-in-powershell-to-sql-server

All Articles by Tag. Fast CSV Import in PowerShell to SQL Server. On 18 March 2014. I recently had to write some simple scripts for a proof of concept. These scripts use PowerShell to import and export CSV files from SQL Server. The scripts were simple to write and maintain but were slow. It turns out there are a few ways to improve CSV import and export performance in PowerShell. Before I landed on PowerShell I considered a few other approaches to get this done. Simple CSV Import using PowerShell. Comma...