Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,451 through 30,465 (of 59,101 total)

RE: When we talk about fragmentation, is it "Index Fragmentation" always ?

GilaMonster (4/5/2012)
george sibbald (4/5/2012)
I stand corrected, I had forgotten about forwarding pointers. what about internal fragmentation though?
where I have added a clustered index to a heap I have achieved a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:16 pm

#1469927
RE: Cursor help

Considering that you input data is only a half of what your output data is, your going to have to describe how the data describes "in" and "out" times. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:10 pm

#1469925
RE: query for consecutive alphabets

Jeff Moden (4/5/2012)
sharky (4/5/2012)
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 130 ms.
========== Craig's Method ======================================================
SQL Server Execution Times:
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 5:59 pm

#1469923
RE: query for consecutive alphabets

SQLKnowItAll (4/5/2012)
Jeff Moden (4/5/2012)
SQLKnowItAll (4/5/2012)
GilaMonster (4/5/2012)
My question would be why do TOP <x> in an EXISTS when the point of an EXISTS (or NOT EXISTS) is to terminate as soon...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 5:38 pm

#1469919
RE: query for consecutive alphabets

sharky (4/5/2012)
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 130 ms.
========== Craig's Method ======================================================
SQL Server Execution Times:
CPU...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 5:11 pm

#1469912
RE: query for consecutive alphabets

Here's my whole test harness including the UPPER modification to make Stan's fine idea work correctly.
CREATE TABLE yourTable (name VARCHAR(50))
INSERT INTO yourTable
SELECT name
FROM (
SELECT 'Good' UNION ALL --Keep
SELECT 'Goabc'...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 5:08 pm

#1469911
RE: query for consecutive alphabets

capn.hector (4/5/2012)
would you be able to slap an UPPER() or LOWER() around yt.Name in ASCII(SUBSTRING(yt.Name,t.N,1)) turning it into ASCII(SUBSTRING(UPPER(yt.Name),t.N,1)) to get around the Stu problem in stan's code?
Yes but you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 4:48 pm

#1469906
RE: query for consecutive alphabets

SQLKnowItAll (4/5/2012)
GilaMonster (4/5/2012)
My question would be why do TOP <x> in an EXISTS when the point of an EXISTS (or NOT EXISTS) is to terminate as soon as it finds...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 4:44 pm

#1469905
RE: query for consecutive alphabets

sharky (4/5/2012)
I am not a huge fan of a Tally table as the code can break when you port it,
So can any other code that you try to port. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 4:39 pm

#1469902
RE: query for consecutive alphabets

sharky (4/4/2012)
SQL is pretty bad at doing any character manipulation and comparison. I always use LIKE, CHARINDEX etc. as a last resort. I agree, your solution performs much better...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 4:25 pm

#1469894
RE: CLR Integration in SQL

binak_86 (4/5/2012)
Keeping in mind the scenario posted in the article, we are just developing the database, and not responsible for the applications which will be sending data, so in other...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 3:15 pm

#1469860
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (4/5/2012)
Lynn Pettis (4/5/2012)
I'm sorry, but I started laughing to myself when I read this one.
As Jeff would say, bwahahaha
Whup? BWAAA_HAAAA!!! 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 12:48 pm

#1469766
RE: Function to set start and end date @variables

I had a bug in the "usage" comments in the code I previously posted. I also took the time to add a usage comment very specific to this thread.
schillingt...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 5, 2012 at 6:34 am

#1469455
RE: Function to set start and end date @variables

{edit} Had a bug in the comments (believe it or not) I posted. I'll be back.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 4, 2012 at 10:44 pm

#1469311
RE: Function to set start and end date @variables

ColdCoffee (4/4/2012)
Jeff Moden (4/4/2012)
ColdCoffee (4/4/2012)
True, Jeff. Thats why in my code, i used -3 for milliseconds. OP posted this in 2008 forums, so i think its better to ask him...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 4, 2012 at 10:24 pm

#1469307

Viewing 15 posts - 30,451 through 30,465 (of 59,101 total)