Yes, me too. :)
I was tagged with this by Denis who has liven (is that even a word?) up to his nick "The SQL Meance". Bad Dennins, bad!
As lame as this thing might be and it does reminds us of the dreaded chain letters (anyone remeber getting those by normal mail.
Read more →
My article about Service Broker fundamentals and simple practical use has been posted on SQLTeam.com. Go check it out. Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only.
Read more →
No it's not some ultra misterious indexing feature that will make your database fly like it's on steroids.
Hypothetical indexes and database objects in general are simply objects created by DTA (Database Tuning Advisor)
Read more →
These 2 lists are worth having nearby just in case:
Breaking Changes to Database Engine Features in SQL Server 2005
- Describes the changes made to the Database Engine in Microsoft SQL Server 2005 that could cause applications based on earlier versions of SQL Server to break.
Read more →
Tests are a pretty much a must in today's world of programming. There's even a whole Test Driven Development methodology that deals with this.
There comes a time when we have to test how our app interacts with the database.
Read more →
Database mail is a completly rewritten mailing system in SQL Server 2005 built on top of the service broker.
This means that it runs asynchrounously. The mails are put in a queue and are sent from there.
Read more →
When selecting data from a table we can select rows which contain more than 8094 bytes.
The problem arises when trying to sort those rows.
in SQL Server 2000 this code:
Read more →
My follow up article on MARS has been published on on SQLTeam.com. In this follow up I cover some misunderstandings in trasaction handling when using MARS as well as how to troubleshoot MARS related problems.
Read more →
In SQL Server 2005 importing XML files became very easy.
OPENROWSET now supports the BULK keyword which lets us import XML files with ease.
A little example:
CREATE TABLE XmlImportTest ( xmlFileName VARCHAR(300), xml_data xml ) GO DECLARE @xmlFileName VARCHAR(300) SELECT @xmlFileName = 'c:\TestXml.
Read more →
This book authored by Kalen Delaney whose Inside SQL Server books are compulsory reading for every DBA
hits the nail on the head with this one too.
The book goes into hardcore details of how the storage engine itself works.
Read more →
A coworker who works mainly in C# wanted to know if there's an IsNullOrEmpty function.
After a brief NO, i've given him this one.
So far it works great.
CREATE FUNCTION dbo.
Read more →
Arity is the number of arguments that a method takes.
For example void MyMethod(int i1, int i2) has an arity of 2, since it takes 2 arguments.
In C# the arity is marked with `
Read more →
... at installation time was... are you ready?
OWC11
Yes... OWC11. Come on, are you kidding me??? this is so 2003 :))
Legacy Comments
Dejo Smejo
2007-06-05
re: SQL Server 2008: A component that surprised me.
Read more →
A few days ago i showed how to split string with XML. Now it's time for concatenation with XML.
DECLARE @t TABLE (col VARCHAR(10)) INSERT into @t select 'aaaa' UNION ALL select 'bbbb' UNION ALL select 'cccc' UNION ALL select null UNION ALL select 'dddd'
Read more →
This book is a sequel to T-SQL Querying. And it stands completly side by side it.
I can only recommend that you get it. The amount of new stuff to learn is amazing.
Read more →
Now this is something i really didn't think it would compile in C#.
private int _someVar = 0; private void DoStuff1() { int _someVar = 0; _someVar = 6; // .
Read more →
Here's a Split function using XML datatype.
It's preety neat and simple compared to all others that i've seen.
Forget While Loops and recursive CTE's. Enter XML: IF OBJECT_ID('dbo.Split') IS NOT NULL DROP FUNCTION dbo.
Read more →
There is a common misconception that IN behaves equaliy to EXISTS or JOIN in terms of returned results.
This is simply not true. To see why not, let's review what each statement does.
Read more →
Ever wanted to have have a table that contains unique values but needs to have multiple null values also?
Here's how to do it:
SET NUMERIC_ROUNDABORT OFF; SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON; GO CREATE TABLE t1 (id INT, title VARCHAR(20)) GO – optional instead of trigger to disable the insert directly into the table CREATE TRIGGER trg_t1_DisableInsert ON t1 INSTEAD OF INSERT AS BEGIN – use 18 to stop further processing RAISERROR (40000, 18, 1, 'Use view dbo.
Read more →
We've all heard about differences between temporary tables and table variables in SQL Server.
They include performance, storage in memory or disk, tempdb use, etc.
But the biggest and mostly overlooked difference is:
Read more →