SQL Server Code,Tips and Tricks, Performance Tuning

A blog about SQL Server, Books, Movies and life in general

Thursday, June 29, 2006

List DDL Triggers By Using The sys.triggers Catalog View

How do you list DDL triggers in SQL Server 2005? It's very easy you just query the sys.triggers catalog view. Let's try an example U...

Wednesday, June 28, 2006

Murphy's Law And SQL Server

›

Why do things break the moment that the person who handles something is on vacation? Here is the full story. A co-worker goes on vacation, h...

Monday, June 26, 2006

DELETE and Subquery (IN) Problem

›

When you have a DELETE used with an IN (subquery) all rows will be deleted if your subquery is wrong What do I mean by this? Let's say y...

1 comment:

Sunday, June 25, 2006

The Difference Between Unique Constraint And Unique Index

›

Do you know the the difference between an unique constraint, and an unique index? If you do not or if you are not sure then make sure you re...

Thursday, June 22, 2006

SQL Server Datetime Datatypes

›

Since I am kind of busy (Work, House, FIFA World Cup Soccer/Football) I said that I would post links to great SQL Server stuff by other peop...

Wednesday, June 21, 2006

3.5 Ways To Show Stored Procedure Code In SQL Server 2005

›

There are four (more on that later) ways in SQL Server 2005 to get the create procedure script. Why does the title say 3.5, well that is bec...

Tuesday, June 20, 2006

5 Reasons I Will Blog A Little Less The Next 6 Weeks

›

Because of these 5 reasons A ) I just moved into a new house and I still have a lot of things to do B ) My wife is 33 weeks pregnant with tw...

Monday, June 19, 2006

Use OBJECTPROPERTY To Generate A List Of Object Types

›

How do you query the sysobjects system table and get the object type back for every single object You can use the type and xtype columns, th...

Scriptio 0.5.5 Released

›

Bill Graziano has released the latest version of his Scriptio tool. What is scriptio? From Bill's site: "After working with SQL Ser...

Tuesday, June 13, 2006

Check For Valid SMALLDATETIME

›

Sometime you get data from different sources and the dates are stored in a varchar columnYou need to store that data in your database. The c...

3 comments:

Monday, June 12, 2006

COALESCE And ISNULL Differences

›

I decided to do a quick post about two differences between COALESCE and ISNULL Run the following block of code -- The result is 7, integer m...

8 comments:

Friday, June 09, 2006

Retrieve Column Info Of Table Valued Functions By Using INFORMATION_SCHEMA.ROUTINE_COLUMNS

›

How do you retrieve the columns of Table Valued Functions? This question was posted to day in the microsoft.public.sqlserver.programming for...

Rename A column In A Table With sp_rename

›

How do you rename a column in a SQL Server table without using Enterprise Manager/SSMS of course, T_SQL only. This is a frequent question in...

Data Dude

›

Last week I told you about Visual Studio Team Edition for Database Professionals (Data Dude) Kimberly L. Tripp has a post on her blog with 1...

Thursday, June 08, 2006

INFORMATION_SCHEMA.SCHEMATA SQL Server 2005 Change

›

Everyone keeps saying;” Don’t use the system tables directly but use the ANSI views instead” So instead of sysobjects use INFORMATION_SCHEMA...

Thursday, June 01, 2006

Use DATEADD And DATEDIFF To Get The Start And End Date For A Quarter

›

In the microsoft.public.sqlserver.programming forum a person asked how to get the first day of the current quarter. My answer was this: SEL...

Unit Testing For The DB, Visual Studio Team Edition for Database Professionals Is Here

›

Microsoft Corp. today announced Visual Studio® Team Edition for Database Professionals, expanding Visual Studio 2005 Team System to include ...

Import Dates, Skip Bad Data By Using ISDATE() And CASE

›

You have a table with a 'date' column and it's stored as varchar, the problem is that you also have bad data in there You want t...

‹

›

Home

View web version