Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,921 through 19,935 (of 59,098 total)

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
RE: Making Guesses

Disk space actually isn't cheap if you have no more space in a rack and have to meet the corporate standard of "all disks must be properly racked in 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 11, 2015 at 8:00 am

#1818956
RE: Pivot Tables v Reports

ps_vbdev (8/11/2015)
When i get requests in from departments regarding MI i always try to deliver using ssrs. There is an old school in the company that insist on using excel...
--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 7:58 am

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

Ken Tot (8/11/2015)
Example of data in CSV are as follows:
"XXX","0001",-990039739 ,0 ...
--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 7:53 am

#1818952
RE: Restricting Sysadmins from adding new sysadmins

Steve Jones - SSC Editor (8/10/2015)
I think the design of many of these auditing products is to log and detect issues, not prevent them. Nor should they be under 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 11, 2015 at 7:43 am

#1818947

Viewing 15 posts - 19,921 through 19,935 (of 59,098 total)