Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,891 through 19,905 (of 59,072 total)

RE: Which is Best to use, #Temp Table or @Table Variable?

pdanes (8/14/2015)
If you are manually running some code in SSMS, table variables have the additional advantage of being generated fresh on every run. Temp tables stay around, and you have...
--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 14, 2015 at 8:44 am

#1820079
RE: Help Needed in Processing Data

Just checking. You DID intent to NOT import the Name field from the file, correct?
--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 14, 2015 at 7:29 am

#1820043
RE: Help Needed in Processing Data

{EDIT} I previously suggested using BULK INSERT and now I see there's an identity column and a couple of unwanted columns. Still a job for BULK INSERT but we...
--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 14, 2015 at 7:07 am

#1820033
RE: The Tally Table

Eric M Russell (8/13/2015)
Long overdue praise for the lowly tally table. I declare August 33rd as the official Tally Table Appreciation Day.
Ugh! That would mean that I'd have 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 13, 2015 at 8:27 pm

#1819936
RE: The Tally Table

Knut Boehnert (8/13/2015)
Knowing how and what to use a tally table for is not a core skill.
Working in sets of data instead of RBAR of data is a core skill....
--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 13, 2015 at 8:23 pm

#1819935
RE: Which is Best to use, #Temp Table or @Table Variable?

caojunhe24 (8/12/2015)
#temp is much more useful than @temp
Care to share any of the reasons you think so? Without such a list, you comment is just an opinion.
--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 12, 2015 at 3:29 pm

#1819518
RE: Triggers Logging

deebabat (8/11/2015)
Please I would like to know how to log how many times a trigger fires.
Why? I ask because it may help figure out the best way for 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)

August 12, 2015 at 12:19 am

#1819217
RE: How to insert CSV data into DB where some data don't have double quotes

Which are you going for? The fixed field lengths or the comma delimited? If the comma delimited, then change all but the first field length to 500 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 12, 2015 at 12:10 am

#1819216
RE: charindex/substring to replace varying amounts of '/'

Luis Cazares (8/11/2015)
A slightly different version of Eirikur's code. This is just to give you more ideas on the different possibilities to solve your problem.
DECLARE @sourcedata TABLE(STR_DATA VARCHAR(100) NOT NULL);
INSERT...
--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 11, 2015 at 6:40 pm

#1819193
RE: Strategies for working with multiple platforms

Personally, I'd study the environment and find all the shortcomings and dangers in the environments. Then, make a plan to homogenize the environment a bit along with an explanation...
--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 11, 2015 at 6:04 pm

#1819191
RE: Making Guesses

David.Poole (8/11/2015)
There is a level of hell where you get committed to estimates before you find out the subject of the estimate.
Does anyone have any experience of estimates that have...
--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 11, 2015 at 5:08 pm

#1819189
RE: Are the posted questions getting worse?

Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 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)

August 11, 2015 at 11:23 am

#1819066
RE: script to list all database level permissions in a Database

You folks should write and article each on these. Throw in something about sp_ValidateLogins and both would be to kill for.
--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 11, 2015 at 11:15 am

#1819065
RE: Can I display all the days in a range even with no data ?

sgmunson (8/10/2015)
Given the rather small size of the likely range of values here, any suffered performance is likely to be irrelevant, and the recursive CTE is 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 11, 2015 at 8:16 am

#1818969
RE: Mistery never ending query

ricardo_chicas (6/3/2013)
...and sql server 2012 RTM in it
2012 had some serious problems. If you're not running at least SP2 CU6, then you're wasting your time trying to tweek any...
--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 11, 2015 at 8:05 am

#1818958

Viewing 15 posts - 19,891 through 19,905 (of 59,072 total)