Sign in | Join | Help
 
HomeBlogsPartnersJobsBenefitsVideosSQL Server Day Partners
Hosting provider

We are hosted by HOSTBASKET
The Menu
Our profile
Our goal
Why register
Contact / Who is who?
Questions?

If you have any questions, do not hesitate to contact
us on info at sqlug dot be
Upcoming Events

Share

DrivenBySQL

Maintenance Plan Fixer (Tool to work arround KB 992651)

Some weeks ago a SQLUG user (Franky) reported a problem when importing existing maintenance plans on a SQL server. You can find more information on this thread . After some research franky found a KB article that describes the problem and you can solve it. Follow step reproduce the error: Here you can download a simple maintenance...

posted by on to  ()

More information about Table Variables (BOOK).

Hi It has been a while since my last blog post. Reason a lot of work for the SQLUG (Creating a mail template, meetings, etc..) and learning for my MCTS Exam. I hope that I will have time to do some blog posts. In the last session about Advanced monitoring and tuning techniques in SQL Server 2005. There were some question about how...

posted by on to  ()

Refactoring databases (book)

Want to refactor your database but don't know how to get started. This book is a must gave. This book explains each steps that you for to do for a refactoring. You can find all the type of refactoring on the follow site: www.databaserefactoring.com

posted by on to  ()

SQL Task and Parameterized Parameters

Today I was using the SQL Task and I needed to use a where clause in my SQL statement. It was easier then I thought. Here are the steps for the test. Of course the db that we use is AdventureWorks Step 1: Create a new OledbConnection Create a new Oledb Connection that points to the AdventureWorks Database Step2: Create a SQL Task...

posted by on to  ()

How to configure a SQL Task that returns a ResultSet In SSIS

This week I had some problems with the ExcuteSqlTask. I had a SQL task that executes a stored procedure that returned a resultset. I always received the error '[Execute SQL Task] Error: The result binding name must be set to zero for full result set and XML results.' This means that you need to set the Result Set Name to "0" on the...

posted by on to  ()

SSIS ForEachNodeList Container by Example (Part 1)

Today I was using the NodeList ForeachContainer and I wanted to extract 2 values of a node and store it in Variables. This was more difficult than I expected. I will show how we can do this by an example. So we will create directories based on a XML Remark: We will hardcode everything in our package. Here is the XML: <?xml version...

posted by on to  ()

a Tool for formatting SQL Statements

Today I was doing some performance optimalizations of a SQL statement. The problem was that the SQL was generated in the application and that there where no new lines in the SQL statement that make it hard to read it. So I searched a tool that did this for me. I found cool tool that can do this called SQL Formatter . The online version...

posted by on to  ()

A trick to learn more about the query optimizer

If you want to learn more about how the sql optimizer works you should check out the blog of the SQL Query optimizer team. The last post is about an undocumented features of the UPDATE STATISTICS statement. This undocumented feature can help you to learn more about the SQL optimizer. DON'T USE THIS FEATURE ON PRODUCTION SYSTEMS IT...

posted by on to  ()

Share
Copyright SQLUG.be 2006-2009. All rights reserved. Blog content (c) by its respective blog author
leftmen