Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,681 through 37,695 (of 59,072 total)

RE: Only customer accounts with + & - balances

smive2003 (7/13/2010)
I’m new to SQL.
I have to provide customer account balances and only show customers accounts that have any positive balance against any negative balance from any of up to...
--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)

July 13, 2010 at 11:02 pm

#1192521
RE: Is always clustered index better than non-clustered index ?

onlo (7/13/2010)
Some bodies say : for records INSERT, UPDATE, DELETE, using clustered index will use more time or resources to complete, is it true ?
To add to what Gail...
--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)

July 13, 2010 at 11:00 pm

#1192520
RE: Help with dynamic cross-tab

LutzM (7/12/2010)
Would the following dynamic SQL help you?
DECLARE @sql VARCHAR(6000)
DECLARE @sql1 VARCHAR(500)
DECLARE @sql2 VARCHAR(5000)
DECLARE @sql3 VARCHAR(500)
SET @sql1='
;with cte_group_of8 as
(
SELECT
ROW_NUMBER() OVER(PARTITION BY claim_id ORDER BY cast(left(claim_sequence_numbers + '','',charindex('','',claim_sequence_numbers)-1)...
--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)

July 13, 2010 at 10:53 pm

#1192517
RE: Help with dynamic cross-tab

Brandie Tarvin (7/12/2010)
Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.
Pivots are generally slower (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)

July 13, 2010 at 10:49 pm

#1192516
RE: Problems using :Connect in SQLCMD

Go to "Services" in Control Panel and make sure that the DTC service is running. Not only should it be running but it should probably also be set to...
--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)

July 13, 2010 at 10:33 pm

#1192513
RE: query like or something similiar

John N (7/13/2010)
Figured it out.. use SOUNDEX right?
I'm pretty sure I wouldn't use SOUNDEX... it's a little too "fuzzy" for my taste.
I haven't had to use it myself but...
--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)

July 13, 2010 at 10:28 pm

#1192510
RE: Help Understanding Row_Number

RakeshRSingh (7/13/2010)
As per the execution of the SQL Statements that you have provided,
1. First the From clause will be processed
2. Then WHERE clause will be processed
3. Then SELECT clause will...
--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)

July 13, 2010 at 10:22 pm

#1192506
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

A short, sweet, and brilliant article! Bravo Stephen and spot on on all points especially on working with your "customers".
There's only one problem with the scenario you're given... what...
--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)

July 13, 2010 at 10:11 pm

#1192504
RE: Does adding Primary and Foreign Keys to an existing database mess with your SPs?

I agree with the others. Things could break if the DRI is violated or PKs aren't created using IDENTITY, etc.
My recommendation would be to do the same thing as...
--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)

July 13, 2010 at 9:42 pm

#1192497
RE: SQL DBA to BI Developer Role

deepthi818 (7/13/2010)
Hi all
I am an SQL Server DBA with 3 years of experience, I have some experience in SSIS. I am not an expert in SSIS, but am looking at...
--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)

July 13, 2010 at 9:31 pm

#1192496
RE: History Table

mbender (7/13/2010)
I plan on creating a sql trigger that before and after an update it inserts the data into a transaction history table. That way I have a before...
--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)

July 13, 2010 at 9:28 pm

#1192495
RE: SSIS - importing 1000 tables

mazzz (7/13/2010)
Thanks Tod.
It's as I feared then - I will at any rate have 1000 distinct OLE DB Sources/Destinations to put together.
I counted the tables, there are actually 3000 of...
--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)

July 13, 2010 at 9:22 pm

#1192493
RE: Suggestion for points

Heh... who's going to decide what a good answer is... the Original Poster? Let me tell you some of the reasons why that's such a bad idea...
1. Despite...
--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)

July 13, 2010 at 9:10 pm

#1192490
RE: Table as parameter

Here's an article on passing data as if it were a 1, 2, or 3 dimensional array...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

July 13, 2010 at 8:51 pm

#1192488
RE: Try Catch alters behaviour of existing procedures

doobya (7/12/2010)
His post did not add anything to the discussion - it was therefore light trolling
forum dwellers do tend to get upset when the status quo / comfort zone of...
--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)

July 13, 2010 at 7:42 pm

#1192480

Viewing 15 posts - 37,681 through 37,695 (of 59,072 total)