timothyawiseman (11/24/2008)[hr

>>The problem is that your example did not show a case where efficiency is not a concern.

>>But, in your example you say there is no need to worry about...

timothyawiseman (11/24/2008)

---

I agree with Jeff that performance should always be a concern. After all, you may eventually need that...

You could also create tables with different number bases e.g for binary:

WITH Digits (i,s)

AS

(

SELECT 0 AS [Value], '0' AS String UNION ALL SELECT 1, '1'...

Adam Machanic (11/24/2008)

---

Joe Celko (11/24/2008)

---

Here is another method, which uses a tale of digits and some math

CREATE TABLE Sequence (seq INTEGER NOT NULL PRIMARY KEY);

WITH Digits (i)

AS

(VALUES (0),...

Performance isn't always an issue as in my previous example.

It depends how much performance is an issue, for a lot of queries it is not. For example, if there is a daily report that runs in batch it would...

I'd consider using a table valued function instead that only returns the rows I'm interested in:

e.g.:

CREATE FUNCTION [dbo].[Nums]

(

@StartNum int,

@EndNum int

)

RETURNS @table...

Can you show use the before and after SQL so we can see how well it did?

donnelcyril (11/9/2008)

---

Hi,

I am having problems with my queries which I definitely think is because of null values. This is what I want to do:

Find out a list of phone numbers...

Akash Agarwal (8/13/2008)

---

I m getting ther error on the line

CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) qt

while creating the Proc

The error is

Msg 102, Level 15, State 1, Procedure dba_QueryTimeDelta1, Line 49

Incorrect syntax...

I've added a NullIf function to prevent the divide by zero error:-------------------------------------------------------------------------- ----------------------------------------------------------------------------------
-- Purpose: Identify queries that are running slower than normal,
-- when taking into account...

Here's one with divide by zero error removed and indentation:

------------------------------------------------------------------------

-- Purpose: Identify queries that are running slower than normal,

-- when taking...

I realy like this stored procedure. I have a system that uses UPSERTs where first you try to update a row using the primary key and if it the...

Whenever you compare NULL you should always use 'IS NULL' rather than '= NULL'

e.g.

[font="Courier New"]SET ANSI_NULLS ON

DECLARE @val CHAR(4)

SET @val = NULL

SET ANSI_NULLS ON

If

I agree, I've gone to the effort of writing a Word macro template to document SQL-Server databases. You just select an ODBC data-source for a SQL server database and it...