Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,406 through 36,420 (of 59,067 total)

RE: Finding Sequences (Need help ASAP)

I've been waiting because it seems that the requirements for this problem have been modified several times thoughout this thread. Soooooo.... let's make sure the requirements are actually very...
--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)

October 9, 2010 at 9:36 am

#1234625
RE: similar like Oracle RAC

GilaMonster (10/8/2010)
Jeff Moden (10/8/2010)
Why wouldn't "Federated Servers" in SQL Server do the same thing?
That's when you split a database across multiple servers so that each holds a piece.
RAC has multiple...
--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)

October 8, 2010 at 6:39 am

#1234188
RE: TSQL Help

vilonel (10/8/2010)
Great article Jeff (The "Numbers" or "Tally" Table: What it is and how it replaces a loop.) - have used your example and my query works and the results...
--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)

October 8, 2010 at 6:33 am

#1234187
RE: Convert CSV values in three columns to rows

Very cool, Pavel. Thanks.
--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)

October 8, 2010 at 6:30 am

#1234182
RE: Finding Sequences (Need help ASAP)

craig-404139 (10/7/2010)
WayneS (10/7/2010)
Jeff Moden (10/7/2010)
So... without me running all the code presented so far, what has been decided? Does the numbering restart for each prefix or not?
k from the...
--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)

October 8, 2010 at 6:26 am

#1234180
RE: Locking a row

Gianluca Sartori (10/8/2010)
Jeff Moden (10/7/2010)
Man... well done. Just don't ever put something like this in a transaction... it will cause deadlocks in the "outside" world. Also, make the...
--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)

October 8, 2010 at 3:12 am

#1234084
RE: similar like Oracle RAC

Gianluca Sartori (10/7/2010)
Jeff Moden (10/7/2010)
saurabh.deshpande (10/7/2010)
Can we have anything like Oracle RAC available in SQL Server.
Thanks
What is "Oracle RAC"?
Oracle RAC stands for Real Application Cluster, that...
--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)

October 8, 2010 at 3:04 am

#1234081
RE: Are the posted questions getting worse?

The Dixie Flatline (10/7/2010)
I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who get sent...
--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)

October 8, 2010 at 2:55 am

#1234077
RE: Are the posted questions getting worse?

Roy Ernest (10/7/2010)
Anybody looking for chairs or recliners?
How do we report spam?
Hit the [Report] button instead of the [Quote] button and leave a quick note "Looks like spam".
--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)

October 8, 2010 at 2:50 am

#1234074
RE: Are the posted questions getting worse?

WayneS (10/7/2010)
Brandie Tarvin (10/7/2010)
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspx
Time to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
IMO,...
--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)

October 8, 2010 at 2:43 am

#1234071
RE: Differences

{edit} Removed my comment. People may have taken it the wrong way.
--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)

October 8, 2010 at 2:37 am

#1234068
RE: Differences

{edit} Removed my comment. People may have taken it the wrong way.
--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)

October 7, 2010 at 10:55 pm

#1234027
RE: Any Idea How to Parse a file Like This

ramses2nd (10/7/2010)
I am getting a single file with the following contents and I need to parse it into different tables. Each table is defined a the line which contains...
--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)

October 7, 2010 at 10:40 pm

#1234025
RE: Any Idea How to Parse a file Like This

Raunak Jhawar (10/7/2010)
The table names are repeating(Domain Name etc. as you scroll down the file) as per the descrption provided.
And?
--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)

October 7, 2010 at 10:36 pm

#1234023
RE: Locking a row

Gianluca Sartori (10/7/2010)
It could be something like this:
CREATE PROCEDURE [getSequence]
AS
BEGIN
SET NOCOUNT ON
DECLARE @newVal int
BEGIN TRY
BEGIN TRAN
UPDATE SequenceTable
SET @newVal = Sequence = Sequence + 1
COMMIT
END TRY
BEGIN CATCH
DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
DECLARE...
--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)

October 7, 2010 at 10:30 pm

#1234022

Viewing 15 posts - 36,406 through 36,420 (of 59,067 total)