Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,731 through 32,745 (of 59,099 total)

RE: Looking for a no-cost issue tracker

shew (8/25/2011)
paul.knibbs (8/25/2011)
Of course, all this lockdown presumably only applies to Windows machines...can't you set up Linux on an old PC and put Eventum or something on it? 😛
Afraid not....
--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)

August 26, 2011 at 7:33 am

#1373755
RE: how to get grand total row in pivot concept??? urgent plz...... Thank u all

kavinithi (8/25/2011)
i want to have a summerized row at the end of my result.
I used pivot concept in my procedure. How can i add a row at the end...
--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)

August 26, 2011 at 7:01 am

#1373737
RE: Running totals

cidr (8/26/2011)
That's fine and I have created the query like so
SELECT a.Day, a.Salesman, sum(Sales),
(select sum(Sales)
from Net_Sales b
where b.DaY <=...
--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)

August 26, 2011 at 6:53 am

#1373730
RE: Would You Rather Work for a Strong or Weak Manager?

hlewis (8/26/2011)
I want a manager who is brave. Brave enough to protect the team and our work from outside pressures, and brave enough to address issues within the team....
--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)

August 26, 2011 at 6:40 am

#1373720
RE: Text to Columns in SQL

R.P.Rozema (8/25/2011)
:-D, still there is a reason for them being in this example: I generate a lot of my code, and leading comma's happen to be a lot easier 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)

August 26, 2011 at 6:19 am

#1373707
RE: Split function in SSRS report

I strongly recommend not using any split function that has a WHILE Loop in it. Please see the following article:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
--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)

August 25, 2011 at 5:32 pm

#1373549
RE: urgent Help required in Fuzzy matching using sql server

You could always do a join on LIKE with a trailing wild-card.
--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)

August 25, 2011 at 5:14 pm

#1373547
RE: Stored Procedure's Security

Robert Cain (5/4/2010)
Access? Good heavens I hope not.
You might look at SQL Server Compact Edition, not sure your exact requirements but it's small, light weight, and if you give...
--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)

August 25, 2011 at 4:20 pm

#1373541
RE: How to import multiple CSV files.

Any idea how long it would take without the firewall monitoring? The reason I ask is that I've seen BULK INSERT import 5.1 million, 20 column rows from 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)

August 25, 2011 at 4:14 pm

#1373539
RE: Text to Columns in SQL

Sriram.RM (8/4/2011)
Gianluca Sartori (8/4/2011)
I guess you need a splitter function, such as the great one desribed by Jeff Moden in his article here[/url].
If you like his code, please consider voting...
--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)

August 25, 2011 at 3:59 pm

#1373530
RE: Text to Columns in SQL

R.P.Rozema (8/4/2011)
Even though I personally don't share the ideas that it reads and looks better.
BWAA-HAAA!!!! When leading commas are present, neither do I! 😀
--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)

August 25, 2011 at 3:55 pm

#1373528
RE: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

WayneS (8/25/2011)
Jeff Moden (8/25/2011)
Great article, Wayne, although I'm a bit surprised you didn't publish the million row performance findings (like you did on your blog) which shows just how big...
--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)

August 25, 2011 at 3:41 pm

#1373525
RE: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

Great article, Wayne, although I'm a bit surprised you didn't publish the million row performance findings (like you did on your blog) which shows just how big a performance 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)

August 25, 2011 at 2:17 pm

#1373490
RE: How to import multiple CSV files.

Aiello DBA (8/25/2011)
SSIS have no problem with large files. I use it to import cvs files about 7G every day (6 millions rows) and have no problem.
-
Lic. Andrés M. Aiello
DBA...
--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)

August 25, 2011 at 10:40 am

#1373338
RE: import flat file through SSIS

Crud... BCP format files won't accept "smart quotes" as valid delimiter characters. It'll take regular quotes when you "escape" them with a backslash, but it just won't take 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)

August 24, 2011 at 9:46 pm

#1372930

Viewing 15 posts - 32,731 through 32,745 (of 59,099 total)